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
sql
Return a single column that matches a parameter
exercise 1 – fines – database import 1.0.1.sql
Libros
Window Funtions - RANK()
La Project
hhhhhhhhhhh
db6
bc160402152
cms by valli