SQL Server Interview Questions
Questions Answers Views Company eMail

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

Polaris,

6 11758

explain different types of jions with examples briefly?

Zensar,

1 4473

explain different types of jions with examples briefly?

Accenture, Zensar, Excellence,

2 5709




explain different types of jions with examples briefly?

Zensar,

3 7424

can we call functions from stored procedure in SQL Server 2005 ? How?

3 9316

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

HP,

17 33302

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 3148

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 3910




Difference between Triggers and Stored Procedure

Protech, HCL, Claimat, Silgate,

23 56998

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 3370

How to list all tables having unique constraints in any of the columns in a database.

1 2968

Advantages and Disadvantages of Cursor?

TCS, Zenith, Polytechnic,

15 81795

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 55889

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 5838

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 4060


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what exactly sql injuction.how to overcome.....

1353


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

928


Issues related in upgrading SQL Server 2000 to 2005 / 2008

838


Delete duplicate rows without using rowid.

244


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

929






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

874


1 01 101 01010

805


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

1072


on line cluster can we make if yes tell me the procedure

886


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

4764


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

871


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

953


Comment,Datatypes are unlimited

971


If the job running very slow what is the action you do

770


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

925