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


SQL Server Interview Questions
Questions Answers Views Company eMail

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

Aviva,

1 2869

how to generate XML out of QUERY?

McAfee,

1 4428

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

Infosys, McAfee,

5 9073

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

Intelenet,

8 30282

hi i gone though satyam interview. what is Acid Properties?

Satyam,

2 4940

what are batch in sql server?

Satyam,

2 8929

Difference Between varchar and nvarchar datatype?

Satyam,

3 12958

Difference between sql server 2000 and sql server 2005?

Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

11 49924

what is normalization? what is denormalization?

Satyam,

9 32174

what is extended StoreProcedure ?

Satyam,

3 5534

Different Types of Functions ?

Satyam,

2 11792

CLR Integration ? what is Notification services ?

HCL, Satyam,

1 4406

what is replication? where do u use Go Keyword?

Satyam,

1 4207

how do u do Performance tunning ?

Infodat Technologies, Satyam,

1 4481

How to find the date and time of last updated table?

 3 8014

Un-Answered Questions { SQL Server }

What do you need to connect php to sql server?

526

You want to implement the one-to-many relationship while designing tables. How would you do it?

493

How do you delete duplicate records in sql server?

494

How do you start single user mode in clustered installations?

507

What is exporting and importing utility?

597




What do you mean by a dependent functionality in a build?

647

What are database states in ms sql server?

640

Can you pass expressions to stored procedure parameters?

492

What is cursors?

630

How to modify an existing stored procedure in ms sql server?

516

What happens if the update subquery returns multiple rows in ms sql server?

576

Explain error and transaction handling in sql server?

490

What are the restrictions that views have to follow?

543

Determine how to use the inserted and deleted pseudo tables?

518

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

537

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