Hello All,
I am trying to check Null value in where clause in stored proc. I am passing where clause(@whereclause) and language id(@languageid) as a parameter.
If the variable is null then those should not get concatenated.
So how can i check this ? Below is my stored proc. I have done something like this
ALTER PROCEDURE [GetList]
(
@TableName nvarchar(500),
@whereClause nvarchar(500) = NULL,
@Columns nvarchar(500) = null,
@sql nvarchar(500) = null OUT,
@OrderBy nvarchar(500) = null,
@LanguageID int = null
)
AS
Declare @PkColumn varchar(100),
@TableCount int
SELECT @PkColumn = COLUMNS.COLUMN_NAME FROM information_schema.COLUMNS inner JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE on COLUMNS.TABLE_NAME = KEY_COLUMN_USAGE.TABLE_NAME AND COLUMNS.COLUMN_NAME= KEY_COLUMN_USAGE.COLUMN_NAME where KEY_COLUMN_USAGE.TABLE_NAME=@TableName and KEY_COLUMN_USAGE.CONSTRAINT_NAME LIKE 'PK%'
begin
SET @TableName = 'SEL ...
Go to the complete details ...