What are all new concepts in SQL Server 2008? That is
Exactly Difference between 2005 to 2008
Answers were Sorted based on User's Feedback
More powerful management
Policy Management feature
Improved performance and scalability
Storing high volume of data
Support for diverse types of data
Better security and availability
Security increased by data encryption
Availability increased by database mirroring
Changes for developers
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / jigar
Row Constructors
Output Clause
Compound Operators
Inline Variable Assignment
Grouping Sets
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a DBMS, query, SQL?
Explain sub-query?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How to use "begin ... End" statement structures in ms sql server?
Explain the different types of joins?
What is the difference between row_number and dense_rank?
What is truncate table?
What will happen when a Rollback statement is executed inside a trigger?
1 Answers Flextronics, Hexaware,
how you can list all the tables in a database?
Without Using Cursors , How to Select the Selected row??
3 Answers CarrizalSoft Technologies, Wipro,
Define compound operators?
how to get rank of diffrent student in same table based on newly inserted row in sql server2008
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)