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:
Sample query: Here is and another version where you can the code of the trigger:
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 /* —————————————————————————– www.myw0.com, Version 1.0, Creation Date: 11/05/2014 Functionality: Generate Datetime values into a text field —————————————————————————– */ if exists (select * from sysobjects…
Microsoft SQL Server 2008 Editions and Limitations Overview
T-SQL CASE Function – Microsoft SQL