SQL Server Interview Questions
Questions Answers Views Company eMail

what is the difference between sql query and google query?

TCS,

10 7618

How can i change the column name.

Yardi Software, HCL,

12 12601

When you first load SQL SERVER you will startup with what all databases?

CompuSol,

3 3747




Can Somebody tell me the difference between Clustered & Non- Clustered Index??

Progressive,

5 5116

to explain sql server 2000 architecture & authentication

HCL,

1 3502

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 2 Solution : emp1 names are updated in emp2, write a query?

8 6008

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

IBM,

5 8588

How can u convert the Date to String?

TCS, Microsoft,

6 11534




What is Deadlock?

Satyam,

4 4909

select top 5 * from emp order by newid() my question is , how this query get executed?

5 7312

how to get the rowid/rownumbes of a table in sqlserver

IBM,

7 13950

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 5131

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

Wipro,

5 6545

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 17228

where the connection string store in the database

Wipro, HCL,

808


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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 should i optimize the time for execution of stored procedure having single input and many output from the different tables?

802


What is data modeling and Reterminal integrity?

649


You are doing log shipping due to some reasons it is failing. How you will proceed from there

807


how to overcome kernel isssues

459






what is difference between view and Dip.

1182


plss anybody specify tha constrian management system in dbms

809


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1238


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1092


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

686


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

3472


What is the difference between online clustering and Offline clustering?

1213


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

1486


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?

844


where the connection string store in the database

808