If you are doing website project, which one is used dataset or data reader? Why?
Latest Answer: Data reader is used to fetch data from a databaseaccording to users condition.Data reader is used with the select statement.For Eg.to selecting a value from a database in our project, in c#.net we write,string s="Select * from employee";SqlCommand ...
What is a transaction isolation level and What is the advantage of it? What are different options that we set for a transaction isolation level?
Transaction isolation levels are used when we go for
Latest Answer: You need to add Snapshot to this answer. From BOL:Specifies that data read by any statement in a transaction will be the transactionally consistent version of the data that existed at the start of the transaction. The transaction can only recognize ...
I was asked in an interview..."Suppose u have a field with UNIQUE KEY. can u leave two or more cells NULL in SQL Server 2005...If Yes then Why...if NOT then Why.....
Latest Answer: In case of SQL Server : No and so is for DB2. But in case of Oracle : Yes.. Oracle supports multiple null values in the unique key column whereas SQL Server allows only one null value in the unique key column.. ...
If I have 10 statements, individually committing each statement is efficient or doing a bulk commit of all the 10 statements at the end is efficient.Also if we say one of them is efficient... is it efficient
Latest Answer: There is a trade-off in this case. In case of transaction-oriented scenario, I think executing 10 statements separately would be a better option since it will hold the lock for a very short duration allowing other processes to access the resource. But ...
Question: Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure
Latest Answer: Create a out parameter.Set value with NewId() which return a guid.then insert it into a table. ...
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 ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
