Consultas

Consulta Select

SELECT Id,Name,DeptName,DepartmentId,Gender FROM tblEmployee  emp
inner join tblDepartment dep on emp.DepartmentId=dep.DeptId


Update

UPDATE tblEmployee SET Name = @Name, Gender = @Gender, DepartmentId = @DepartmentId WHERE (Id = @Id)

Insert

INSERT INTO tblEmployee(Id, Name, Gender, DepartmentId) VALUES (@Id, @Name, @Gender, @DepartmentId)

Delete

DELETE FROM tblEmployee FROM tblEmployee INNER JOIN tblDepartment ON tblEmployee.DepartmentId = tblDepartment.DeptId WHERE (tblEmployee.Id = @Id)