MCS 043 Free Assignment April 2011
Question 2 Solution (a) Select Supplier.su_id, supplier.Name.su (Supply of per quantity of supply) from supplier On supplier.su_id inner join supply of par su_id group by su_id (b) Begin Transaction Trans Go Use Adventure work 2008 R GO SELECT + Money From Adventurework 2008 R Human Resource.Account Where Acount No. = 123456 Commit Transaction @ Account No Go = Begin Trasaction Tran 2 Go Use Adventure Work 2008 R2 Go Insert into Adventure work 2008 R2 VALUES (10000, ACCOUNT No. ) Commit Transaction @ Account No. (c) Create view supplier As Select * FROM Supplier Where su_id = @ su_id = create view system manager As Select * from supplier su_id, supplier.su_name Supplier.su_address, supplier.su_status Supply of part.su_id, supply of part. Pa_id, supply of part. Date of supply, supply of part.quanitity of Supply, supply of part.su_price from Supplier on supplier.su_id inn...
Comments
Post a Comment