Backup and Restore:
http://blog.sqlauthority.com/2013/02/08/sql-server-backup-and-restore-database-using-command-prompt-sqlcmd/
Command-line stuff:
http://stackoverflow.com/questions/8693561/how-to-use-sqlcmd-to-create-a-database/8693578#8693578
http://msdn.microsoft.com/en-us/library/ms188247(v=sql.105).aspx
Data Types and comparison with Oracle data types:
http://www.mssqltips.com/sqlservertip/2944/comparing-sql-server-and-oracle-datatypes/
http://www.w3schools.com/sql/sql_datatypes_general.asp
Salvaged From del.icio.us:
Getting the identity of the most recently added record
SCOPE_IDENTITY (Transact-SQL)
@@IDENTITY (Transact-SQL)
SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record « Journey to SQLAuthority
SQL Server T-SQL Cheat Sheet
How to configure SQL Server 2005 to allow remote connections
InformIT: SQL Server Reference Guide > SQL Server Instances
No comments:
Post a Comment