SQL Server Interview Questions
Questions Answers Views Company eMail

what is the difference between sql query and google query?

TCS,

10 7482

How can i change the column name.

Yardi Software, HCL,

12 12393

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

CompuSol,

3 3663




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

Progressive,

5 5034

to explain sql server 2000 architecture & authentication

HCL,

1 3440

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 5846

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

IBM,

5 8473

How can u convert the Date to String?

TCS, Microsoft,

6 11400




What is Deadlock?

Satyam,

4 4827

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

5 7207

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

IBM,

7 13788

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

2 5053

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

Wipro,

5 6405

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

6 17113

where the connection string store in the database

Wipro, HCL,

757


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

how to overcome kernel isssues

435


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

752


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

876


Comment,Datatypes are unlimited

871


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

317






How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

832


If user is owning any SQL Objects, can we drop that user

812


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

794


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4686


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2628


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1194


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

796


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

763


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?

908


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

4580