Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Stored procedure
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' Create table tblEmployee (ID int not null primary key, Name varchar (20),Gender varchar(20), DepartmentID int) Insert into tblEmployee values (1,'Juma','Male',2) Insert into tblEmployee values (2,'Vincent','Male',1) Insert into tblEmployee values (3,'Lydia','Female',3) Insert into tblEmployee values (4,'Martin','Male',2) Insert into tblEmployee values (5,'Mary','Female',3) CREATE PROCEDURE spGetEmployeeNameGender AS BEGIN Select Name, Gender from tblEmployee END EXECUTE spGetEmployeeNameGender
run
|
edit
|
history
|
help
0
Exam
QLCB_CSDL
sql
ESTEFANIA
Insert multiple parent-child records
megha
emp 4
pk
SQL_Joins_RankingFunctions
Arif First Query