SQL Server Interview Questions
Questions Answers Views Company eMail

how can i lock the column in the table


2 4441

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

2 2629

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


5 5829

difference between truncate, delete aur drop?

2 2841

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


1 3421

how can u get last observation in an unknown dataset ?



What is stored procedure in SQL..??

2 2485

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 1978

whats the maximum size of view state??


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

Cap Gemini,

1 3521

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

Cap Gemini,

6 4283

What is Schema in Database?

Cap Gemini,

1 3198

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

Cap Gemini,

1 2785

What is index?

Cap Gemini,

1 2563

Tell me about Triggers?

Cap Gemini,

3 3837

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

what is package and it uses and how can u call a package


Which is the best place or learning center for MS SQL?????In Bangladesh?????


what is difference between view and Dip.


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




Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.


whats new about truncate in sql server 2008?


Does any body please help me what question's have asked for SSRS in the interview?


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


Issues related in upgrading SQL Server 2000 to 2005 / 2008


What is Lock table in SQL?


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


Explain Capacity planning to create a database? and how to monitor it?


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60