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

How do I start sql server agent automatically?

0 Answers

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers

What is create statement?

0 Answers

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers ASD Lab,

What is deadlock and how to avoid the deadlocks.

3 Answers TCS, Wipro,

Explain indexed view?

1 Answers

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers Accenture, Polaris,

Give the query of getting last two records from the table in SQL SERVER?

0 Answers Petranics Solutions,

Explain how to use linked server?

0 Answers

What is wide table?

0 Answers

Explain primary key and foreign key constraints?

0 Answers

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers

For more SQL Server Interview Questions Click Here