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 5669

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

 3 7573

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

 1 4869

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

TCS,

12 21801

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 5854

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

 2 7120

how to know Who Is Blocking Your SQL Server?

 4 11098

How to Get the last identity value used

 4 7438

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

1 4622

How to Run a Query on a Remote SQL Server?

 2 7411

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

 1 4118

What's the purpose of Stored Procedure?

Wipro,

6 16073

What is normalization?

 9 10057

What is a Stored Procedure?

 8 10016

Can you give an example of Stored Procedure?

Wipro,

4 9742

Un-Answered Questions { SQL Server }

What do you mean by cardinality?

483

What is default port number for sql server 2000?

586

What is an inner join?

523

What is meant by datasource?

509

What is the difference RDBMS and Graph Database?

621




Name some of the open source software that you can use in alternative to SSR?

105

What are dml (data manipulation language) statements in ms sql server?

545

What does man by sql wildcard characters in sql server?

512

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1678

what are isolation levels? : Sql server database administration

490

How column data types are determined in a view?

526

When cursors are useful?

570

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

570

Explain a join?

602

How to declare a cursor with "declare ... Cursor" in ms sql server?

560

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