Posts in Category: Transact SQL

-June 2017+
SMTWTFS
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

Statistics

  • Entries (3)
  • Comments (0)

Categories

Identity Insert Options 

Posted by Philip Leitch Friday, August 7, 2009 1:45:00 AM Categories: Transact SQL
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, across all ... read more
 

Hypothetical Indexes 

Posted by Philip Leitch Friday, August 7, 2009 1:38:00 AM Categories: Transact SQL
Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable mso-style-name:"Table... read more
 

SP_ Prefix 

Posted by Philip Leitch Saturday, June 20, 2009 12:20:05 AM Categories: Transact SQL
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
 
Copyright 2009 Philip Leitch