General information
Forum:
Microsoft SQL Server
>>Yes, misspelling is a problem. On the other hand, it would simplify updating a client site as product evolves and new tables are added.
>
>True, but you could do the same thing explicitly with a script when the application was deployed.
>
>To answer your original question, if the variable's value was NULL, the requested table probably didn't exist and you could insert the row at that point.
>
>But I still don't think it's a good idea.
>
Mike, sorry to continue this. Assuming the SP is called from the Insert trigger of the table, is there any way for the SP to know from what table's event it was called? Something like a @@variable that told?
Thanks again.
Alex
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