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 [...]

Database Schema online

WWW SQL Designer
Actual Site: http://ondras.zarovi.cz/sql/
Download software link : http://ondras.zarovi.cz/sql/sql-1.4.zip
http://ondras.zarovi.cz/sql/demo/
http://www.shdev.de/sqldesigner/index.php?keyword=ContactR
Design your schema online and you can even access to your previously defined schema.
With this tool you can see the current DB Design and even Modify it. So if you have any proposals for improving the database design or find some major flaws you can post it as [...]

Main SqlServer Helping link

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