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 5070

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

7 4981

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

TCS,

1 3687




what is a stored procedure and trigger?

3 2665

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

1 4577

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 6900

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

NIIT,

5 5753

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 3094




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

IBM,

21 12470

How to select nth record from a table?

Ramco, Microsoft, DELL,

13 25994

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

834

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,

1246

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

TCL, Wipro,

829

what is the difference between Delete and Truncate

Geo Research Centre, CarrizalSoft Technologies,

4 4670

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

8 5177


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

616


What is best institute to Learn DotNET And SQL in chennai?

913


can any body tell me how to know the password of current user in sql server

878


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

889


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

649






How to trouble shoot if unable to connect SQL Server

725


what is the Ticketing tool used in Wipro technologies at Bangalore...???

4791


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?

573


what is the sql equivaent of the dataset relation object ?

793


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.

1305


What are the dis_advantages of stored procedures, triggers, indexes?

903


Why do you want to join software field as you have done your BE in Electronics?

972


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

867


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

319


If a stored procedure is taking a table data type, how it looks?

4561