Write an sql query to find the names of employees start with ‘a’?
How to tune a stored procedure?
Do you know what is a linked server in sql server?
Can we passed multiple recordset(set of records) using a Stored Procedure
How do you delete duplicate rows in sql server?
How to turn off warning messages during php execution?
Where the sql logs gets stored?
what is a cursor and what is its use?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
11 Answers World Tech, Yardi Software,
Can we insert data if clustered index is disabled?
Explain difference between control flow and data flow?
How to list all tables having unique constraints in any of the columns in a database.
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
Oracle (3253)
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)