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 4342

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

3 5978

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

1 3864




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

TCS,

12 14922

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 4876

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

2 5669

how to know Who Is Blocking Your SQL Server?

4 8774

How to Get the last identity value used

4 5311




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

1 3593

How to Run a Query on a Remote SQL Server?

2 6124

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

1 2965

What's the purpose of Stored Procedure?

Wipro,

6 11846

What is normalization?

9 6736

What is a Stored Procedure?

8 6465

Can you give an example of Stored Procedure?

4 6911


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

sql database suspect We have a sql database that is showing as suspect. How can we recover?

710


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?)

712


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

665


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1501


Which is the best place or learning center for MS SQL?????In Bangladesh?????

879






SQL Server Architecture ?

1133


Issues related in upgrading SQL Server 2000 to 2005 / 2008

767


what is difference between view and Dip.

1206


application server is slow what may be the problem

1084


What are the dis_advantages of stored procedures, triggers, indexes?

969


What is the difference between online clustering and Offline clustering?

1227


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.

1618


whats new about truncate in sql server 2008?

1310


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1578


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

5018