Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record ID generator question
Message
From
23/09/2002 21:37:24
 
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00605839
Message ID:
00703620
Views:
36
>>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
Map
View

Click here to load this message in the networking platform