Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting and selecting at the same time
Message
From
23/09/2013 13:13:10
Naomi Nosonovsky
Wisconsin, United States
 
 
To
23/09/2013 12:44:47
Christian Isberner
Hannover, Germany
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Inserting and selecting at the same time
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01583879
Message ID:
01583913
Views:
30
You can not use dynamic SQL inside a function. You can create stored procedure that will insert data into a table and return ID. However, I don't recommend to make this procedure dynamic.

You may find this post helpful

How to insert information into multiple related tables and return ID using SQLDataSource
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform