1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

what is the main difference between constraints(like primary key etc..)& joins?

 2 5307

What are the types of model in sql server and explain

TCS,

2 5459

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 13259

What are the types of backup and tell me the difference between full and differential backup?

CTS, TCS,

4 12231

What is the difference between login and a user?

CTS, TCS,

13 27759

What is the use of placing primary key and foreign key constrains on columns.

Value Labs,

4 7040

what is IDE,DMV in sql server?

Value Labs,

1 7836

Wht is Stuff in sql ser

 2 4507

how to get 25th row in any table in sqlserver can u tell me syntax

 8 10244

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 11167

What is the default value of CHAR type?

Bosch,

10 19221

How to find the last update record in SQL Server?

 4 15895

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

Value Labs,

7 9975

Can we create a clustered index on composite primary key.

IGT,

3 18395

what is hash table

ILFS, Teledata,

3 19594

Un-Answered Questions { SQL Server }

What it means to be triggered?

555

Write query to return all rows sql?

667

What is difference between count (*) and count 1?

568

Explain the difference between cross join and full outer join?

558

How do I find query history in sql server?

563




Which rendering formats are affected by the pagesize properties?

112

Why olap is used?

617

What is bcnf normalization form?

729

What is the full meaning of dml?

587

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

690

Write the syntax for stuff function in an sql server?

593

How to insert a new row into a table with "insert into" statements in ms sql server?

593

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

739

Which are the important points to note when multilanguage data is stored in a table?

565

What are the grouping functions?

579

For More Un-Answered { SQL Server } Questions Click Here