SQL Server Interview Questions
Questions Answers Views Company eMail

what is the difference between sql query and google query?

TCS,

10 7692

How can i change the column name.

Yardi Software, HCL,

12 12788

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

CompuSol,

3 3817




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

Progressive,

5 5183

to explain sql server 2000 architecture & authentication

HCL,

1 3547

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 6146

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

IBM,

5 8706

How can u convert the Date to String?

TCS, Microsoft,

6 11618




What is Deadlock?

Satyam,

4 4965

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

5 7389

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

IBM,

7 14041

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

2 5194

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

Wipro,

5 6632

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

6 17303

where the connection string store in the database

Wipro, HCL,

832


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

application server is slow what may be the problem

1095


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

5084


where the connection string store in the database

832


whats new about truncate in sql server 2008?

1325


Call by value and call by reference in procedure and function, with NOCOPY.

164






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?

883


ow to bring suspect mode datbase online from scratch

701


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

1321


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

4675


Comment,Datatypes are unlimited

936


your distribution database is full what will u do

969


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

1167


what are the Prerequisites for Replication?

8516


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

1034


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2720