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 |
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
When a primary key constraint is included in a table, what other constraints does this imply?
Difference between 2NF &3NF ?
Write a SQL Query to find first Week Day of month?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What types of integrity are enforced by a foreign-key constraint
What is Data model and how to prepare a data model.?
Security Question- SQL DBA exparts, need your help...
How to create a view with data from multiple tables?
is there a column to which a default can't be bound? : Sql server database administration
How do you fine the performance tunning?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
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)