Wednesday, March 4, 2015

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

No comments:

Post a Comment