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 / amey
sql will throw error for not getting value to parameter.
reference object is null.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is Data Transformation Services (DTS) ?can u explain me in detail?
What are the instances when triggers are appropriate?
how can u select the Distinct values in the table, table having 20 columns , i want all columns
Disadvantages of the indexes?
What is a trigger in sql server?
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
Define tempdb database?
What is WITH CHECK OPTION
3 Answers Karur Vysya Bank KVB,
What is msdb database? : SQL Server Architecture
why we use cursor?
4 Answers CarrizalSoft Technologies, Melstar, TCS,
How to run queries with sql server management studio express?
What is the difference between composite index and covering index?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)