Sql Server

• Case-sensitive check/search/match in T-SQL - Sql Server 2005
• Get AM/PM in Sql Server DateTime Format
• Replace/Remove Special Characters in Sql Server 2005/2008
• Create Linked Server in Sql Server 2005
• Alter/Change new Default Value of a Column in already created Table
• T-SQL to Disable/Enable Job in SQL Server 2005
• Invoke URL from Sql Server 2005 Stored Procedure
• T-SQL to change schema/owner name in Sql Server
• Delete Statement with inner join in Sql Server 2005
• Transpose Rows to Columns in Sql Server 2005 using PIVOT
• Transpose Columns to Rows in Sql Server 2005 using UNPIVOT
• Split Function in Sql Server to break Comma-Separated Strings into Table
• Delete duplicate rows on table with/without primary key in Sql Server 2005
• Sql server: Special Characters (%,[,]) in LIKE operator using ESCAPE keyword
• Pagination in Sql Server 2005
• Transact-SQL to get description of column in Sql Server 2005 using fn_listextendedproperty
• Search text/string|Find keyword in Sql Server Function and Procedure
• Title case (Proper case) Function in Sql Server 2005
• Cursor For Converting Rows to Column in Sql Server
• Changes Row to Columns (Transpose) in Sql Server 2005 using COALESCE