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

how can i lock the column in the table

Accenture,

2 5164

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 3265

how to get the salary in descending order with out using the keyword desc in sql

Ramco,

5 6885

difference between truncate, delete aur drop?

2 3451

how many no of arguments can be passed in procedures and functions

ABC,

1 4019

how can u get last observation in an unknown dataset ?

Genpact,

1480

What is stored procedure in SQL..??

2 3169

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 2530

whats the maximum size of view state??

1280

How can u get the number of pupils connecting the database?

Cap Gemini,

1 4110

How to a Query to copy data from on table to another table.

Cap Gemini,

6 5458

What is Schema in Database?

Cap Gemini,

1 3932

What is storeprocedure?Tell me synatx for how to write stored procedure.

Cap Gemini,

1 3465

What is index?

Cap Gemini,

1 3171

Tell me about Triggers?

Cap Gemini,

3 4805







Un-Answered Questions { SQL Server }

on line cluster can we make if yes tell me the procedure

1143


What do you know about normalization and de- normalization?

143


What is the server name in sql server?

144


How to create user messages with print statements in ms sql server?

186


What is the default Port No on which SQL Server listens?

200






Does sql server use java?

132


How to enter date and time literals in ms sql server?

174


What are the different types of Indexes available in SQL Server?

180


Explain the various types of concurrency problem?

183


what are acid properties? : Sql server database administration

143


What are character string data types in ms sql server?

187


How you trouble shoot when any job fails

1047


Do you know what is replace and stuff function in sql server?

148


What is user-defined function?

140


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

164