• deeptidas23 (12/30/2010)


    when we run it on sql server only one record is getting stored in table becoz of check constraint.how come only 3 records??Can anyone explain me after executing in sequel

    If you executed the script exactly as shown, there would not have been a check constraint. The ALTER TABLE statement that creates it has a syntax error, and therefore is not executed.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/