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

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

TCS,

8 8725

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 7480

Can some one please help with a query which will take only max value of a column in a join.

2 2730

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

TVS,

2 3591

which database is best to use in oracle and sql server? explain reasons?

TCS,

5 5432

why we use cursor?

CarrizalSoft Technologies, Melstar, TCS,

4 11776

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

CarrizalSoft Technologies, iGate,

3 10606

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

3i Infotech, Rolta, TCS,

17 10793

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 4216

Explain Trigger with an example?

2 10355

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 3115

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

HCL,

1172

What is difference between Triggers and store procedure?

2 3495

How reterive duplicate value in SQL?

6 7053

What is Transaction?

2 4152







Un-Answered Questions { SQL Server }

Explain aggregate functions?

205


Explain what are the authentication modes in sql server?

198


Explain what role entity and relationship play in an ER diagram.

221


What have included columns when we talk about sql server indexing?

204


What are sparse columns?

214






What are the authentication modes in sql server? How can it be changed?

232


How to populate a table in sql server?

160


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1215


What is a join in sql?

204


What is the difference between count and distinct count?

160


Do you know how to implement service broker?

177


List some of the rules that apply to creating and using a ‘view’

187


How is a full-text index updated?

209


How do I know if localdb is running?

167


Explain relational data?

189