Tag Archives | SQL. T-SQL

List all triggers in SQL Server database with table name and schema

Sample query: Here is and another version where you can the code of the trigger:

Read full story Comments { 0 }

Microsoft SQL Insert Trigger to Get Current Datetime Value

This script gets the datetime value in this format MM/DD/YYYY:HR:MI:SSPM or AM. I could have used the CAST or CONVERT option but the did not reproduce the result that I wanted.  There are some option in CONVERT option but they converts into a 24hr format. Here is my trigger for insert event. USE dwdata GO […]

Read full story Comments { 0 }

Microsoft SQL Server 2008 Editions and Limitations Overview

Microsoft SQL Server 2008 Editions and Limitations Overview

Read full story Comments { 0 }

T-SQL CASE Function – Microsoft SQL

T-SQL CASE Function – Microsoft SQL

Read full story Comments { 0 }