What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
No Answer is Posted For this Question
Be the First to Post Answer
When you first load SQL SERVER you will startup with what all databases?
What are different types of collation sensitivity?
Explain what is cte (common table expression)?
What are number line correlation administrators will use while working with a subquery?
What does executeupdate return?
How to convert numeric expression data types by assignment operations?
Explain the different types of backups available in sql server? : sql server database administration
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?
can any one please send sql quries most used in applications.
hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution
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.
What is the advantage of sql server?
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)