SQL Server Interview Questions
Questions Answers Views Company eMail

What is INTVAL( )and where we use Plz any body help me

1 4182

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

766

What is the difference between a stored procedure and a user defined function in sql server?

Millennium,

2 5299




could u plz explain about joins and views?

2 2659

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 2855

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 4634

what is the sql equivaent of the dataset relation object ?

890

How To delete duplicate record from a particular table?

eXensys, Foxfire,

12 16235




What is the difference between Drop and Truncate

IBM, GT Nexus,

20 24726

Anyone please explain me the concept of Serialization?

3 2753

What is transaction ? Give me one example.

Melstar, Wipro,

11 19442

UPDATE statement can on a single table or on the multiple table?

iGate, TCS,

7 8271

What is difference between TRUNCATE and DELETE statement

CTS,

12 13984

can any one please send sql quries most used in applications.

2 2228

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

Patni,

13 12091


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

987


your distribution database is full what will u do

1014


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1715


Why do you want to join software field as you have done your BE in Electronics?

1076


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

876






Scalability, Availability, Integration with internet, etc.)?

1718


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

768


What is Lock table in SQL?

334


what is checksum in sql server.........???

451


how can u get last observation in an unknown dataset ?

1221


What are the dis_advantages of stored procedures, triggers, indexes?

1029


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

1362


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

433


ow to bring suspect mode datbase online from scratch

745


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

411