Thursday, December 27, 2007

Head First SQL gotchas with SQLServer 2005 (1)

I have been working through Head First SQL and have run into a few differences between SQLServer and MySQL (recommended to use with the book).

instead of desc for describe table, use sp_colums {table name} or sp_help {table_name}

in one example they use date as the data type, datetime must be used

the insert with multiple values will not work as they have it - this website has a solution http://blog.sqlauthority.com/2007/06/08/sql-server-insert-multiple-records-using-one-insert-statement-use-of-union-all/

more as I run across it