update dbo.[sample]

set platform_id= 'REI', creation_dt= '2009-02-29'

where Row_id between 144000 and 144100

The last batch of transation is firing the error as Feb 2009 in not leap year.

SQL Server Books Online and Adventureworks DB is the best combination to start with:-)

A table can have 1 clusted index and 999 non clustered index and the number of key column is limited to 16

friend,

First check for the existance for the table by quering "sysobjects"

system table. if the values return is true then allow the select statement to execute. Else move out from the...