What are partitioned views and distributed partitioned views?
No Answer is Posted For this Question
Be the First to Post Answer
What is truncate table?
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is the maximum length of an alert name?
Explain about extended stored procedure?
What is the openxml statement in sql server?
How do I view a stored procedure in sql server query?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Explain few examples of stored procedure over triggers?
Explain system scalar functions?
How do you delete a trigger?
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.
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)