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 7605

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 21959

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 5875

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

 2 7185

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 7433

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

 1 4137

What's the purpose of Stored Procedure?

Wipro,

6 16152

What is normalization?

 9 10170

What is a Stored Procedure?

 8 10076

Can you give an example of Stored Procedure?

Wipro,

4 9793

Un-Answered Questions { SQL Server }

Explain the concept of view and Types of views in SQL server?

623

What is the significance of master, tempdb and model databases?

533

When would you use the stored procedures or functions?

578

Explain the properties of subqueries in sql server?

548

What is faster join or union?

606




How to create a view on an existing table in ms sql server?

596

How to disconnect from a sql server using mssql_close()?

591

How to use transact-sql statements to access the database engine?

544

What is resource db in sql server?

603

What the class forname () does?

549

What is a primary key?

544

What is the maximum size of sql server database?

513

Define a cross join?

598

What are the requirements on sql server network connections?

527

List out the difference between union and union all in sql server?

525

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