从MS SQL Server获取自动编号主键

I am currently working in C#, and I need to insert a new record into one table, get the new primary key value, and then use that as a foreign key reference in inserting several more records. The Database is MS SQL Server 2003. All help is appreciated!I am currently working in C#, and I need to ins