SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between OLEDB and ODBC

CFCI,

4 8527

What are mdf,ndf,ldf files and how to see the data in those files?

Accenture,

6 53224

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

Value Labs,

1300




What is the difference between DTS and SSIS?

Allianz,

3 33100

How to Debug a Stored Procedure?

Allianz,

5 8103

How to link up the text file to a Database table?

Allianz,

2 3717

Which institute is best for SQL Server 2005 Training?

6 3071

What is user stored procedure & it purpose?

Wipro,

4 4474




How do we rollback the table data in SQL Server

3 13816

where do you use Isolations?give me some exmpale?

1 3226

In which year relase the 7.0& 2000 & 2005?

1 1968

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

Covansys,

1 4219

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 4217

select empid empname from employee What is the result for the about query?

4 3496

can you any body tell me suppose database is suspect mode. how can take to normal?

Teledata,

2 3986


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1102


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

847


what is difference between view and Dip.

1206


If the job running very slow what is the action you do

713


role of sql sever 2005 in database rather than any other database

883






where the connection string store in the database

819


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1332


What is the difference between online clustering and Offline clustering?

1227


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

362


How to convert a table data in XML format in sql server?

1399


what exactly sql injuction.how to overcome.....

1309


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1577


how many no of arguments can be passed in procedures and functions

3493


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1151


Which is the best place or learning center for MS SQL?????In Bangladesh?????

879