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.


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


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 ?


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


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;


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?


your distribution database is full what will u do


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.


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


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


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


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


What is Lock table in SQL?


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


how can u get last observation in an unknown dataset ?


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


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


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


ow to bring suspect mode datbase online from scratch


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.