Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

wht is normalization?can u explain me in detail?

TCS,

9 13231

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 8844

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

HP,

1 3603

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

IntraLogic, Oracle,

1447

How many index keys possible for a table

6 9006

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

DELL, i Tech, Infosys, Siemens, TCS,

9 57896

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 21500

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

Leo Technologies, Mannar Company, Synechron,

15 24283

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 9110

What are Magic Table?

3i Infotech, Digiweb, Evalueserve, NIIT, PL,

34 61093

what are file groups?

Evalueserve,

3 7506

what is the cursor life span?

Evalueserve, HG,

5 10946

What is the difference between NOROW and LOCKROW?

Accenture, Honeywell, Satyam,

1691

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1361

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

IBM, Symphony,

28 18543







Un-Answered Questions { SQL Server }

How to change parameter value inside the report?

30


Explain primary key, foreign key and unique key?

178


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

1109


Explain different types of locks in sql server.

184


what are the disadvantages of cursors? : Sql server database administration

158






What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

194


How to generate create view script on an existing view?

170


What objects does the fn_my_permissions function reports on? : sql server security

166


What are different types of table joins?

172


Explain table valued parameters in sql server? Why tvp used?

189


How to verify a user name with sqlcmd tool?

172


How to backup encryption key ?

30


What is BCP? When does it used in sql server 2012?

191


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

204


Difference between aggregate functions of sql?

206