Logiclabz

Recent Posts 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
• Transact-SQL to get description of column in Sql Server 2005 using fn_listextendedproperty
  14-Feb-2009
  Transact-SQL to get the description property of the column in sql server 2005 using fn_listextendedp
• SQL to Grant EXECUTE permission to all Procedures and Functions
  16-Apr-2008
  Transact-SQL to Grant EXECUTE permissions to a user for all User-defined Procedures & Functions
• Search text/string|Find keyword in Sql Server Function and Procedure
  05-Aug-2009
  To find a text or string or keyword across all stored procedures and functions of sql server 2005 us