SQL Server Interview Questions
Questions Answers Views Company eMail

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

HCL, ZX,

5 5353

what is the difference between group and having give an example with query and sample output

7 5221

What is Data model and how to prepare a data model.?

TCS,

1 3846




what is a stored procedure and trigger?

3 2829

How to retrieve data from log files in SQL SERVER ?????

1 4699

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 7123

Whether the updations made to the views reflect the original records in the table

NIIT,

5 5931

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 3240




how to select 5 to 7 rows from a table, which contains 10 rows?

IBM,

21 13057

How to select nth record from a table?

Ramco, Microsoft, DELL,

13 27382

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

909

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

IBM, CSC,

1386

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

TCL, Wipro,

910

what is the difference between Delete and Truncate

Geo Research Centre, CarrizalSoft Technologies,

4 4958

from the table display the 2nd highest salary? and also the least 2nd salay?

8 5391


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

1148


where the connection string store in the database

858


How do use Having,Group by,Group function in SQL?

707


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1677


how to use DTS package in 2000,2005,2008 in sql server

818






Does any body please help me what question's have asked for SSRS in the interview?

936


New concepts of sql server 2005 use in your project.

1266


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

733


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

866


how to do partition in sqlserver

1344


What is the difference between NOROW and LOCKROW?

1340


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

710


whats the maximum size of view state??

986


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

701


What is Lock table in SQL?

311