Skip to content

Instantly share code, notes, and snippets.

@vmussak

vmussak/sqlprocedure.sql

Created March 20, 2017 01:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vmussak/381ec1a4d206da28ca7b0a9c1e1ee60c to your computer and use it in GitHub Desktop.
Save vmussak/381ec1a4d206da28ca7b0a9c1e1ee60c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqlprocedure.sql
CREATE PROCEDURE BuscarUsuario
@Nome varchar(50),
@NomeDaMae varchar(50)
AS
BEGIN
SELECT u.Id,
u.Nome,
u.NomeDaMae
FROM Usuario u
WHERE u.Nome LIKE @Nome
AND u.NomeDaMae LIKE @NomeDaMae
END
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment