How to display the table data in XML format using SQL Server.
Latest Answer: The only thing you have to do is to insert "for XML Auto" in your query and the result will be returned in XML format.Eg. Let there be a table with name tblABCNormally   Select * from tblABCFor XML Data   Select * from tblABC for XML Auto ...
Latest Answer: There is no hard and fast rule. It depends on you SQL statements.There some usefull guideline.Turn on Execution plan.Avoid cursorUse Cluster index (try to keep it small).If possible use 'If Exit'Try to avoid Rebuild option. ...
I would like to know whether it uses SOAP or XML.
Latest Answer: XML for Analysis (XMLA) is a Simple Object Access Protocol (SOAP)-based XML protocol, designed specifically for universal data access to any standard multidimensional data source residing on the Web. XMLA also eliminates the need to deploy a client component ...
Latest Answer: There are over 80 distinct system privileges. Each system privilege allows a user to perform a particular database operation or class of database operations.Such as:- 1. ANALYZE ANY ...
Latest Answer: You can use the PIVOT relational operators to change a table-valued expression into another table. PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs ...
Latest Answer: bigint can hold values from -2^63 (-9,223,372,036,854,775,807) to 2^63-1 (9,223,372,036,854,775,807) and it takes 8 bytesint can hold values from -2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647) and it takes 4 bytes ...
Latest Answer: DTS is a set of tools you can use to import, export, and transform heterogeneous data between one or more data sources, such as Microsoft SQL Server, Microsoft Excel, or Microsoft Access.The Import/Export Wizard is for building relatively simple DTS packages, ...
Latest Answer: Yes, coming to your answer clustered index is used and applied only and primary keysFor example if a table student is created consider here in this table student id is the primary key so clustered index is applied on the student id column.Coming to non-clustered ...
Latest Answer: User Identification: In virtue of Data base server Identification tries to
find whether you are registered user in the database or not. It applies to whole
database server.
Authentication: It applies for special Privileges for a user in the database. ...
Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform a full database backup. You decide to implement the following backup strategy : Full backup : 9am SundayFile 1 backup : 8pm Monday eveningFile 2 backup : 8pm Tuesday eveningFile 3 backup : 8pm Wednesday eveningFile 1 backup : 8pm Thursday eveningFile 2 backup : 8pm Friday eveningFile 3 backup : 8pm Saturday eveningTransaction log backups : Hourly, every day.DB suffers critical failure
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
