Logiclabz

Recent Posts in Sql Server

• Selecting Random Rows from a Table in SQL Server
  03-Feb-2012
  Optimized way of Selecting Random Rows from a Table in SQL Server. Simple alternative to NEWID() fun
• Useful SQL Server Management Studio Keyboard Shortcuts
  24-Jan-2012
  List of some userful SQL Server Management Studio Keyboard Shortcuts
• Case-sensitive check/search/match in T-SQL - Sql Server 2005
  08-Dec-2011
  To do a case sensitive check/search/match in sql server t-sql queries and if condition
• Get AM/PM in Sql Server DateTime Format
  13-Jun-2011
  Get AM/PM in Sql Server DateTime Format
• Replace/Remove Special Characters in Sql Server 2005/2008
  03-Jun-2011
  SQL Server user-defined function to replace or remove special character supported in both sql server
• Create Linked Server in Sql Server 2005
  21-Sep-2010
  T-SQL query to create a linked server in sql server 2005
• Alter/Change new Default Value of a Column in already created Table
  21-Jul-2010
  Change or alter default column value of already created table with new default value.
• 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.