exec Store Procedure in condition

chetan shinde11y ago

No Not In this way ...

0

Upendra Pratap Shahi11y ago

http://www.codeproject.com/Articles/13555/Setting-up-Stored-Procedures-with-Optional-Paramet

Select firstname,lastname from [your_tablename] where firstname IS NOT NULL

try this type code .

If help mark as This is correct answer

0

chetan shinde11y ago

yeah but i dont want to edit the store procedure.

i want to edit in when we write

exec Storeprocname (parameters).

is there any way to check ...

like we write isnull in start or check for value 0 in exec statement

0

Syed Shanu11y ago

In that case you can check in where condition for example

Select firstname,lastname from your tablename

where firstname IS NOT NULL

hope this will help you.

0

chetan shinde11y ago

Yeah Right.....

0

Syed Shanu11y ago

Do you mean you dont want to show null row for certain Column.for example you have FirstName and Lastname as columns and if there is any null in firstname then dont need to show that row ?

0