SQL Server Interview Questions
Questions Answers Views Company eMail

how can i lock the column in the table

Accenture,

2 4559

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

2 2748

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

Ramco,

5 5980




difference between truncate, delete aur drop?

2 2947

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

ABC,

1 3518

how can u get last observation in an unknown dataset ?

Genpact,

1169

What is stored procedure in SQL..??

2 2597

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 2069




whats the maximum size of view state??

964

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

Cap Gemini,

1 3633

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

Cap Gemini,

6 4487

What is Schema in Database?

Cap Gemini,

1 3319

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

Cap Gemini,

1 2936

What is index?

Cap Gemini,

1 2704

Tell me about Triggers?

Cap Gemini,

3 4003


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1167


what is the Ticketing tool used in Wipro technologies at Bangalore...???

5084


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

1158


Working with TLogs

695


last function used in MS Access to convert sql what function will use in sql

866






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

730


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1365


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

795


How to restore performance issues and how to check?

861


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1122


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.

2694


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 ?

875


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.

1601


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

898


what is the sql equivaent of the dataset relation object ?

855