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

Why we need a group by clause?

4 7304

What is a join and their types?

Challenger Financial,

2 5611

What is the difference between referencing and joining?

1 2720

What is the difference between constraints and triggers?

Wipro,

9 29078

What is ACID Property of Transaction?

10 32249

What is an index?

Yardi Software,

8 11040

What is normalization and its forms?

Challenger Financial,

4 11319

What is a cursor in SQL Server 2000 and their types?

8 14755

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 47758

How do we return a record set from a Stored Procedure in SQl server 2000?

3 4365

What are the magic tables in SQL Server 2000?

Infogain, Merrill Lynch,

7 21245

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 45658

What are the differences between stored procedure and functions in SQL Server 2000?

College School Exams Tests, HCL, Infosys, TCS,

25 100304

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 4402

Which is best Subquery (or) joins in sql server? explain why

2 9505







Un-Answered Questions { SQL Server }

What is the difference between varchar and nvarchar?

119


What stored by the msdb? : sql server database administration

187


How to use column default values in insert statements in ms sql server?

167


How to drop existing indexes in ms sql server?

168


What are difference between Cluster index and Non-Cluster index?

206






How to create an index on an existing table in ms sql server?

179


What is conditional split?

153


Why use triggers?

174


Define inner join in sql server joins?

151


How to disable triggers using "disable trigger"?

181


How to create a user to access a database in ms sql server using "create user" statements?

172


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

164


What is an sql server agent?

161


Is it possible to call a stored procedure within a stored procedure?

172


Explain the use of containers in ssis?

150