Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inserting and selecting at the same time
Message
De
23/09/2013 13:13:10
Naomi Nosonovsky
Wisconsin, États-Unis
 
 
À
23/09/2013 12:44:47
Christian Isberner
Hannover, Allemagne
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Re: Inserting and selecting at the same time
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01583879
Message ID:
01583913
Vues:
29
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform