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
- 1 Answers
- 2901 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
What new changes are being made in SQL Server?
how we use window authentication connection with sql server.?
How to provide values to stored procedure parameters in ms sql server?
Will the writetext statement activate a trigger?
What is lock escalation and what is its purpose?
What is ms sql server reporting services?
What are temporal tables in sql server 2016?
Why I am getting this error when renaming a database in ms sql server?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What are the different types of stored procedures?
difference between Clustered index and non clustered index ?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to connect sql server management studio express to sql server 2005 express?
what are isolation levels? : Sql server database administration
What is command parameter in ssrs?
