PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Hernádi Tamás   Rasher PHP Data Access Layer Helper - Database Repository   test/script_mssql/getUser.storedProcedure.sql   Download  
File: test/script_mssql/getUser.storedProcedure.sql
Role: Auxiliary data
Content typex: text/plain
Description: Auxiliary data
Class: Rasher PHP Data Access Layer Helper - Database Repository
Run queries to access data in any type of database
Author: By
Last change:
Date: 2 years ago
Size: 418 bytes
 

Contents

Class file image Download 
USE [test]
GO

/****** Object:  StoredProcedure [dbo].[getUser]    Script Date: 2023.09.05. 19:39:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE OR ALTER PROCEDURE [dbo].[getUser]   
    @Id INT = NULL,   
	@LoginName varchar(100) = NULL
AS  
BEGIN
    SET NOCOUNT ON

	SELECT *
	FROM [dbo].[user] 
	WHERE (@Id IS NULL OR @Id = Id)
		  AND (@LoginName IS NULL OR @LoginName = LoginName)
END
GO