create table snapdeal_orders ( order_Id int not null, -- now we can not add null value in column order_id , not null constraint order_date date, -- "yyyy-mm-dd" is standard format product_name varchar ...

I've got an interesting constraint I'm trying to add to our database. I can do with with triggers, but am curious if there is a more elegant way to do this in T-SQL (SQL2005, FWIW) We have two ...

Prevent bad data in nchar, nvarchar, char, varchar columns via trigger or constraint - zgstumpf/sql-server-invalidstring ...