Posted by Philip Leitch
Friday, August 07, 2009 12:45:17 AM
Here are the Help definitions:
IDENT_CURRENT returns the last identity value generated for a specific table in any session and any scope.
@@IDENTITY returns the last identity value generated for any table in the current session,...
read more
Posted by Philip Leitch
Friday, August 07, 2009 12:38:33 AM
Normal
0
false
false
false
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table...
read more
Posted by Philip Leitch
Friday, June 19, 2009 11:20:05 PM
What is it?
SP_ indicates a "System Procedure". Any user with enough rights can create a system procedure.
What does it do?
They provide global scope to a Stored Procedure. A procedure is normally only visible when it exists in the...
read more