How to get all values null

Question

select * from tm_user where userid=@userid

Jayesh Vaghasiya · Answer

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

Kalyani Shevale · Answer

SELECT * FROM tm_user WHERE USERID IS NULL SELECT * FROM tm_user WHERE USERID =0 SELECT * FROM tm_user WHERE USERID = NULL

Rupesh Kahane · Answer

SELECT * FROM tm_user WHERE USERID IS NULL SELECT * FROM tm_user WHERE USERID =0 Try this

Asma Khalid · Answer

use below code from SQL direct i.e. SELECt * FROM tm_user WHERE userid IS NULL This will return rows with only NULL user ID

Vinay Kumar Dara · Answer

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

Jignesh Kumar · Answer

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

Bikash Sahu · Answer

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.

Riddhi Valecha · Answer

Hi, Are you passing the value - @userid - from front-end? Then - If txtbox.text.Length @userid = '' or @userid = DBValue.Null or @userid = null If you need it from sql then try - select * from tm_user where len(userid) --------

Janak Sabhaya · Answer

select * from tm_user where userid=0 You always get Null data

How to get all values null

Answers (9)