Working with Defaults and Constraints

Defaults are a pretty basic concept, specify a value to be entered if no value is provided, yet just doing that is often a key step in database design. In this lesson we'll show you how to manage defaults in the graphical designer and from TSQL, introduce newsequentialID and show you sp_helpconstraint too.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Bill Johnson on 4/8/2010

Another nice job! Thanks.

Craig Moore on 4/8/2010

I think this site is great, I'm a newer user of SQL and to get quick tips/tricks is really nice. Thanks

sampath on 4/8/2010

was too brief and fast

R Michael Lacy on 4/8/2010

Nice job, Andy. Thanks!

Martin Miller on 4/8/2010

Thanks Andy.

Mark Zamoyta on 4/8/2010

Very confusing when trying to save the script near the beginning... I don't know what you're doing really. Is it a Microsoft bug? Are you doing a workaround? The rest of the video is fine.

Mark Zamoyta on 4/8/2010

I'm confused by the part where it doesn't save the script properly. I don't know what you're doing exactly. You say "this script doesn't alter the table" yet the script shows ALTER TABLE statements. You say the script wouldn't impact production, yet management studio definitely generated an error. Other than that it was a good video.

Ron Saxer on 4/8/2010

can't wait for each of these

Munna Bhai on 4/8/2010

Great video....thanks for sharing.

mark brito on 4/23/2010

I find newsequntialid to be very helpful.

Derek on 11/29/2010

Awesome. I had been trying to figure out how to do some of this stuff from Server Management Studio, and that answered a lot of my questions!

Costa on 9/28/2012

Very clear.