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
MSSQL NVARCHAR to INT conversions
Mc170404738
exercise
SQL injection
Employee Table
MindBoxTest
sadasd
Segundo
SALESPEOPLE
subquery & correlated subquery & "is null" condition