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

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

Aptroid,

766

what is checksum in sql server.........???

TCS,

780

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

674

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

United Healthcare,

768

What is Lock table in SQL?

Wipro,

662

Can we call a function that has out parameter in select statement

Nagarro,

422

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

Nagarro,

504

If we delete pack Spec what will be the status of pack Body ?

Nagarro,

592

Delete duplicate rows without using rowid.

Nagarro,

617

how to find 6th highest salary

Chetak Logistics,

583

Explain few examples of stored procedure over triggers?

ADITI,

218

What are the different types of backups that exist?

ADITI,

270

What can be used instead of trigger?

ADITI,

238

What does asynchronous call backs means?

Alcatel-Lucent,

247

How do you implement session management in SQL Server mode?

Cap Gemini,

229







Un-Answered Questions { SQL Server }

Please explain what is “asynchronous” communication in sql server service broker?

168


How can I know what locks are running on which resource?

187


What is sql azure database?

118


What is the purpose of update statistics and scope_identity() function?

185


Does order by actually change the order of the data in the tables or does it just change the output?

242






How to maintain a fill factor in existing indexes?

185


What are the advantages of sql azure?

67


What is a primary index?

189


What is Cross Join and in which scenario do we use Cross Join?

210


What is the purpose of grouping data in a report?

159


What is self contained scalar sub query?

209


What is a matrix in ssrs?

45


List the various tools available for performance tuning?

200


How to disable stored procedure sql server?

174


What is the difference between ‘having’ clause and a ‘where’ clause?

194