SQL SCRIPT GENERATOR

If you want to create Database Scripts, Object Scripts or  insert statements of  SQL server database, download this file SQL SCRIPT GENERATOR and convert its extenstion to *.rar and then extract it
go to bin’s folder and execute “GenDBScripts.exe” and enjoy

Change ownership – SQL server

DB TAbLES
=========
DECLARE @old sysname, @new sysname, @sql varchar(1000)
SELECT
  @old = ‘oldOwner_CHANGE_THIS’
  , @new = ‘dbo’
  , @sql = ‘
  IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES
  WHERE
      QUOTENAME(TABLE_SCHEMA)+”.”+QUOTENAME(TABLE_NAME) = ”?”
      AND TABLE_SCHEMA = ”’ + @old + ”’
  )
  EXECUTE sp_changeobjectowner ”?”, ”’ + @new + ””
EXECUTE sp_MSforeachtable @sql
STORED PROCEDURES
=================
DECLARE @old sysname, @new sysname, @sql varchar(1000)
SELECT
@old [...]

CAST and CONVERT (T-SQL)

Explicitly converts an expression of one data type to another. CAST and CONVERT provide similar functionality.
Syntax
Using CAST:
CAST(expression AS data_type)
Using CONVERT:
CONVERT (data_type[(length)], expression [, style])
Arguments

expression
Is any valid Microsoft® SQL Server™ expression. For more information, see Expressions.
data_type
Is the target system-supplied data type. User-defined data types cannot be used. For more information about available data [...]

Main SqlServer Helping link

http://www.sql-server-helper.com/

Extended DateFormats (SQLserver)

Extended Date Formats

Date Format
SQL Statement
Sample Output

YY-MM-DD
SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, AS [YY-MM-DD]
99-01-24

YYYY-MM-DD
SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD]
1999-01-24

MM/YY
SELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 3), 5) AS [MM/YY]
SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 3), 4, 5) AS [MM/YY]
08/99

MM/YYYY
SELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 103), 7) AS [MM/YYYY]
12/2005

YY/MM
SELECT CONVERT(VARCHAR(5), GETDATE(), 11) AS [YY/MM]
99/08

Month DD, YYYY 1
SELECT DATENAME(MM, GETDATE()) + RIGHT(CONVERT(VARCHAR(12), GETDATE(), 107), 9) AS [Month DD, [...]