SQLShare SQL Channel

The SQL Channel

Sponsored Ads

This channel is dedicated to SQL Server and the technologies that surround it. You'll find videos about SSIS, Replication, Performance and more. Check back daily for updated content.

Using a Server Trigger to Dropping a Database (Watch it later!)

	Featured Video
Date Published: Thursday, February 04, 2010 Author: Chris Skorlinski Rating: 4.05

Description: This video shows how you can create a server trigger in SQL 2008 to log and/or prevent dropping a database. It's a great into to server triggers.

New Releases

Setting the Identity Property of a Column (Watch it Later!)

Date Published: February 05, 2010

Author: Andy Warren

Rating: 4.37

Description: SQL provides the identity property to give us the ability to have a column that auto increments (auto number) and it's very easy to work with. The default works well of starting at one and incrementing by one, but you do have other options, and it doesn't have to always be an integer column either. A quick run through that shows you what you need to know to add this to your table design.

	Using the Identity Function (Watch it Later!) Date Published: February 04, 2010 Author: Andy Warren Rating: 4.28 Description: This is very much a niche technique, a way to add a column that has the identity property set when you create a table using SELECT INTO. While you may not use it often, it can be a useful thing to know about for the rainy day when you need it.

Using Identity Insert to Insert Rows (Watch it Later!)

Date Published: February 02, 2010

Author: Andy Warren

Rating: 4.47

Description: If you've ever worked with a table that includes a column that is set to an identity (auto number) you know that happiness is nicely ascending keys. What happens when someone deletes a row by mistake, how do you put it back? By default if you specify a value for the identity column an error message is generated, which brings us to our topic today - identity insert!

	Using @@Version and xp_MSVer to Get Your SQL Version (Watch it Later!) Date Published: February 01, 2010 Author: Andy Warren Rating: 4.37 Description: Are you on the latest and greatest service pack? Not even sure what version of SQL Server you're running? Running a simple query using @@Versionor xp_msver will give you all the information you need!

Using the @@Rowcount Function (Watch it Later!)

Date Published: January 26, 2010

Author: Andy Warren

Rating: 4.36

Description: The system function @@Rowcount returns the number of rows affected by the last operation. It's easy to forget that things like SET and PRINT are operations too, and that can change the value that you get. We've got some very short and simple demos that should clarify the behavior and show you how to use it in production code.