SQL Server Interview Questions
Questions Answers Views Company eMail

how can i lock the column in the table

Accenture,

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

Ramco,

5 5829




difference between truncate, delete aur drop?

2 2841

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

ABC,

1 3421

how can u get last observation in an unknown dataset ?

Genpact,

1083

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??

892

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

835


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

827


what is difference between view and Dip.

1137


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

1096


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1457






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

1249


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.

1525


whats new about truncate in sql server 2008?

1254


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

794


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

130


Issues related in upgrading SQL Server 2000 to 2005 / 2008

719


What is Lock table in SQL?

199


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

264


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

2709


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

876