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 4298

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

3 5922

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

1 3823




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

TCS,

12 14649

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 4824

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

2 5622

how to know Who Is Blocking Your SQL Server?

4 8684

How to Get the last identity value used

4 5246




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

1 3548

How to Run a Query on a Remote SQL Server?

2 6060

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

1 2915

What's the purpose of Stored Procedure?

Wipro,

6 11704

What is normalization?

9 6643

What is a Stored Procedure?

8 6364

Can you give an example of Stored Procedure?

4 6852


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

wat wil hapn if we give the both read and deny read permission to user?

907


what is isolation level at dead lock?

988


You are doing log shipping due to some reasons it is failing. How you will proceed from there

792


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

334


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1124






how can u get last observation in an unknown dataset ?

1106


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1479


How do use Having,Group by,Group function in SQL?

648


Call by value and call by reference in procedure and function, with NOCOPY.

122


How we create SQL Server 2005 Reporting Services ? Give me Sample

887


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1221


What is the difference between online clustering and Offline clustering?

1197


how many no of arguments can be passed in procedures and functions

3451


Why we need to use secondry database file? though, we can do same work using primary database file also.

4175


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

589