General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Hi!
I don't understand the second question,
but for the first one I think this could be helpfull:
instead of:
@cSQLCmd = 'SELECT ' + cSQLLine + ' FROM INSERTED'
INSERT INTO #TempTbl EXEC (@cSQLCmd)
you can do this:
@cSQLCmd = 'SELECT ' + cSQLLine + ' INTO ' + @cTempTbl + ' FROM INSERTED'
having in @cTempTbl the name of your temporary table.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only