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
3631 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

if no size is defined while creating the database, what size will the database have? : Sql server administration

0 Answers

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers IBM,

What is the architecture of ms sql reporting service?

0 Answers

Explain the difference between control flow and data flow?

0 Answers

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

0 Answers

What do you do in data exploration

0 Answers EXL,

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers

Which is the main third-party tool used in sql server?

0 Answers

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers TCS,

How to use clusters?

0 Answers Amdocs,

Which tcl commands are available on the sql server?

0 Answers

how many joins we can write if at all we have n no of tables

5 Answers Tanla Solutions, TS,

For more SQL Server Interview Questions Click Here