|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix. OLE-DB.NET is a .NET layer on top of the OLE layer, so it's not as fastest and efficient as SqlServer.NET.
Create Date
:
Tuesday, May 13, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
For restoring the master db we have to stop the SQL Server first and then from command line we can type SQLSERVER -m which will basically bring it into the maintenance mode after which we can restore the master db.
Create Date
:
Saturday, May 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Stored Procedures are called by the programmer wherever it wants to fire and
the stored procedures used in the database independently.
To use stored procedure you have to make a call to that procedure.
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Index is commonly used for faster data retrieval.We can have only one Clustered Index and many
non-clustered index in a single table.It is known that there is some limitations in using indexes.
If a column is defined as primary key,by default column is set to be clustered index.All other indexes created
manually in the same table were non-clustered index.
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
In the first query the result is -> no rows selected.
In the second query result is -> all the data in the emp table will be displayed.
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.