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
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
what are cursors? : Sql server database administration
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What is an etl file?
Explain candidate key, alternate key, and composite key?
What is identity?
what are the new features introduced in sql server 2000? : Sql server database administration
How to achieve Paging of records in SQL SERVER?
What is sql profiler. What are the default templates with it? : sql server database administration
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What is dbcc updateusage?
What do you understand by a view?
tell me the disaster recovery plan
What is the Disadvantage of indexed sequential file.
What are sql server procedures?
SQL Server Architecture ?