Explain alternate key, candidate key and composite key in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.
Explain error and transaction handling in sql server?
What is the difference between varchar and nvarchar?
How to insert multiple rows with a subquery?
How to delete exactly duplicate records from a table?
What are the types of resultset?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
What are indexes in sql?
How to list all tables having unique constraints in any of the columns in a database.
When I run the sql server 2000 setup, it just hangs. What do I do?
Name three of the features managed by the surface area configuration tool? : sql server security
Explain go command in sql server?
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)