What are the basic functions for master, msdb, model, tempdb and resource databases?
- 0 Answers
- 656 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is delete query?
Disadvantages of the indexes?
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?
What are the options which must be set to allow the usage of optimistic models?
State the difference between union and union all?
What is dbcc?
What are cursors and when they are useful?
Delete duplicate records from the table?(Table must have unique id)
7 Answers TCS, Thomson Reuters,
How to execute a sql statement using mssql_query()?
what are different types of backups available in sql server? : Sql server database administration
What security features are available for stored procedure?
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
