Logiclabz

Recent Posts in Sql Server

• T-SQL to Disable/Enable Job in SQL Server 2005
  04-Mar-2010
  The T-SQL query to enable or disable specific sql server job in sql server 2005.
• Invoke URL from Sql Server 2005 Stored Procedure
  03-Mar-2010
  Sql Server T-SQL to invoke url there by send mail or sms through stored procedure
• T-SQL to change schema/owner name in Sql Server
  07-Aug-2009
  T-SQL query to change schema/owner name of all tables and stored procedures in Sql Server.
• Delete Statement with inner join in Sql Server 2005
  21-Jul-2009
  The Sample T-SQL query for delete statement with inner join clause in sql server 2005
• Transpose Rows to Columns in Sql Server 2005 using PIVOT
  27-May-2009
  Sample T-SQL query to convert rows to columns in Sql Server 2005 using PIVOT relational operator.
• Transpose Columns to Rows in Sql Server 2005 using UNPIVOT
  25-Apr-2009
  Sample T-SQL query to convert Columns to Rows in Sql Server 2005 using UNPIVOT relational operator.
• Split Function in Sql Server to break Comma-Separated Strings into Table
  05-Mar-2009
  The Split function in sql server to split comma-separated values into temporary table with individua
• Delete duplicate rows on table with/without primary key in Sql Server 2005
  14-Feb-2009
  The sql server query to delete duplicate records on table with/without primary key in Sql Server 200
• Sql server: Special Characters (%,[,]) in LIKE operator using ESCAPE keyword
  15-Jul-2008
  Finding special characters such as angel brackets([,]), Percentage(%), Underscore(_) in SQL server C
• Pagination in Sql Server 2005
  08-May-2008
  Generating Paging in Sql Server 2005 using ROW_NUMBER() function