My table stores information about files stored in the file system. I need to use the ID assigned by the database (primary key) in the file name. Is there a way to use the ID being assigned in the INSERT statement or will I have to make an INSERT statement,
then get SCOPE_IDENTITY(), then do an UPDATE?
Table looks something like this:
FileID int (PK)
Here's an example of what I'm trying to do:
INSERT INTO MyFiles
(-- ??? Not sure what goes here)
View Complete Post