9 this answer 9 the last 9 share improve 9 returns the 9 of the 9 improve this 9 difference between 9 add a 9 a comment 9 17 at 8 will return 8 return the 7 value generated 7 Dec 17 7 comment BUTTON 7 17 09 7 09 at 6 you have 6 the trigger 6 stored procedure 6 Jul 30 6 in the 6 if you 6 badges answered 6 badges add 6 answer edited 6 30 17 5 the same 5 Identity Identity 5 identity created 5 edited Jul 5 a trigger 5 at 9 5 at 13 5 answered Dec 5 and the 4 to get 4 the value 4 the scope_identity 4 the current 4 SQL Server 4 session and 4 scope_identity and 4 same session 4 is a 4 INSERT statement 4 in a 4 identity column 4 function will 4 from the 4 an INSERT 3 within the 3 Why does 3 when a 3 trigger executes 3 this question 3 the query 3 Stack Exchange 3 silver badges3535 3 Scope_Identity Identity 3 scope_identity function 3 SCOPE_IDENTITY and 3 scope and 3 rory ap 3 robinCTS 5 3 questions and 3 microsoft com 3 means the 3 I would 3 its own 3 it s 3 INSERT INTO 3 If you 3 id from 3 identity of 3 identity function 3 Identity and 3 How to 3 have a 3 gold badges2323 3 get the 3 generated in 3 for the 3 for a 3 badges3535 bronze 3 badges2323 silver 3 at 20 3 at 10 3 an identity 3 and IDENTITY 3 and Ident_Current 3 and answers 3 5 15188 3 15188 gold 2 you want 2 you are 2 will be 2 where the 2 VARCHAR 100 2 value of 2 value A 2 use the 2 used when 2 used to 2 trigger is 2 to the 2 to know 2 to an 2 this session 2 the table 2 The session 2 the OUTPUT 2 the inserted 2 the insert 2 The identity 2 the id 2 the database 2 the bug 2 the answer 2 that you 2 that performs 2 that generates 2 support microsoft 2 statement that 2 statement SCOPE_IDENTITY 2 sql sql 2 sql server 2 specific table 2 situation where 2 silver badges4343 2 Sign up 2 session The 2 session is 2 server identity 2 scope The 2 scope share 2 Scope means 2 response to 2 record added 2 Question feed 2 Privacy Policy 2 own scope 2 OUTPUT clause 2 on the 2 on a 2 of last 2 of a 2 Oct 30 2 new identity 2 nested scope 2 Meta Stack 2 last record 2 know the 2 Jul 7 2 JOIN and 2 it will 2 is not 2 is fired 2 INTO FooLog 2 INT IDENTITY 2 in this 2 inserts a 2 inserting rows 2 insert in 2 inserted record 2 INSERT and 2 in response 2 INNER JOIN 2 in its 2 in any 2 I m 2 i e 2 ID INT 2 Identity of 2 gold badges2727 2 generates a 2 generated by 2 function returns 2 from an 2 for your 2 FooLog LogText 2 fired in 2 executes in 2 executes another 2 en us 2 English Language 2 Don t 2 David Freitas 2 database connection 2 CREATE TABLE 2 created in 2 created by 2 Computer Science 2 com en 2 check in 2 by the 2 BUTTON Scope 2 between Scope_Identity 2 because of 2 badges4343 bronze 2 badges2727 silver 2 a table 2 at 21 2 at 11 2 a stored 2 a specific 2 A situation 2 a record 2 ap Jul 2 any triggers 2 any session 2 any scope 2 answers for 2 answered Oct 2 answer answered 2 another INSERT 2 an insert 2 a new 2 and this 2 and identity 2 Ali 2 2 added within 2 about the 2 7 15 2 67344 gold 2 30 12 2 2 67344 2 18 at 2 16 at 2 15 at 2 12 at 2 11 at 2 11 16 1 язык Russian 1 русском Code 1 Русский язык 1 на русском 1 you would 1 you understand 1 your team 1 your SQL 1 your RSS 1 your own 1 your list 1 your enterprise 1 you re 1 your coworkers 1 your communities 1 you need 1 you just 1 you insert 1 you don 1 you d 1 you can 1 you and 1 you acknowledge 1 Yodeya Judaism 1 yield from 1 years ago 1 year in 1 year 5 1 x SELECT 1 write thread 1 would use 1 would recommend 1 would love 1 would also 1 worldwide ____________________ 1 World If 1 Worldbuilding Video 1 Work Stack 1 works if 1 works for 1 works best 1 working with 1 Work Here 1 WordPress Development 1 with three 1 with the 1 with SQL 1 with respect 1 with Monica 1 with JavaScript 1 With Introverts 1 within its 1 with Identity 1 with Data 1 with attribution 1 Windows Phone 1 will I 1 Why use 1 Why should 1 who went 1 while the 1 while still 1 while scope_identity 1 which a 1 When should 1 when i 1 when declaring 1 what you 1 what value 1 What s 1 What do 1 what do 1 went to 1 weird and 1 Week StackOverflowKnows 1 Webmasters Game 1 Web Applications 1 way to 1 waves the 1 was introduced 1 want to 1 want but 1 walking pneumonia 1 votes BUTTON 1 view in 1 Viewed 119k 1 Video Production 1 veteran started 1 very nice 1 very easy 1 very clear 1 Vehicle Maintenance 1 varchar and 1 value you 1 value The 1 VALUES x 1 values programmatically 1 VALUES inserted 1 value If 1 value from 1 value for 1 Validated stats 1 Us Stack 1 usr share 1 us library 1 us kb 1 using them 1 Using Select 1 using our 1 using my 1 using identity 1 using either 1 using Connection 1 use two 1 use this 1 use SCOPE_IDENTITY 1 User Web 1 Users Free 1 Users 5 1 User Experience 1 user contributions 1 use cross 1 Use cases 1 use an 1 Usage Skeptics 1 US 2019779 1 URL into 1 up or 1 Update an 1 up 3 1 Unix Linux 1 UNION and 1 UNION ALL 1 understand these 1 understand the 1 understand our 1 under cc 1 Ubuntu Webmasters 1 two database 1 two 0 1 Twitter LinkedIn 1 TV Music 1 t use 1 TSQL select 1 t sound 1 trigger to 1 trigger that 1 triggers you 1 triggers scope_identity 1 trigger So 1 trigger see 1 triggers each 1 triggers doing 1 trigger on 1 TRIGGER InsertFoo 1 trigger IdentCurrent 1 trigger function 1 trigger a 1 Tree Shape 1 Travel Christianity 1 to write 1 to use 1 to understand 1 to this 1 to think 1 to these 1 To summarize 1 To subscribe 1 to RSS 1 to render 1 to read 1 to race 1 to only 1 to mean 1 to insert 1 to find 1 to customize 1 to create 1 To clarify 1 to check 1 to change 1 to bootcamp 1 to be 1 to answer 1 to a 1 t like 1 times BUTTON 1 time it 1 Tidally Locked 1 Thus the 1 throwing an 1 three statements 1 three of 1 three identity 1 thread safe 1 This Week 1 This veteran 1 this URL 1 this to 1 this scope 1 this RSS 1 This is 1 this explains 1 this difference 1 this as 1 this 2 1 think this 1 think about 1 things more 1 things in 1 they mean 1 the time 1 the three 1 the then 1 the stored 1 these methods 1 these Instead 1 these functions 1 The SCOPE_IDENTITY 1 The scope_identity 1 The scope 1 the row 1 The reputation 1 there is 1 the real 1 the queen 1 the problem 1 the parallel 1 The other 1 Theory Worldbuilding 1 the original 1 Theoretical Computer 1 the offline 1 then it 1 then inserts 1 then fires 1 the new 1 them Why 1 them sql 1 the link 1 The last 1 the INSERT 1 the incompatibility 1 the implementation 1 the immediate 1 The idiom 1 The IDENTITY 1 The ident_current 1 The Great 1 the global 1 the functions 1 the first 1 the differences 1 the controversy 1 the command 1 the code 1 the calling 1 the book 1 the A 1 t have 1 that was 1 that then 1 that table 1 that s 1 that queries 1 that OUTPUT 1 that inserts 1 that exists 1 that command 1 that calls 1 that also 1 than the 1 than one 1 than a 1 t forget 1 TeX LaTeX 1 Testing Sound 1 Terms of 1 Technology Life 1 technical talent 1 TeboTebo 12 1 Tebo Dec 1 Teams What 1 Teams Talent 1 Teams Q 1 Teams Private 1 Teams is 1 team 3 1 Talent Hire 1 Talent Advertising 1 talent 5 1 Tags 4 1 tagged sql 1 table So 1 table share 1 table or 1 table in 1 table If 1 table IDENTITY 1 table has 1 TABLE FooLog 1 TABLE Foo 1 table Don 1 table as 1 table and 1 Systems Electrical 1 s used 1 suppose that 1 Super User 1 summarize if 1 Subscribe to 1 subscribe to 1 subject to 1 strings using 1 stored procedures 1 still being 1 s throwing 1 s this 1 staying away 1 stats Theoretical 1 statements An 1 statement 1 1 started a 1 StackOverflowKnows Parties 1 stackoverflo lang 1 stack exchange 1 Stack Apps 1 s subject 1 SSMS executes 1 s scope 1 s result 1 sql Stack 1 SQL connection 1 SQL command 1 SQL and 1 sql 1 1 spot for 1 Sports more 1 SPID Most 1 spell more 1 specialists which 1 Spanish Language 1 spam and 1 source Getting 1 sound like 1 Sound Design 1 So normally 1 somewhere the 1 sometimes produce 1 sometimes it 1 sometimes close 1 something while 1 something being 1 So if 1 so I 1 Software Recommendations 1 Software Quality 1 Software Engineering 1 s manner 1 Skeptics Mi 1 situation is 1 site you 1 site design 1 simple example 1 silver badges905905 1 silver badges8181 1 silver badges77 1 silver badges6161 1 silver badges4646 1 silver badges4242 1 silver badges3636 1 silver badges3030 1 silver badges2121 1 silver badges137137 1 silver badges132132 1 Signal Processing 1 should I 1 should boneheaded 1 SharePoint User 1 share information 1 share applications 1 Shape on 1 s executing 1 set I 1 Set asp 1 session then 1 Session means 1 session maintained 1 session irrespective 1 session but 1 Service 1 1 Server with 1 Server stored 1 Server for 1 Server Fault 1 server code 1 Server can 1 Sequence feature 1 Sep 16 1 sensor does 1 self hosted 1 SELECT SCOPE_IDENTITY 1 select into 1 select inserted 1 select in 1 SELECT Dummy 1 Select 3 1 See my 1 see more 1 see http 1 see here 1 Security Database 1 secure spot 1 Sebastian MeineSebastian 1 Sebastian Meine 1 Seasoned Advice 1 SE answers 1 scope within 1 scope Thus 1 scope scope_identity 1 scope of 1 scope Likewise 1 scope is 1 scope_identity will 1 scope_identity so 1 SCOPE_IDENTITY share 1 SCOPE_IDENTITY returns 1 scope_identity returns 1 SCOPE_IDENTITY IDENTITY 1 SCOPE_IDENTITY function 1 SCOPE_IDENTITY as 1 Scope_Identity and 1 Scope Identity 1 scope ident_current 1 scope i 1 scope as 1 Science Physics 1 Science Philosophy 1 Science Other 1 Science more 1 Science Fiction 1 Science Arduino 1 scid kb 1 scenarios of 1 Sanctuary spell 1 same value 1 same table 1 same scope 1 Salesforce ExpressionEngine 1 Salary Calculator 1 SaktaHemant Sakta 1 Sakta 18722 1 safe SQL 1 sa 4 1 Russian Language 1 RSS reader 1 RSS Question 1 RSS feed 1 r root 1 row you 1 rows on 1 rows and 1 rows 1 1 Row into 1 row For 1 row 1364 1 root usr 1 Role playing 1 role model 1 robinCTS Jul 1 Review Magento 1 rev 2020 1 Return or 1 Return Last 1 retrieval methods 1 results share 1 result on 1 result of 1 result 599 1 respect to 1 resolved and 1 requirement helps 1 required rev 1 reputation requirement 1 reputation in 1 Repair Board 1 render Invertible 1 re looking 1 Related 4528 1 reference see 1 Recreation Science 1 record will 1 record somewhere 1 record ID 1 record from 1 recorded dog 1 record causing 1 recommend to 1 recommend staying 1 Recommendations Signal 1 real mechanics 1 reader https 1 read and 1 read about 1 Reach developers 1 Ratio Featured 1 Raspberry Pi 1 rack Does 1 race conditions 1 question What 1 question The 1 questions tagged 1 questions Related 1 questions Question 1 Questions Jobs 1 Questions Eevee 1 question IDENTITY 1 question from 1 question edited 1 question Earn 1 question Blog 1 Question Asked 1 query while 1 query The 1 query that 1 query or 1 query e 1 query batch 1 queries the 1 queen than 1 Quality Assurance 1 Q A 1 Puzzling Motor 1 Public questions 1 Public 2 1 Psychology Neuroscience 1 protect this 1 projectivity Why 1 programmatically 896 1 Products Teams 1 Products 2 1 Production Seasoned 1 produce a 1 Processing Emacs 1 procedure trigger 1 procedure that 1 procedures 3 1 procedure s 1 procedure P2 1 procedure P1 1 procedure call 1 procedure being 1 procedure A 1 problem with 1 Private self 1 private secure 1 Private questions 1 Press Work 1 Practice Theory 1 post by 1 Português Blender 1 Pool rack 1 Pooling Dave 1 Policy Privacy 1 Policy Contact 1 Policy and 1 Poker Chess 1 pneumoniae curable 1 pneumonia aka 1 plot Gentzen 1 playing Games 1 Pi Stack 1 Physics Chemistry 1 Physical Fitness 1 PHP PDO 1 Photography Science 1 Phone more 1 Philosophy Linguistics 1 person Return 1 Personal Finance 1 performs the 1 performs an 1 Perfect Cookie 1 people who 1 PDO Return 1 PA What 1 paste this 1 passive sensor 1 Part of 1 Parties With 1 particular working 1 particular table 1 Parenting more 1 parallel execution 1 parallel Bush 1 paragraph It 1 Panzercrisis Feb 1 Paclets in 1 P2 that 1 P2 same 1 P1 with 1 P1 same 1 own question 1 own nested 1 over inner 1 Overflow на 1 Overflow your 1 Overflow works 1 Overflow Server 1 Overflow Questions 1 Overflow Public 1 Overflow help 1 Overflow for 1 Overflow Feed 1 Overflow en 1 Overflow em 1 Overflow 3 1 Overflow 1 1 OUTPUT even 1 OUTER JOIN 1 Outdoors Poker 1 out background 1 our Terms 1 our site 1 our Cookie 1 Other Stack 1 other SE 1 other questions 1 other advantage 1 or yield 1 or view 1 or the 1 or SSMS 1 or something 1 or log 1 or is 1 original table 1 order to 1 or at 1 or ask 1 or as 1 opposed to 1 on your 1 on PA 1 on Meta 1 only chown 1 online Why 1 online check 1 ON Foo 1 one row 1 つかみどころがない on 1 oldest votes 1 of using 1 of these 1 of Service 1 of Scope_Identity 1 of scope_identity 1 of scope 1 of other 1 of inserted 1 of IDENTITY 1 offline check 1 of different 1 of and 1 of an 1 of つかみどころがない 1 Oct 11 1 nvarchar 935 1 not used 1 Not the 1 not need 1 not fully 1 not be 1 normally you 1 non answer 1 Nine Ball 1 nice blog 1 newsequentialid scope_identity 1 new Sequence 1 New Row 1 newly inserted 1 Neuroscience Computational 1 Network Technology 1 Network Questions 1 Network Engineering 1 net c 1 nested calls 1 need to 1 need any 1 name returns 1 name Generate 1 my food 1 my CPU 1 mycoplasma pneumoniae 1 my answer 1 Music Practice 1 multiple connections 1 msdn microsoft 1 ms187342 aspx 1 Movies TV 1 Motor Vehicle 1 Most of 1 more What 1 more than 1 more Tebo 1 more stack 1 more reference 1 more linked 1 more hot 1 more attention 1 more 8 1 more 27 1 more 16 1 more 11 1 months ago 1 Monica Cellio 1 Money Academia 1 moderation Linked 1 model answer 1 Mobile Products 1 Mi Yodeya 1 m having 1 method the 1 methods are 1 methods A 1 Meta Update 1 me robinCTS 1 mentioned by 1 mentioned above 1 MeineSebastian Meine 1 Meine Oct 1 Meine 9 1 mechanics Meaning 1 mean Installing 1 Meaning of 1 mean by 1 m curious 1 May 22 1 MathOverflow Mathematics 1 Mathematics Cross 1 Mathematica Salesforce 1 Mathematica online 1 Martial Arts 1 Mar 29 1 manner while 1 Manga Puzzling 1 Maintenance Repair 1 maintained across 1 Magento Software 1 love to 1 love a 1 LOT of 1 looking for 1 LogText VARCHAR 1 LogText VALUES 1 LogText SELECT 1 logo 2020 1 Log in 1 log in 1 log_id or 1 Locked World 1 Loading 1 1 ____________________ Loading 1 list more 1 Linux Ask 1 Link works 1 linked questions 1 LinkedIn site 1 Linked 0 1 link appears 1 link andrepaulo 1 Linguistics Psychology 1 LincolnJonas Lincoln 1 Lincoln 8 1 Likewise a 1 like when 1 like something 1 like share 1 Life Arts 1 licensed under 1 library ms187342 1 Liam 19 1 less calories 1 Legal Privacy 1 least it 1 Learn more 1 Learners Japanese 1 layman s 1 Law Physical 1 LaTeX Software 1 Last ID 1 Language Usage 1 Language Learners 1 Language Islam 1 Language German 1 Language French 1 Language Chinese 1 Language Biblical 1 Language Arqade 1 lang sql 1 Landscaping Parenting 1 know Scope_Identity 1 knight combine 1 kb en 1 kb 2019779 1 just intended 1 just inserted 1 Judaism Travel 1 Jonas LincolnJonas 1 JOIN 160 1 join 1084 1 JOIN 1070 1 Jobs Directory 1 Jobs Developer 1 Jobs 3 1 JavaScript enabled 1 Java Hot 1 Japanese Language 1 Jan 23 1 Jan 12 1 Jan 11 1 I use 1 it support 1 it isn 1 I think 1 It doesn 1 It clarified 1 is what 1 Is walking 1 is using 1 is that 1 is sometimes 1 Is session 1 isn t 1 Islam Русский 1 is if 1 is another 1 irrespective of 1 I recommend 1 in What 1 Invertible bimodules 1 Introverts Perfect 1 introduced in 1 into your 1 into SQL 1 into query 1 INTO Foo 1 in to 1 intended to 1 Instead you 1 instance if 1 Installing Paclets 1 in SQL 1 in sql 1 in sometimes 1 in Sign 1 inside a 1 in server 1 insert the 1 INSERT that 1 inserts Identity 1 INSERT it 1 insert inside 1 InsertFoo ON 1 inserted rows 1 inserted row 1 inserted more 1 inserted identity 1 inserted Foo 1 inserted END 1 inserted always 1 INSERT AS 1 insert another 1 insert a 1 In particular 1 in parallel 1 in order 1 inner join 1 in moderation 1 in Mathematica 1 in Java 1 informative It 1 Information Systems 1 Information Security 1 information Learn 1 Inc user 1 incompatibility to 1 in CFScript 1 in 2012 1 Improvement Personal 1 implementation of 1 immediate context 1 I know 1 i just 1 I have 1 if that 1 I found 1 If I 1 ID Using 1 idiom used 1 ID in 1 I did 1 Identity will 1 identity will 1 identity when 1 IDENTITY used 1 IDENTITY The 1 IDENTITY suppose 1 IDENTITY support 1 identity share 1 IDENTITY returns 1 identity returns 1 identity retrieval 1 identity paragraph 1 identity or 1 identity it 1 identity in 1 IDENTITY Gives 1 identity functions 1 IDENTITY function 1 Identity For 1 Identity Crisis 1 IDENTITY CREATE 1 identity allocated 1 IDENTITY 2 1 IDENTITY 1 1 Identity 1 1 identity 0 1 IdentCurrent The 1 Ident_Current Stack 1 IDENT_CURRENT returns 1 ident_current returns 1 ident_current name 1 Ident_Current Ask 1 Ident_Current all 1 I consume 1 I chose 1 I burn 1 https stackoverflo 1 http msdn 1 hot questions 1 Hot Network 1 hosted questions 1 Horaciux 4 1 Home Improvement 1 Homebrewing Martial 1 Home 2 1 History Spanish 1 Hire technical 1 Highly active 1 Hermeneutics History 1 Here Legal 1 Here is 1 here Identity 1 Hemant SaktaHemant 1 helps protect 1 Help Mobile 1 help chat 1 heat waves 1 having is 1 have triggers 1 have read 1 have inserted 1 have any 1 have already 1 has triggers 1 has an 1 Guffa The 1 GuffaGuffa 592k8484 1 Great Outdoors 1 Graphic Design 1 Good question 1 good explanation 1 Golf Stack 1 gold badges8686 1 gold badges7070 1 gold badges616616 1 gold badges5555 1 gold badges4444 1 gold badges3535 1 gold badges3131 1 gold badges1717 1 go CREATE 1 global scope 1 Gives different 1 Getting a 1 Get the 1 Get newly 1 get identity 1 get id 1 get an 1 German Language 1 Geographic Information 1 Gentzen s 1 generator A 1 generated on 1 generated for 1 Generate a 1 Gardening Landscaping 1 gaming Bicycles 1 Games Bricks 1 Games Anime 1 Game Development 1 g a 1 function that 1 functions SCOPE_IDENTITY 1 function share 1 functions differ 1 functions above 1 function of 1 function is 1 function etc 1 fully resolved 1 from spam 1 from select 1 FROM inserted 1 from all 1 from a 1 French Language 1 Freitas mentioned 1 Freitas Mar 1 Freitas and 1 Free Teams 1 found it 1 for you 1 for Work 1 for Teams 1 for SCOPE_IDENTITY 1 for question 1 for people 1 For more 1 for me 1 For instance 1 forget about 1 For details 1 for Browse 1 FooLog ID 1 Foo INSERT 1 Foo ID 1 food will 1 Foo Dummy 1 Foo AFTER 1 follows identity 1 Fog Cloud 1 Fitness Gardening 1 first recorded 1 First 25 1 fires any 1 fires and 1 fires a 1 find and 1 Finance Money 1 fimbriated plot 1 Fiction Fantasy 1 feed To 1 feed Subscribe 1 Feed for 1 feed copy 1 Feb 13 1 feature that 1 Featured on 1 µF capacitors 1 Fault Super 1 Fantasy Graphic 1 fairly informative 1 Facebook Twitter 1 ExpressionEngine Answers 1 explanation from 1 explains things 1 Experience Mathematica 1 exists in 1 execution bug 1 executing the 1 executes within 1 execute in 1 executed Identity 1 executed from 1 Exchange Stack 1 Exchange Network 1 Exchange Inc 1 exchange communities 1 exceptions not 1 examples see 1 example of 1 Every stored 1 even works 1 Ethereum Data 1 etc IDENT_CURRENT 1 e stored 1 especially in 1 español Ethereum 1 escalate easily 1 error rory 1 equals in 1 en US 1 Enthusiasts Information 1 Enterprise Private 1 Enterprise Company 1 enterprise 4 1 Engineering Unix 1 Engineering Cryptography 1 Engineering Android 1 en español 1 energy source 1 END INSERT 1 enabled 1 e multiple 1 em Português 1 Emacs Raspberry 1 Electrical Engineering 1 either or 1 e g 1 e Freitas 1 Eevee is 1 edited May 1 edited Aug 1 easy to 1 easily again 1 Earn 10 1 earlier than 1 each trigger 1 Dummy VARCHAR 1 Dummy VALUES 1 Dummy FROM 1 Drupal Answers 1 do they 1 do Panzercrisis 1 don t 1 DokshinDmitriy Dokshin 1 Dokshin 61555 1 doing inserts 1 dog name 1 do function 1 does online 1 doesn t 1 does not 1 does comparing 1 Does casting 1 does a 1 Dmitriy DokshinDmitriy 1 d like 1 Directory Salary 1 differ is 1 different scenarios 1 different results 1 different result 1 differentiate with 1 Different Apple 1 difference Session 1 differences between 1 difference Part 1 difference of 1 Difference between 1 did chown 1 deviodevio 34k66 1 Development TeX 1 Development Geographic 1 developers worldwide 1 Developer Jobs 1 details and 1 Design Windows 1 Design Movies 1 design logo 1 deserves more 1 describes this 1 default aspx 1 declaring a 1 d C 1 DaviddCeFreitas I 1 David d 1 Dave Black 1 Data Set 1 Data Science 1 Data Blog 1 database specialists 1 Database Administrators 1 customize your 1 Customers 3 1 current stored 1 current scope 1 current query 1 current connection 1 current community 1 curious to 1 curable Tree 1 Culture Recreation 1 Cryptography Code 1 Cross Validated 1 cross apply 1 Crisis share 1 CREATE TRIGGER 1 created for 1 create an 1 CPU to 1 coworkers to 1 copy and 1 cooking Home 1 Cookie Ratio 1 Cookie Policy 1 controversy I 1 contributions licensed 1 context that 1 context of 1 Contact Us 1 consume less 1 connection The 1 connection that 1 connection SPID 1 connections inserting 1 connections if 1 Connection Pooling 1 connection Is 1 conditions i 1 Computational Science 1 completeness of 1 comparing strings 1 company blog 1 Company About 1 community Stack 1 communities Sign 1 communities company 1 communicated between 1 comment Highly 1 comment 8 1 command Scope 1 command fires 1 command executed 1 command Every 1 com default 1 combine better 1 column values 1 column in 1 column For 1 column for 1 column but 1 Code Review 1 code Is 1 Code Golf 1 code context 1 code bootcamp 1 Cloud break 1 close earlier 1 clear layman 1 clause to 1 clause See 1 clarify the 1 clarified things 1 Christianity English 1 chown The 1 chown r 1 chose this 1 Chinese Language 1 Chess Sports 1 Chemistry Biology 1 cheeze Sep 1 check completeness 1 chat Meta 1 change identity 1 CFScript 3 1 Cellio 2019 1 C e 1 cc by 1 causing the 1 caught especially 1 casting Fog 1 cases 1 1 Card Games 1 capacitors in 1 can use 1 can escalate 1 can be 1 calories as 1 call to 1 calls execute 1 calls a 1 calling procedure 1 call executes 1 Calculator Help 1 c 0 1 By using 1 by scope 1 by sa 1 by P2 1 by P1 1 by David 1 by Adam 1 BUTTON To 1 BUTTON The 1 BUTTON If 1 BUTTON Here 1 BUTTON Good 1 BUTTON BUTTON 1 BUTTON Because 1 BUTTON 9 1 BUTTON 6 1 BUTTON 56 1 BUTTON 41 1 BUTTON 4 1 BUTTON 355 1 BUTTON 3 1 BUTTON 173 1 BUTTON 14 1 BUTTON 12 1 but the 1 but sometimes 1 but I 1 but any 1 Bush fires 1 burnt them 1 burn my 1 bug that 1 bug mentioned 1 bug in 1 bug but 1 Browse other 1 broken or 1 broken link 1 Bricks Homebrewing 1 break a 1 BrannonBrannon 23 1 bought set 1 bootcamp This 1 bootcamp for 1 book As 1 boneheaded exceptions 1 Board Card 1 blown out 1 Blog This 1 blog post 1 Blog Facebook 1 blog By 1 Blender Network 1 Black Jan 1 Bitcoin Software 1 bishop What 1 Biology Computer 1 bimodules and 1 Bicycles Role 1 Biblical Hermeneutics 1 be what 1 be weird 1 be very 1 between varchar 1 between UNION 1 between two 1 between the 1 between SCOPE_IDENTITY 1 between scope 1 between newsequentialid 1 between JOIN 1 between INNER 1 between and 1 better with 1 best with 1 Best way 1 below Sebastian 1 being fairly 1 being executed 1 being communicated 1 BEGIN INSERT 1 Because of 1 be caught 1 be broken 1 batch or 1 Ball Pool 1 bad situation 1 badges I 1 badges asked 1 badges905905 bronze 1 badges8686 silver 1 badges8181 bronze 1 badges77 bronze 1 badges7070 silver 1 badges616616 silver 1 badges6161 bronze 1 badges5555 silver 1 badges4646 bronze 1 badges4444 silver 1 badges4242 bronze 1 badges3636 bronze 1 badges3535 silver 1 badges3131 silver 1 badges3030 bronze 1 badges2121 bronze 1 badges 2 1 badges1717 silver 1 badges137137 bronze 1 badges132132 bronze 1 badges 13 1 background How 1 a year 1 away from 1 A very 1 a very 1 Aug 25 1 attribution required 1 attention cheeze 1 at least 1 a Tidally 1 at 6 1 at 22 1 at 2 1 at 18 1 at 15 1 at 1 1 as the 1 A statement 1 Assurance Testing 1 a SQL 1 aspx To 1 aspx scid 1 asp net 1 ASP error 1 as opposed 1 ask your 1 Ask Ubuntu 1 Ask Question 1 asked Dec 1 Asked 10 1 Ask Different 1 a simple 1 as I 1 As for 1 as follows 1 a select 1 As David 1 AS BEGIN 1 as applied 1 a Sanctuary 1 as an 1 as a 1 Arts The 1 Arts Culture 1 Arqade gaming 1 a role 1 are using 1 a result 1 are inserting 1 are as 1 Arduino Bitcoin 1 a query 1 a procedure 1 a private 1 Apps API 1 apply over 1 applied to 1 applications when 1 Applications Ask 1 application or 1 Apple WordPress 1 appears to 1 API Data 1 a person 1 ap broken 1 A passive 1 a particular 1 any additional 1 answer you 1 answer this 1 Answers Stack 1 Answers SharePoint 1 answers do 1 Answers 8 1 answers 2 1 answer In 1 answered Jan 1 answer deserves 1 answer below 1 answer because 1 answer activity 1 another record 1 another good 1 An INSERT 1 a Nine 1 Anime Manga 1 a nested 1 and your 1 and you 1 and UNION 1 and understand 1 and that 1 and SQL 1 and share 1 and session 1 and scope 1 Android Enthusiasts 1 AndrewAndrew 23 1 andrepaulo Link 1 andrepaulo Jan 1 and projectivity 1 and paste 1 and OUTER 1 and our 1 and nvarchar 1 and non 1 and nested 1 and INNER 1 and if 1 and Identity 1 and heat 1 and examples 1 Anderson describes 1 and equals 1 and differentiate 1 and can 1 and because 1 and any 1 an ASP 1 an application 1 an alternative 1 an agreement 1 always use 1 alternative method 1 also love 1 also has 1 already burnt 1 a LOT 1 a log_id 1 all three 1 allocated for 1 all get 1 ALL 1306 1 a knight 1 aka mycoplasma 1 agreement with 1 ago Viewed 1 ago Active 1 a generator 1 again Why 1 a function 1 AFTER INSERT 1 A for 1 a fimbriated 1 Advice cooking 1 Advertising Reach 1 Advertising Enterprise 1 advantage is 1 Administrators Drupal 1 a different 1 additional energy 1 Adam Anderson 1 Actually I 1 activity Not 1 active question 1 active oldest 1 Active 1 1 across connections 1 a command 1 a column 1 a code 1 acknowledge that 1 A call 1 Academia Law 1 a bug 1 above there 1 above I 1 about what 1 About Press 1 a bought 1 a blown 1 a bishop 1 a bad 1 9k1616 gold 1 9 BUTTON 1 9 58 1 9 5782121 1 9 51 1 9 49 1 9 48 1 9 42 1 935 Difference 1 8 Meta 1 8 Answers 1 8 active 1 896 When 1 8 72977 1 72977 gold 1 6 BUTTON 16 bronze badges 1 6 28 1 61555 silver 1 5 months 1 5 Jobs 1 5 Advertising 1 59 robinCTS 1 599 What 1 592k8484 gold 1 58 GuffaGuffa 1 5782121 silver 1 56 I 1 55 Liam 1 55 add 1 53 add 1 51 Jonas 1 51 1 1 50 robinCTS 1 50 DaviddCeFreitas 1 4 Users 1 4 Talent 1 4k1111 gold 1 4 BUTTON 1 49 AndrewAndrew 1 48 BrannonBrannon 1 46 Ali 1 4528 What 1 4 40922 1 42 TeboTebo 1 41 BUTTON 1 40922 gold 1 4 0 1 3 Use 1 3 TSQL 1 3 Tags 13 Stack Overflow 1 3 New 1 3 Get 1 3 Enterprise 1 3 current 1 3 BUTTON 1 37 Dmitriy 1 35708 Stack 1 355 BUTTON 1 34k66 gold 1 3 35708 1 3 1 1 2 Teams 1 2 Stack 1 2 LogText 1 2 Log 1 2k44 gold 12 is the 1 2 First 1 2 Don 1 2 Customers 1 2 Actually 1 29 11 1 28 Hemant 1 27 Photography 1 26 Horaciux 1 25 Users 1 25 17 1 23 2k44 1 23 1k55 1 23 17 1 2 26 1 22 51 1 22 17 1 2 2 1 21 15 1 21 12 1 2 1 1 20 rory 1 20 37 1 2020 Stack 1 2020 1 1 20 20 1 2019 a 1 2019779 rory 1 2019779 David 1 20 19 1 2012 I 1 1 year 1 1 What 1 1 using 1 1 This 11 the difference 1 1 Teams 1 1 Stack 1 1 Public 1 1 Products 1 1k55 gold 1 1 How 1 1 Home 1 1 get 1 1 µF 1 1 Dummy 1 1 As 1 1 andrepaulo 1 19 9k1616 1 19 2 1 19 1 1 18 add 1 18722 silver 1 18 55 1 173 BUTTON 1 16 robinCTS 1 16 MathOverflow 1 16 Ali 1 16 18 1 160 How 1 15 Guffa 1 15 19 1 14 BUTTON 1 14 1 1 13 I 1 1364 What 1 13 59 1 13 53 1 13 50 1 13 46 1 13 18 1 13 16 1 1306 What 1 1 3 1 12 Sebastian 1 12 BUTTON 1 12 4k1111 1 12 16 1 1 2 1 11 English 1 11 deviodevio 1 119k times 1 1 18 1 11 50 1 11 11 1 1 1 1 10 years 1 10 reputation 1 1084 Why 1 1070 Best 1 10 55 1 10 14 1 10 11 1 100 go 1 100 CREATE 1 0 with 10 What is 1 0 What 10 the identity 1 0 PHP 10 last identity 10 identity value 1 0 Get 1 0 1