Monthly Archives: January 2016

Using “WITH VALUES” in a DEFAULT clause

The WITH VALUES clause is simple to understand. Suppose we have a table called Orders  : Now we add a column with a default value : alter table orders add newcol varchar(100) default 10 insert orders (orderid,orderdate,custid) values (101,getdate(),1) Now … Continue reading

Posted in Uncategorized | Leave a comment