Tell me what is the significance of null value and why should we avoid permitting null values?
No Answer is Posted For this Question
Be the First to Post Answer
How will you hide an attribute? : sql server analysis services, ssas
How get current date in SQL server 2000
How do I view a script in sql server?
What is the default value of an integer data type in sql server 2005?
Explain active/passive and active/active cluster configurations?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
Why use update_statistics command in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
Differentiate between a having clause and a where clause.
What is join and name different type of joins?
Explain indexed views and partitioned view with their syntax.
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)