T-SQL Examples – SQL 2012

Just some random T_SQL examples from SQL Server 2012

Enable/Disable Triggers:
An alternate syntax to enable and disable triggers:
disable trigger trgTest on dbo.Table
enable trigger trgTest on dbo.Table

instead of using ALTER TABLE.

Move Objects To A Different Schema:
For example, to move the object testProc from the ‘test’ schema to ‘dbo’:
alter schema dbo transfer test.testProc

Rename A Database:
exec sp_renameDb ‘OldName’, ‘NewName’

Create A Time From Hour, Minute and Second Values
select TimeFromParts(hour, minute, seconds)
Where hour, minute and seconds are integer values