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 5194

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

7 5077

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

TCS,

1 3758




what is a stored procedure and trigger?

3 2736

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

1 4632

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 6990

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

NIIT,

5 5839

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 3164




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

IBM,

21 12722

How to select nth record from a table?

Ramco, Microsoft, DELL,

13 26710

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

870

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,

1300

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

TCL, Wipro,

864

what is the difference between Delete and Truncate

Geo Research Centre, CarrizalSoft Technologies,

4 4774

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

8 5275


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

how can you attach more than 20 ldf files in sql server

813


application server is slow what may be the problem

1073


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

661


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2638


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1048






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

660


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

864


what is isolation level at dead lock?

999


how to overcome kernel isssues

459


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1131


what is difference between view and Dip.

1180


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

601


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.

353


New concepts of sql server 2005 use in your project.

1224


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1027