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 11641

explain different types of jions with examples briefly?

Zensar,

1 4412

explain different types of jions with examples briefly?

Accenture, Zensar, Excellence,

2 5634




explain different types of jions with examples briefly?

Zensar,

3 7361

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

3 9256

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

HP,

17 32766

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

3 3091

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 3845




Difference between Triggers and Stored Procedure

Protech, HCL, Claimat, Silgate,

23 56717

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 3290

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

1 2930

Advantages and Disadvantages of Cursor?

TCS, Zenith, Polytechnic,

15 81319

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 55458

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

6 5757

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

8 3952


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

893


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

729


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

887


what are the Prerequisites for Replication?

8513


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

891






Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1511


System variable and temporary variables

993


Issues related in upgrading SQL Server 2000 to 2005 / 2008

791


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1166


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

796


1 01 101 01010

765


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1312


how many no of arguments can be passed in procedures and functions

3517


If we delete pack Spec what will be the status of pack Body ?

189


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

845