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

Explain SELF JOIN ?

3 Answers ADP,

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers

Explain Geometry datatype in sql server 2008 with example

0 Answers Infosys,

What command would you use to add a column to a table in sql server?

0 Answers

Explain different types of lock modes in sql server 2000?

0 Answers

Where are stored procedures in sql server?

0 Answers

What is ems sql management studio? : sql server management studio

0 Answers

what is the Enterprise manager(2000) and management studio (2005)?

2 Answers

How would you choose between a clustered and a non-clustered index?

0 Answers

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers

How many columns can we include on clustered index ?

0 Answers

How to find the date and time of last updated table?

3 Answers

For more SQL Server Interview Questions Click Here