CS403 Assignment No 3 Solution Fall 2020 Complete Correct Solved By Mani

Опубликовано: 26 Март 2026
на канале: Learning School

128

#CS403 Assignment No 3 Solution Fall 2020
#SQL #DB

--Select * from Employee
--- Task 1
--insert into Employee (Emp_ID ,Emp_Name,Emp_Gender,Emp_Address,Emp_DoB,Email,Contact,Pro_ID)
--Values ('emp01','Ahmad','Male','Lahore','1990-1-1','[email protected]',03001234567,'PRJ001');

-- Task 2
Select * From manger where Mgr_gender='Male'
-- Task 3 Complted
Select * from Client where Pro_ID='PRJ001'

-- Task 4 Done
Select * from Client where Pro_ID='PRJ01'
UPDATE Client SET Pro_ID= 'PRJ001' WHERE Pro_ID = 'PRJ01'

--- Task 5
Select * from Client
sp_rename 'Client.Email', 'Cl_Email ', 'COLUMN';

hope its help alot to making assg thanks

best regards
Mani