Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-29 : 11:52:20
|
Gêêtz writes "Hi,
i have a database in which all the tables need a generated value to set in a field. This value is a combination of a field called code stored in a table called m_company , whose ID is referenced in all other tables..and a incremented number.
now wot i need to do is create a single procedure which will be called from the insert trigger of all tables ..and i'll be passing a string value for the table name to the proc... for the second part of the generated val i.e the incremented number i need to build a select based on the table name passed to the proc..now the problem is sp_executesql returns a result set object ..which i can't use (or can i??) . can anybody puhleez tell me how i can solve this problem ....rite now i've written this logic in all insert triggers ...which i want to scrape off!!
thanx in advance" |
|
|
|
|
|
Return values from dynamic sql!!