SQL Server Interview Questions
Questions Answers Views Company eMail

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 6164

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 15596

How do you find the number of rows in a table?

7 13174




Difference between Cluster and Non-cluster index?

Accenture, eClinicalWorks, HCL, Satyam, Oracle, Yardi, Agility e-Services, Infosys,

32 123342

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 6854

Explain DBMS, RDBMS?

6 19412

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

TetraSoft, Wipro,

3 17573

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 13947




Explain couple pf features of SQL server

2 3967

Scalability, Availability, Integration with internet, etc.)?

1685

Explain fundamentals of Data ware housing & OLAP?

2 5557

Explain the new features of SQL server 2000?

1 4514

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

899

Explain sp_configure commands, set commands?

3 9125

What is the basic functions for master, msdb, tempdb databases?

CSC,

2 13417


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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.

392


where the connection string store in the database

858


How we create SQL Server 2005 Reporting Services ? Give me Sample

947


application server is slow what may be the problem

1114


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

910






How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

851


Scalability, Availability, Integration with internet, etc.)?

1685


Issues related in upgrading SQL Server 2000 to 2005 / 2008

820


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

1148


If we delete pack Spec what will be the status of pack Body ?

208


what is package and it uses and how can u call a package

932


how can u get last observation in an unknown dataset ?

1192


how to take backup bcp out for a column in table in sql server?

885


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

698


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

973