What are subqueries in sql server? Explain its properties.
- 0 Answers
- 719 Views
- I also Faced
- E-Mail Answers
What are translations and its use? : sql server analysis services, ssas
what is dbcc? : Sql server database administration
Why use triggers?
Selet all the data from table where last name is n of employee
How to loop through result set objects using odbc_fetch_row()?
An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).
What is the contrast between sql and mysql?
Does an index slow down updates on indexed columns?
List some of the rules that apply to creating and using a ‘view’
How to perform key word search in tables?
Why would you call update statistics?
Questions on identity?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
