i am passing two parametres start date and end date

it will creating temporay table and generating result one

DBCC (Database consistency checker) are used to check the consistency of the databases. The DBCC commands are most useful for performance and trouble shooting exercises.

I have listed down and explained...

The showing answer is wrong .

SQL Server execution plans have the following main components:

*

Query Plan

...

no we can't restore 2008 backup in 2005 backup

this type of message comes

TITLE: Microsoft SQL Server Management Studio

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

ADDITIONAL INFORMATION:

The media...

what do they mean?

* The *.BCP files contain the data from the Address table. In SQL 2000 there would only be one file created, the rules...

There are two options for configuration when you place the secondary database in standby mode:

You can choose to have database users disconnected when transaction log backups are being restored. If...

Good qUESTIONS..

I SAW THIS TYPE QUESTIONS VERY RARE

Nice Question ...!

Happy Valentine's Day.......

select Min(ID) AS ID, min(startdate) as starttime, MAX(enddate) as enddime from @TBL

Thanks Good Scripts for the BACKUP LOCATIONS

Sasidhar Pulivarthi (4/1/2010)

--------------------------------------------------------------------------------

hi Vaibhav,

U are right...

I tried the following two Queries

SELECT COUNT(*) tbl_object

tbl_object

1

SELECT COUNT(*) dbo.tbl_object

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '.'.

SELECT COUNT(0) A2z

A2z

1

So the query will...

DBCC TIMEWARP has 137 parameter ........Is This Correct

In Point of Interview Very Intelligence Question ......Nice...hmmmmm My Answer is Correct............!

Trigger to update multiple tables

This is an update from a prior post. I thought this would be a simple

trigger script but it turned out to be more difficult than...

Can u use dbcc commands