if a parameter is not send to a stored procedure what type of identifier is to

if a parameter is not send to a stored procedure what type
of identifier is to be used in Stp and if that parameter is
not feed to the a query inside the Stp how to validate with
out useing IF condition

Question Posted / skiran_81

1 Answers
3523 Views
Aviva, I also Faced
E-Mail Answers

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and ..

Answer / amey

sql will throw error for not getting value to parameter.
reference object is null.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More SQL Server Interview Questions

What are the limitation of the Online Index Rebuild Operation?

1 Answers

Do you know what is blocking?

0 Answers

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers

What do you mean by sql server agent?

0 Answers

How to achieve Paging of records in SQL SERVER?

0 Answers Petranics Solutions,

Explain the difference between HTTP and HTTPS in database?

0 Answers Wipro,

Do you know what is rank function?

0 Answers

Can we use custom code in ssrs?

0 Answers

What is deadlock and how to avoid the deadlocks.