Sign Up Login


  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 6026

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

 3 8085

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

 1 5178

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

TCS,

12 23561

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 6161

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

 2 7846

how to know Who Is Blocking Your SQL Server?

 4 11695

How to Get the last identity value used

 4 8088

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

1 4966

How to Run a Query on a Remote SQL Server?

 2 7817

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

 1 4430

What's the purpose of Stored Procedure?

Wipro,

6 17046

What is normalization?

 9 11329

What is a Stored Procedure?

 8 10977

Can you give an example of Stored Procedure?

Wipro,

4 10371

Un-Answered Questions { SQL Server }

Tell me can we use custom code in ssrs?

768

What is a data collection table?

747

How to list all objects in a given schema?

759

What is the difference between createstatement and preparedstatement?

707

Is the primary key column of a table an index in ms sql server?

719

What is snapshot replication?

796

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

783

What is user-defined multi-statement table-valued function?

846

Why use cursor in sql server?

761

Explain about integration services of Microsoft SQL server?

799

What is auditing in sql server?

701

What is the use of toad or sqldbx.?

900

Explain use of expression builder.

760

How do I find sql server instance name?

714

What are the requirements for sql server 2016?

704

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