SQL Server Interview Questions
Questions Answers Views Company eMail

how can i lock the column in the table


2 4392

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

2 2559

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


5 5748

difference between truncate, delete aur drop?

2 2780

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


1 3361

how can u get last observation in an unknown dataset ?



What is stored procedure in SQL..??

2 2431

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 1941

whats the maximum size of view state??


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

Cap Gemini,

1 3468

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

Cap Gemini,

6 4206

What is Schema in Database?

Cap Gemini,

1 3157

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

Cap Gemini,

1 2753

What is index?

Cap Gemini,

1 2523

Tell me about Triggers?

Cap Gemini,

3 3783

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...


New concepts of sql server 2005 use in your project.


Comment,Datatypes are unlimited


how to use DTS package in 2000,2005,2008 in sql server


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.


what are the critical issues you have resloved in your company


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


application server is slow what may be the problem


What is best institute to Learn DotNET And SQL in chennai?


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.


plss anybody specify tha constrian management system in dbms


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?


If the job running very slow what is the action you do


How do you Implement SSIS Packages in your Project?