use communityAssist Insert into Person([PersonLastName],[PersonFirstName],[PersonUsername], personEntryDate) Values('Turin','Alan', 'AlanTuring@gmail.com',GetDate()), ('Ginsberg', 'Alan', 'aginsburg@gmail.com', getDate()) Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey) Values('1001 Broadway', '201', 'WA', 'Seattle','98001', ident_current('Person')) Select * From Person update Person Set PersonFirstName='Jason', PersonUserName='jasonAnderson@gmail.com' where personKey=1 begin tran Update Person Set PersonLastName='Smith' rollback tran Commit tran Delete From PersonAddress where personkey=130 Delete From Person where personkey=130 Select * from PersonAddress
Wednesday, March 4, 2015
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment