Advanced Search

Return to Snippet

Revision: 17318
at August 31, 2009 22:48 by rengber
Initial Code 
BEGIN
  	  INSERT INTO [dbo].[Transaction]
	  (
		[TotalAmountPaid]
		,[TransactionDttm]
	  )
	  VALUES
	  (
		@TotalAmountPaid
		,@TransactionDttm
	  )
	
	  Select SCOPE_IDENTITY() as 'TransactionID'
	END
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Dead simple, but often forgotten.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
TSQL to Get the SQL Autonumber ID of the Row Just Inserted

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
database, sql, query

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL