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


SQL Server Interview Questions
Questions Answers Views Company eMail

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

 1 5697

How do I compare two values when one value(data type) is char and the other is an integer?

 3 7602

What are the pros and cons of creating extended stored procedures?

 1 4888

Is it possible to delete duplicate rows in a table without using a temporary table ?

TCS,

12 21957

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 5871

How to Check Whether a Global Temporary Exists in a SQL Database or not?

 2 7179

how to know Who Is Blocking Your SQL Server?

 4 11124

How to Get the last identity value used

 4 7484

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 4642

How to Run a Query on a Remote SQL Server?

 2 7431

How to Generate a Series of Random Integers With T-SQL?

 1 4134

What's the purpose of Stored Procedure?

Wipro,

6 16144

What is normalization?

 9 10168

What is a Stored Procedure?

 8 10059

Can you give an example of Stored Procedure?

Wipro,

4 9789

Un-Answered Questions { SQL Server }

How to return the top 5 rows from a select query in ms sql server?

598

What is rank function?

606

What is explicit mode in sql server?

538

How to create a scrollable cursor with the scroll option?

502

What do you understand by a view?

559




Why do we use functions?

516

What is sub-query in sql server? Explain its properties.

584

What is transaction server isolation?

580

how will add additional conditions in sql?

576

How to change the name of a database user?

552

What is a periodical index?

510

Explain different types of locks in sql server.

602

What is the maximum size of a dimension? : sql server analysis services, ssas

566

What is the tcp/ip port on which sql server runs?

570

What is proper subset of candidate key?

562

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