INTERVIEW QUESTIONS DATABASE SQL SERVER DETAILS

Question : How we can make sure that the SQL query does not return NULL values? Category SQL Server Interview Questions Rating (0.0) By 0 users Added on 4/3/2008 Views 693 Rate it! * * * * * * * * * * * * * * *

Answers: 1. Without any Null Value for Column1: Select * From Table1 Where Column1 Is Not Null 2. Instead of Null values it returns as '0': Select IsNull(Column1,0) Column1,* From Table1 If you have the better answer, then send it to us. We will display your answer after the approval. Name :* Email Id :* Answer :* Verification Code  Not readable? Load New Code   Enter the above shown code:* Inform me about updated answers to this question

	Related Questions	View Answer
	Name of the class of SQL?	View Answer
	What is the difference between Varchar and Varchar2?	View Answer
	What is the difference between Inner join and full outer join in terms of the Number of rows return	View Answer
	What is table in SQL server? What is ##table in SQL server?	View Answer
	Give some examples of Analytical functions?	View Answer
	What is the difference between "translate" and "replace"?	View Answer
	How functional dependency is related to database table design?	View Answer
	What is DYNAMIC SQL method ?	View Answer
	What is the query used to display all tables names in SQL Server (Query analyzer)?	View Answer
	What is the query used to display all tables names in SQL Server (Query analyzer)?	View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email: