Very true

And frankly, I see little reason...

Hugo,

Thanks for the input.

Which would you say is correct, the implementation as it stands or BOL?

Anyone care to lend their opinion to a discussion prompted by todays QOD here, please?

da-zero (4/19/2010)

---

I interprete it as:

SCOPE_IDENTITY returns the value of the last identity value inserted in the same scope. Since the scope is the whole batch, it doesn't matter if the...

da-zero (4/19/2010)

---

They are yes, but I'm not sure how...

da-zero (4/19/2010)

---

nigel. (4/19/2010)

---

Andrew Watson-478275 (4/19/2010)

---

A more interesting result is from this:

DECLARE @sid int

DECLARE @table Table (KeyID int primary key,KeyData varchar(5))

DECLARE @idtable Table (KeyID int identity primary key,KeyData varchar(5))

INSERT...

Andrew Watson-478275 (4/19/2010)

---

A more interesting result is from this:

DECLARE @sid int

DECLARE @table Table (KeyID int primary key,KeyData varchar(5))

DECLARE @idtable Table (KeyID int identity primary key,KeyData varchar(5))

INSERT INTO @idtable...

There are several ways you could do this, none of which involve generating the error reports in advance.

Two possibilities are either use either a report (SSRS) or ASP.net page that...

No, I believe you are mistaken.

Please explain why you think using parameterized stored procedures opens you...

See [font="Courier New"]User.UserID[/font] here

Try here

You shouldn't need to do anything as complicated as splitting/dividing your date field, as long as it is of the datetime data type.

A simple delete staement like the following...

Thanks Paul,

They could come in really handy. Oh, if only I had 2008, 😀 and the time to play.

I'd not even noticed this was in a 2008 forum :blush:

Try this: CROSS JOIN

Very good question.

However I think that the explanation is a bit lacking, and could explain in more detail what is happening here and what a 'cross join'/'cartesian product' is.

Here...