Logiclabz

Recent Posts in Sql Server

• 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
• Title case (Proper case) Function in Sql Server 2005
  09-Apr-2008
  This function in sql server will help you change to proper case of the given string
• Cursor For Converting Rows to Column in Sql Server
  30-Apr-2008
  This cursor can be used create single column with comma separation of given rows
• Changes Row to Columns (Transpose) in Sql Server 2005 using COALESCE
  16-Sep-2008