7 vote of 7 My vote 7 General My 6 SQL Server 5 write13 png 5 Server sz 5 22 Aug 4 the last 4 SCOPE_IDENTITY IDENT_CURRENT 4 Samrat Banerjee 4 returns that 4 questions View 4 of a 4 of 5 4 Oct 15 4 Oct 14 4 Mar 12 4 identity value 4 IDENTITY SCOPE_IDENTITY 4 an article 4 5 Pin 4 5 19 4 14 20 4 10 23 3 which is 3 value inserted 3 value generated 3 to switch 3 This was 3 the value 3 the current 3 that identity 3 than an 3 table in 3 Sign in 3 SELECT IDENT_CURRENT 3 Returns the 3 returns the 3 last identity 3 It returns 3 in this 3 in the 3 inserted into 3 identity record 3 I am 3 Go to 3 generated for 3 c 68609 3 Ask a 3 a Question 3 a blog 2 with generate 2 which inserts 2 we create 2 was inserted 2 Very Good 2 user defined 2 up to 2 trigger SELECT 2 trigger or 2 trigger on 2 to this 2 to Parent 2 this suppose 2 this session 2 this query 2 this point 2 this is 2 the trigger 2 there has 2 then SCOPE_IDENTITY 2 The Insider 2 the INSERT 2 the following 2 table with 2 table which 2 sz 728x90 2 suppose we 2 statements before 2 session SELECT 2 session and 2 SELECT SCOPE_IDENTITY 2 SELECT IDENTITY 2 SELECT id 2 SCOPE_IDENTITY Returns 2 scope and 2 row in 2 Right to 2 Returns value 2 Returns NULL 2 record which 2 Questions View 2 Question Good 2 post Pin 2 point in 2 png Import 2 png Ask 2 Pin Member 2 Parent id 2 or a 2 on table 2 of 3 2 NULL because 2 Nov 16 2 not clear 2 not affected 2 no INSERT 2 Nice explanation 2 News The 2 NET questions 2 More of 2 more of 2 Member Member 2 Member 23341727 2 Member 2334172 2 me explain 2 lg png 2 Let me 2 Left Right 2 Latest articles 2 Keep it 2 jpg Samrat 2 Jan 20 2 Jan 14 2 it up 2 it helps 2 is not 2 is more 2 is empty 2 is created 2 into Child 2 int IDENTITY 2 in Session 2 insert trigger 2 INSERT statement 2 inserts a 2 inserted by 2 INSERT action 2 in any 2 in another 2 id int 2 id FROM 2 IDENTITY Returns 2 identity column 2 IDENT_CURRENT Child 2 Help Forum 2 has been 2 Good Pin 2 generate an 2 General Re 2 for any 2 following in 2 explain this 2 Do the 2 Difference between 2 defined function 2 DEFAULT VALUES 2 current session 2 CREATE TABLE 2 created by 2 create an 2 column then 2 CodeProject Latest 2 Child Returns 2 ccac81edc868 jpg 2 cauvin_stephane yahoo 2 c 537384 2 by trigger 2 by the 2 blog post 2 bikah chanda 2 before this 2 been no 2 because there 2 bb39 ccac81edc868 2 b27d 4b3c 2 a user 2 ASP NET 2 Article Help 2 a row 2 Apr 17 2 any table 2 any session 2 another table 2 an insert 2 an identity 2 and session 2 action up 2 7 Oct 2 728x90 c 2 6 Jan 2 64 44 2 6 02 2 4b3c bb39 2 49 Member 2 4 64 2 44 votes 2 3 Pin 2 3 49 2 3362c29a b27d 2 3 25 2 24 Aug 2 2 49 2 23 Aug 2 23341727 Oct 2 2334172 7 2 23 30 2 23 12 2 22 14 2 20 49 2 20 41 2 20 0 2 19 Member 2 19 58 2 18 52 2 17 5 2 16 6 2 15 2 2 15 1 2 14 18 2 1 39 2 13 03 2 12 3 2 12 22 2 12 06 2 10 5 2 10 3 2 10 19 2 10 13 2 10 12 2 10 0 2 0 10 2 0 06 1 your password 1 your explanations 1 Your commnet 1 your Blog 1 you for 1 yahoo fr5 1 yahoo fr 1 Xpode com 1 WTL STL 1 wrong Pin 1 WPF Visual 1 Work Issues 1 working in 1 words we 1 Wonderful Non 1 with the 1 with octicons_github 1 within Articles 1 with any 1 Who s 1 Who Most 1 which last 1 Where I 1 What is 1 we need 1 Weird The 1 we have 1 we can 1 Web Development 1 Web05 2 1 Watch featuresstuff 1 was the 1 votes Please 1 votes loading24 1 vote 4 1 Vote 22 1 Visual Basic 1 Visit 6 1 View VB 1 View Unanswered 1 View Stats 1 View SQL 1 views 677 1 View Javascript 1 View C 1 View ASP 1 View All 1 Very Nice 1 verify it 1 ve read 1 VB NET 1 value which 1 VALUES SELECT 1 values However 1 VALUES END 1 value returns 1 value 100 1 value 1 1 Valuable Professionals 1 Use Layout 1 Use Ctrl 1 Us Articles 1 Up thumbsup 1 up Thumbs 1 up Regards 1 up or 1 Up Down 1 Update Guidelines 1 Update 6 1 under The 1 Unanswered Questions 1 two statements 1 trigger SCOPE_IDENTITY 1 TRIGGER Parentins 1 trigger definition 1 Trick than 1 to vote 1 to top 1 to Skip 1 top Permalink 1 Topics help 1 Topics CodeProject 1 Top Articles 1 Tools Objective 1 to main 1 to get 1 to explore 1 tip write13 1 Tip Trick 1 thumbsup General 1 Thumbs Up 1 through SQL 1 three functions 1 threads Ctrl 1 this stars 1 this scope 1 This article 1 this article 1 The Wonderful 1 The Weird 1 these functions 1 the scope 1 the same 1 then post 1 then IDENTITY 1 The Lounge 1 the language 1 the help 1 The Daily 1 The Code 1 the Author 1 the above 1 that we 1 that table 1 that produced 1 that is 1 Thank you 1 Thanks it 1 Testing o 1 Terms of 1 technologies SQL 1 Tagged as 1 table that 1 table related 1 TABLE Parent 1 TABLE Child 1 table and 1 sz 300x250 1 sz 160x600 1 sz 160x200 1 System Admin 1 switch threads 1 switch pages 1 switch messages 1 Swift Database 1 s Who 1 Surveys Product 1 Surly deserve 1 Suggestion Suggestion 1 Suggestions Spam 1 Suggestions Article 1 Suggestion Question 1 Submit Search 1 Submit an 1 Stuff communitylounge 1 STL o 1 Stats Revisions 1 Stats 261 1 statement two 1 statement four 1 stars fill 1 stars empty 1 s really 1 SQL Stats 1 SQL questions 1 SQL Query 1 SQL query 1 SQL IDENTITY 1 SQL Identity 1 specific table 1 Spam and 1 source code 1 some sample 1 Software Engineer 1 Software Developer 1 Skip to 1 Site Bugs 1 Silverlight WPF 1 Sign up 1 sign in 1 ____ Sign 1 __________________________________________________________________ Sign 1 Showcase CodeProject 1 Shift Left 1 SharePoint Silverlight 1 Share About 1 session or 1 session on 1 session it 1 session across 1 Session 2 1 Session 1 1 Servers Java 1 Server print48 1 Senior India 1 Sections o 1 Search within 1 search gif 1 ____________________ search 1 scope SQL 1 scopes Let 1 scope Let 1 scope In 1 scope in 1 SCOPE_IDENTITY returns 1 SCOPE_IDENTITY result 1 SCOPE_IDENTITY It 1 scenario we 1 say it 1 sample query 1 same table 1 Sales Marketing 1 Running a 1 row information 1 Rohit Xpode 1 rohit kakria18 1 rohit kakria 1 Revisions 2 1 Re Very 1 return last 1 result is 1 Re More 1 related identity 1 Regards Rohit 1 regards General 1 Refresh 1 1 redc dccdc4 1 redc dccdc 1 record then 1 really more 1 read a 1 Rate this 1 Rant Rant 1 Rant Admin 1 ramprasad addanki7 1 ramprasad addanki 1 Rahul Khadikar22 1 Rahul Khadikar 1 quick answersQ 1 Quick Answers 1 Question Your 1 Question View 1 questions discussionsforums 1 Question Question 1 Question Comments 1 Question Bugs 1 Question Bug 1 Question about 1 query SELECT 1 Query I 1 query hope 1 query Do 1 query And 1 query 3 1 pzokarkar22 Aug 1 pzokarkar 22 1 Project write13 1 Project Open 1 Programming NET 1 Professionals The 1 professional linuxjr 1 Product Showcase 1 produced the 1 process with 1 Privacy Cookies 1 print48 png 1 Prev Next 1 Praise Rant 1 Praise Praise 1 post SQL 1 post Question 1 Posting Update 1 posting than 1 Postings CodeProject 1 Posted 22 1 points General 1 png Submit 1 png stars 1 png microsoft 1 png linkedin 1 png Home 1 png google 1 png facebook 1 png Email 1 png Difference 1 png 4 1 plus png 1 please verify 1 Please Sign 1 platform I 1 Pin rohit 1 Pin redc 1 Pin ramprasad 1 Pin Rahul 1 Pin pzokarkar22 1 Pin pinaldave24 1 Pin Not 1 Pin neetesh12319 1 Pin linuxjr23 1 Pin kornakar22 1 Pin JayantiChauhan15 1 Pin cauvin_stephane 1 Pin Bishoy 1 Pin bikah 1 pinaldave24 Aug 1 pinaldave 24 1 Pin Akhteruzzaman23 1 Photos The 1 Permalink Advertise 1 Password ____________________ 1 ____________________ Password 1 password __________________________________________________________________ 1 particular table 1 Parent This 1 Parent Returns 1 Parentins ON 1 Parent Indeed 1 Parent FOR 1 Parent DEFAULT 1 Parent Correct 1 pages Article 1 o Work 1 our application 1 other words 1 o System 1 o Sales 1 o Running 1 or tip 1 or sign 1 or scope 1 ord 39 1 options like 1 Open License 1 on which 1 on the 1 ON Parent 1 only depends 1 one nontheless 1 on a 1 o Managed 1 o Latest 1 o General 1 of Use 1 of trigger 1 of these 1 of some 1 of our 1 of 1 1 octicons_github png 1 o Collaboration 1 Objective C 1 o ATL 1 not implemented 1 Not Active21 1 Not Active 1 nontheless Last 1 Non English 1 Nice Information 1 Nice Explanation 1 Nice article 1 Next Question 1 new technologies 1 News Suggestion 1 News News 1 Newsletter The 1 Newsletter Newsletter 1 Newsletter archive 1 net platform 1 NET JavaScript 1 NET Framework 1 neetesh12319 Oct 1 neetesh123 19 1 need to 1 nd August 1 multiple options 1 Most Valuable 1 most of 1 more elaborated 1 mohanta27 Apr 1 mohanta 27 1 Mobile SharePoint 1 microsoft png 1 MFC o 1 Messages home 1 messages Ctrl 1 Message Boards 1 mentor Not 1 members Sign 1 Member rohit 1 Member redc 1 Member ramprasad 1 Member Rahul 1 Member pzokarkar 1 Member pinaldave 1 Member Photos 1 Member neetesh123 1 Member kornakar 1 Member JayantiChauhan 1 Member cauvin_stephane 1 Member Bishoy 1 Member bikah 1 Member Akhteruzzaman 1 me a 1 Marketing o 1 Managed C 1 main content 1 _Madmatt General 1 love to 1 Lounge Where 1 Lounge Postings 1 lot Question 1 login32 png 1 loading Rate 1 loading24 gif 1 Linux Programming 1 linuxjr23 Aug 1 linuxjr 23 1 linkedin png 1 like IDENTITY 1 Lifecycle o 1 License This 1 licensed under 1 License CPOL 1 Layout fixed 1 latest inserted 1 Latest Articles 1 Last Visit 1 last value 1 Last Update 1 last is 1 last generated 1 Language o 1 language I 1 kornakar22 Aug 1 kornakar 22 1 know the 1 Khadikar22 Aug 1 Khadikar 22 1 KB Introduction 1 kakria18 Mar 1 kakria 18 1 Joke Praise 1 Joke Joke 1 JayantiChauhan15 Mar 1 JayantiChauhan 15 1 Javascript questions 1 JavaScript C 1 Java Linux 1 iw wrong 1 I ve 1 it then 1 it s 1 it only 1 It is 1 it is 1 Issues Design 1 is licensed 1 is in 1 is good 1 is generated 1 is defined 1 is CodeProject 1 is affected 1 iOS Mobile 1 in with 1 Introduction In 1 into Parent 1 in to 1 Intelligence CodeProject 1 Insider Newsletter 1 Insider News 1 INSERT Parent 1 inserted row 1 INSERT Child 1 INSERT AS 1 Input not 1 In other 1 in net 1 In most 1 in login32 1 Initial post 1 information through 1 information it 1 Information About 1 in Forgot 1 in each 1 Indian Topics 1 India India 1 India I 1 India Hi 1 Indeed this 1 Import your 1 Import GitHub 1 implemented ____ 1 I love 1 I know 1 if a 1 ID is 1 id is 1 identity values 1 IDENTITY returns 1 IDENTITY It 1 Identity General 1 IDENTITY CREATE 1 IDENTITY 100 1 IDENT_CURRENT Pin 1 IDENT_CURRENT Parent 1 IDENT_CURRENT It 1 IDENT_CURRENT functions 1 IDENT_CURRENT All 1 IDENT_CURRENT 3362c29a 1 I Am 1 __________________________________________________________________ I 1 However the 1 Hosting and 1 hope it 1 Home SQL 1 home articles 1 History 22 1 Hi I 1 here to 1 help What 1 helps me 1 helps CREATE 1 help of 1 have multiple 1 Hardware Devices 1 Guidelines Article 1 Gud Example 1 google plus 1 good one 1 good information 1 Good General 1 Good explanation 1 Good Article 1 Good Artical 1 GO End 1 GO CREATE 1 GitHub Project 1 gif Vote 1 gif Submit 1 get latest 1 generated in 1 generated identity 1 General Very 1 General News 1 General More 1 General Indian 1 General Good 1 General General 1 General FAQ 1 functions return 1 functions Download 1 functions differ 1 function is 1 function IDENT_CURRENT 1 FROM Parent 1 from India 1 FROM Child 1 Free Tools 1 Framework Android 1 fr5 Nov 1 fr 5 1 four statements 1 for your 1 Forum write13 1 Forum About 1 for that 1 FOR INSERT 1 Forgot your 1 for a 1 fluid Article 1 fixed fluid 1 First Prev 1 fill lg 1 files is 1 featuresstuff Competitions 1 FAQ Ask 1 facebook png 1 explore new 1 explanation Thanks 1 explanation Surly 1 explanations Best 1 explanation Pin 1 Explanation General 1 explaining the 1 excellent Question 1 Example General 1 Everything else 1 enough General 1 English Language 1 Engineer working 1 End of 1 END GO 1 empty SELECT 1 empty lg 1 empty Do 1 Email ____________________ 1 else Copyright 1 elaborated than 1 each of 1 Down to 1 downloads 46 1 Download query 1 discussionsforums All 1 Discussions First 1 differ Compare 1 DFPAudiencePixel ord 1 Devices o 1 Development Site 1 Developer Senior 1 Design and 1 deserve 5 1 depends on 1 Demian24 Aug 1 Demian 24 1 definition SELECT 1 defined in 1 dc_seg 33705370 1 dccdc4 Oct 1 dccdc 4 1 Database SQL 1 Database Hardware 1 Database Database 1 Daily Build 1 current scope 1 Ctrl Up 1 Ctrl Shift 1 Ctrl Left 1 CREATE TRIGGER 1 C questions 1 CPOL Share 1 Correct General 1 Copyright CodeProject 1 Copyright 2010 1 Cookies Terms 1 content 14 1 Competitions News 1 Compare IDENTITY 1 communitylounge Who 1 commnet iw 1 Comments Pin 1 Comments and 1 Comments 17 1 com General 1 Collaboration Beta 1 CodeProject Stuff 1 CodeProject Lounge 1 CodeProject General 1 CodeProject Click 1 CodeProject 1999 1 Code Project 1 code and 1 C MFC 1 Click here 1 CLI C 1 clear General 1 clear enough 1 Child that 1 Child ID 1 Child id 1 Child History 1 Child DEFAULT 1 Chapters and 1 chanda mohanta27 1 chanda mohanta 1 C Free 1 C CLI 1 C C 1 can say 1 C and 1 by scope 1 by Samrat 1 BUTTON Input 1 ____________________ BUTTON 1 but if 1 Business o 1 Build Newsletter 1 Bugs Suggestions 1 Bugs and 1 Bug Bug 1 Bug Answer 1 bookmarked SQL 1 book _Madmatt 1 Boards Application 1 Blog quick 1 blog posting 1 Bishoy Demian24 1 Bishoy Demian 1 between SQL 1 between IDENTITY 1 Beta Testing 1 Best regards 1 BEGIN INSERT 1 Basic Web 1 Banerjee Software 1 Banerjee loading 1 Banerjee from 1 Banerjee Everything 1 A write13 1 Author 3362c29a 1 August 2010 1 Aug 2010CPOL 1 Aug 2010 1 a trigger 1 ATL WTL 1 a Tip 1 as SQL 1 associated source 1 a specific 1 a Software 1 AS BEGIN 1 Artificial Intelligence 1 article write13 1 Article View 1 Articles Top 1 Articles Quick 1 Articles Posting 1 Articles Database 1 articles Chapters 1 articles Artificial 1 articles All 1 Article Pin 1 article or 1 article Keep 1 Article Copyright 1 article Answer 1 article along 1 article a 1 article __________________________________________________________________ 1 Artical Pin 1 archive Surveys 1 Architecture ASP 1 application scenario 1 Application Lifecycle 1 a particular 1 any scope 1 any associated 1 answersQ A 1 Answers Messages 1 Answer Joke 1 Answer IDENTITY 1 Answer Answer 1 and the 1 and Swift 1 and Suggestions 1 and Servers 1 and Sections 1 Android iOS 1 and returns 1 And for 1 and files 1 and Discussions 1 and Architecture 1 and any 1 and Abuse 1 am Samrat 1 Am Member 1 am explaining 1 am a 1 Although this 1 a lot 1 along with 1 All Topics 1 All three 1 all scopes 1 All Questions 1 All Message 1 Akhteruzzaman23 Aug 1 Akhteruzzaman 23 1 a good 1 affected on 1 affected by 1 affected but 1 Advertise Privacy 1 Admin Use 1 Admin Hosting 1 Admin Admin 1 addanki7 Jan 1 addanki 7 1 Active21 Aug 1 Active 21 1 across all 1 a Business 1 Abuse Watch 1 above process 1 About Us 1 about this 1 About the 1 About SQL 1 a book 1 8 191213 1 7 Jan 1 784 members 16 Aug 10 1 68609 License 1 68609 Comments 1 68609 ____________________ 1 677 downloads 1 637138839636603874 39 1 5 points 1 5 Nov 1 58 Nice 1 58 Member 1 537384 SQL 1 537384 Go 1 52 Nice 1 52 Member 1 4 Oct 1 49 professional 1 49 Nice 1 49 Good 1 49 excellent 1 46 bookmarked 1 41 Member 1 41 Go 1 409 784 1 39 please 1 39 Member 1 39 KB 1 39 dc_seg 1 39 637138839636603874 1 3 39 1 33705370 1 30 Very 1 30 Member 1 300x250 c 1 2 SELECT 1 2 Comments 1 2 8 1 27 Apr 1 261 1K 1 25 Member 1 25 Gud 1 22 nd 1 21 Aug 1 2020 Web05 1 2010 Tagged 1 2010 Initial 1 2010CPOL Difference 1 2010 by 1 1 This 1 1 Pin 1 1K views 1 1 INSERT 1 1 GO 1 1 General 1 1 DFPAudiencePixel 1 19 Oct 1 19 Nice 1 19 Keep 1 1999 2020 1 191213 1 1 18 Mar 1 17 Posted 1 160x600 c 1 160x200 c 1 15 Mar 1 14 Member 1 14 It 1 14 409 1 12 Member 1 12 Go 1 10 not 1 10 Member 1 100 This 1 100 1 1 06 Refresh 1 06 not 1 06 Member 1 06 Last 1 03 mentor 1 03 Although 1 02 Thank 1 02 Member