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 4424

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

3 6034

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

1 3918




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

TCS,

12 15293

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 4924

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

2 5726

how to know Who Is Blocking Your SQL Server?

4 8885

How to Get the last identity value used

4 5389




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

1 3665

How to Run a Query on a Remote SQL Server?

2 6191

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

1 3013

What's the purpose of Stored Procedure?

Wipro,

6 12019

What is normalization?

9 6838

What is a Stored Procedure?

8 6581

Can you give an example of Stored Procedure?

4 6993


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

947


how can u get last observation in an unknown dataset ?

1192


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1316


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

892


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

698






1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

908


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

906


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

907


how to take backup bcp out for a column in table in sql server?

885


How do you Implement SSIS Packages in your Project?

869


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

974


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

392


What is the difference between NOROW and LOCKROW?

1340


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4826


Does any body please help me what question's have asked for SSRS in the interview?

935