1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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


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 3 types of schema?

0 Answers  

How to perform backup for certificates in sql server? : sql server security

0 Answers  

whats the maximum size of view state??

0 Answers  

Explain about nested stored procedure?

0 Answers  

When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  




Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

How to connect of datebase with sql express.?

0 Answers   MCN Solutions,

How to add an address record into adventureworkslt?

0 Answers  

Explain how many types of relationship?

0 Answers  

How does stuff differ from the replace function?

0 Answers  

What are trace flags?

0 Answers  

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories