Already answered on your other thread:

http://www.sqlservercentral.com/Forums/Topic906477-391-1.aspx

DECLARE @People

TABLE (

person_id INTEGER PRIMARY KEY,

data ...

Also:

-- Method A

SELECT TOP (1) *

FROM (

SELECT TOP (43) *

...

Or a UNIQUE constraint, as the QotD explanation says 😉

While we are mentioning alternatives, not everyone knows about the useful tablediff utility shipped with SQL Server:

tablediff Utility

And you were probably right! Just making...

The following code shows how to use the procedure return code to identify the error number:

USE tempdb;

GO

CREATE PROCEDURE dbo.SP1

AS

BEGIN

SET ...

It is more efficient to adjust the data type after the aggregate:

DECLARE @Example

TABLE (

month_id ...

Have you considered using an SSIS package?

Huge subject. Please take a look at this:

http://www.sqlservercentral.com/articles/books/65831/

...note the free eBook download. The author is a regular here on SSC.

anthony_merriwether (4/19/2010)

---

Someone gave an example about a DBA asking a basic question that was readily available to him or her that was easily solved by a little of effort. ...

Not sure what you mean here, Matt. Are you...

Given the number of inconsistencies and bugs, I'd be quite happy to see @@IDENTITY and SCOPE_IDENTITY removed from the product. I very much prefer the OUTPUT clause for this...

First correct answer! Yay for me 😉

I liked this question - especially the first part about IDENTITY allowing duplicates, which I am sure will surprise many people.

I am less...

Either, so long as it meets the requirements. If you are...