SQL Server Interview Questions
Questions Answers Views Company eMail

how can i lock the column in the table

Accenture,

2 4516

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

2 2689

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

Ramco,

5 5915




difference between truncate, delete aur drop?

2 2907

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

ABC,

1 3472

how can u get last observation in an unknown dataset ?

Genpact,

1126

What is stored procedure in SQL..??

2 2543

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 2027




whats the maximum size of view state??

932

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

Cap Gemini,

1 3580

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

Cap Gemini,

6 4385

What is Schema in Database?

Cap Gemini,

1 3266

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

Cap Gemini,

1 2871

What is index?

Cap Gemini,

1 2649

Tell me about Triggers?

Cap Gemini,

3 3935


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Working with TLogs

675


what exactly sql injuction.how to overcome.....

1302


sql database suspect We have a sql database that is showing as suspect. How can we recover?

702


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

865


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

700






ow to bring suspect mode datbase online from scratch

677


where the connection string store in the database

808


What is the difference between online clustering and Offline clustering?

1213


How much memory that we are using in Logshipping Concept?

686


How we create SQL Server 2005 Reporting Services ? Give me Sample

903


How you trouble shoot when any job fails

674


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

887


System variable and temporary variables

969


Issues related in upgrading SQL Server 2000 to 2005 / 2008

755


how to take backup bcp out for a column in table in sql server?

836