sql will throw error for not getting value to parameter. reference object

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 / amey

1 Answers
3688 Views
Aviva, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different types of replication are there in sql server 2000?

1087

How to count duplicated values in a column in ms sql server?

1166

What are the different types of triggers in SQL SERVER?

1187

How to remove duplicate rows from table?

1311

What is 2nf normalization?

1088

What is normalization 1nf 2nf 3nf?

1109

Distinguish between commit and rollback?

1011

How to convert numeric values to integers in ms sql server?

1159

How to create hyperlink from returned sql query ?

1183

How many non clustered indexes there can be on table ?

958

What is log ldf?

1044

Explain a differential backup?

1060

What is the difference between clustered and a non-clustered index?

1076

What is surrogate key? : sql server analysis services, ssas

1160

How to modify existing triggers using "alter trigger"?

1065