select * from tm_user where
userid=@userid
Loading
9 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
To get rows with NULL value
SELECT * FROM tm_user WHERE USERID IS NULL
To get rows with not NULL values
SELECT * FROM tm_user WHERE USERID IS NOT NULL
Hi Joginder,
Could you please make you question clear ? Do you mean you want all records from
tm_user table where userid is null ?
- select * from tm_user isnull(userid,0) = 0
To get record with null value -
syntex :
expression IS NULL
example:
select * from tb_user where userid IS NULL
This will return result ,which userid is null only.
DECLARE @TABLE TABLE (ID INT,NAME VARCHAR(16))
INSERT INTO @TABLE VALUES (1,'RAMESH')
INSERT INTO @TABLE VALUES (2,'')
INSERT INTO @TABLE VALUES (3,'PATEL')
INSERT INTO @TABLE VALUES (4,NULL)
INSERT INTO @TABLE VALUES (5,'JAYESH')
DECLARE @NAME VARCHAR(16) = NULL
SELECT * FROM @TABLE WHERE ISNULL(NAME,'') = CASE WHEN @NAME IS NULL THEN '' ELSE @NAME END
- SELECT * FROM tm_user WHERE USERID IS NULL
- SELECT * FROM tm_user WHERE USERID =0
Kalyani ShevalePosted Jan 18, 2019, 2:46 AM