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 4265

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

3 5890

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

1 3800




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

TCS,

12 14379

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 4790

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

2 5586

how to know Who Is Blocking Your SQL Server?

4 8606

How to Get the last identity value used

4 5206




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

1 3516

How to Run a Query on a Remote SQL Server?

2 6020

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

1 2888

What's the purpose of Stored Procedure?

Wipro,

6 11598

What is normalization?

9 6573

What is a Stored Procedure?

8 6273

Can you give an example of Stored Procedure?

4 6811


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what are the critical issues you have resloved in your company

770


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

658


What is RMS migrations?

902


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1526


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

669






last function used in MS Access to convert sql what function will use in sql

808


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

771


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?

908


your distribution database is full what will u do

907


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

867


SQL Server Architecture ?

1081


How can we call UDF(User Define Function) using C# code in ASP.net ?

4581


how can u get last observation in an unknown dataset ?

1083


what is the Ticketing tool used in Wipro technologies at Bangalore...???

4791


What is the difference between NOROW and LOCKROW?

1203