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 5446

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

7 5320

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

TCS,

1 3897




what is a stored procedure and trigger?

3 2894

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

1 4750

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 7190

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

NIIT,

5 5986

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 3290




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

IBM,

21 13313

How to select nth record from a table?

Ramco, Microsoft, DELL,

13 27837

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

940

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,

1431

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

TCL, Wipro,

948

what is the difference between Delete and Truncate

Geo Research Centre, CarrizalSoft Technologies,

4 5082

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

8 5479


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1018


Call by value and call by reference in procedure and function, with NOCOPY.

230


ow to bring suspect mode datbase online from scratch

762


what is checksum in sql server.........???

467


Issues related in upgrading SQL Server 2000 to 2005 / 2008

857






How retrieve field names from the table in SQL through JAVA code?

772


Why we need to use secondry database file? though, we can do same work using primary database file also.

4374


Comment,Datatypes are unlimited

990


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1023


Tell about MOM Tool(Microsoft Operator Manager)?

763


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1419


1 01 101 01010

830


How can we call UDF(User Define Function) using C# code in ASP.net ?

4824


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., }

1115


where the connection string store in the database

898