Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 52905 Views
- Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain, I also Faced
- E-Mail Answers
Answer Posted / pavan
lot of differences:
1. mirroring
2. transactional with updatable subscription
3. resource database
4. serialization
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
please differentiate between delete and truncate?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
How can you find out how many rows returned in a cursor?
How do I get to sql server configuration manager?
How to install sql server 2005 express edition?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is clustered index
What is a covered index?
What do you mean by an execution plan? How would you view it?
What is a deadlock and what is a live lock?
What is a bit datatype?
How to make conditional sum in ssrs?
Why I am getting this error when dropping a database in ms sql server?
What is SubQuery in SQL Server 2008
Differentiate between a having clause and a where clause.
