Examples of SQL Script

[bryant89]

Does anyone know of a site where I can find examples of SQL Scripts. I need to know how to create a record and retrieve the id from the same record all at the same time.

 

[foxdev]

[tt]-- your insert statement, then
select @@identity[/tt]

Try

http://www.mssqlserver.com

and

http://www.swynk.com/sysapps/sql.asp

Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[bryant89]

Thanks Robert,

I dont understand how to write an insert just to create a record where only the autonumber field needs to be generated/executed. This is called using T-SQL right? Where you can essentially create stored procedures. More of a dynamic SQL? I will read up on the articles you gave me and see what I can do.

Thanks