Error Handling

Code:
INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition
 
Ok I was correct in my thinking.

I do have a follow up question though (sorry since I feel like I am pestering).
I have very very little experience in regards to functions. So I wrote it all out and it is returning my new ID number correctly, but how does my main get that? Does my NewID's value become what the function returned or do I have to set it in some manner to make it what the function returned?
 

Users who are viewing this thread

Back
Top Bottom