How can i search faster from thousands of records ?

Question

hello guys how r u all?

my question is that, i have 50,000 records in a table and i have to run search query on it , so what is the fastest query to search a record from thousands of records ..

replyy soon


thanks

Answer 1

You can use ISNULL function, if value is null it display 0

 

ISNULL(columnName, 0)

 

For further reference:

http://stackoverflow.com/questions/16667148/instead-of-null-how-do-i-show-0-in-result-with-select-statement-sql

 

Do let me know if it solves your problem. 

Answer 2

Use this code.

ISNULL(clmnName, 0)