A look at the BOL chapters that have been mentioned here, should help you figuring out, what you did wrong with SCOPE_IDENTITY() and why this didn't work for you.

I don't know VB.Net, but see if this helps a bit:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_1zuc.asp

Actually this depends on the requirements, which haven't been stated yet.

Thanks! Nothing beats first-hand information, Scott!

There should be no need to use something like DATEADD. Since DATEPART returns an INTEGER you can simply do:

SELECT

 DATEPART(SECOND,GETDATE())+1

to add a second.

< vbg > Actually I'm missing Kenneth's usual 'It depends...' comment. 

IIRC, read IDENT_CURRENT in BOL. There's an example of when to use what....

Thanks for the explanations! Seems like a very long weekend for Scott Cate I re-registered and hope they will be back soon.

This is not directly related to Java, but see, if it helps:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

There is no black or white answer to this question. That really depends on what you want to do with these columns. For monetary units and calculations certainly DECIMAL is...

I like this idea, though for obvious reasons won't maintain one myself. If you decide so, consider establishing a RSS feed for them

Here we go:

create database test_me

go

use test_me

go

declare @i int

declare @stmt nvarchar(4000)

create table t_master(c1 int primary key default 1)

set @i=1

while @i<=1009

begin

 set @stmt = 'create table t_child'+cast(@i as nvarchar)+' (c1 int foreign key...

Sir, yes, Sir! This is understood!

Just made a small script to test this. All tables and references will be created. No error message....

Damn, didn't think of this. Never tried that before with that much FK's, but this could very well be the reason. But what really interesting is, how did you manage to create...

See, if this helps explaining in detail what noeld meant:

http://www.sommarskog.se/dynamic_sql.html

Have a look at DBCC CHECKTABLE in BOL.