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

In which format does an image save in SQL Server database ?

0 Answers MCN Solutions,

Name three of the features managed by the surface area configuration tool? : sql server security

0 Answers

Which are the important points to note when multilanguage data is stored in a table?

0 Answers

What are the disadvantages of primary key and foreign key in SQL?

0 Answers Alcatel-Lucent,

What is normalization and denormalization in sql server?

0 Answers

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers Adea Solutions,

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers Millennium,

What do you mean by sql server agent?

0 Answers

What are different types of raid configurations? : SQL Server Architecture

0 Answers

What is the difference between char and varchar2 datatype in sql?

0 Answers

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers

What is 'write-ahead log' in sql server 2000 ?

0 Answers

For more SQL Server Interview Questions Click Here