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

When do u use clustered index and non-clustered index?

3 Answers   IBM,

Explain sql delete command?

0 Answers  

one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  

What is the default sql server instance name?

0 Answers  

Tell me the difference between clustered and non-clustered index?

0 Answers  




1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

how can do you the system monitoring?

1 Answers  

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

What do you mean by an execution plan?

0 Answers  

What is a document index?

0 Answers  

Can you explain what are commit and rollback in sql?

0 Answers  

How to use old values to define new values in update statements in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories