Great UNION plays a big part....

Simple

hmmm tough one...

you are digging well in Wikipedia...

After enabling files stream . Now i get following message which doesn't make sense to me at all...

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

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

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

Unable to open...

I am using Attach Database wizard. but cab be scripted to as follows.

USE [master]

GO

CREATE DATABASE [AdventureWorks2008] ON

( FILENAME = N'C:\AdventureWorks2008\AdventureWorks2008_Data.mdf' ),

( FILENAME = N'C:\AdventureWorks2008\AdventureWorks2008_Log.ldf' )

FOR ATTACH

GO

Freebies ...

Hi Lowell,

EXEC('ALTER TABLE MyTable ADD MyValue1 Int NULL; UPDATE MyTable SET MyValue1 = 0; ')

Update statement doesn't recognize the newly added column and returns the error as "Invalid column name"

Pls...

Excellent explanation from Paul, Thanks to both of you Ron & Paul.

I wonder can i add this link to paul's article in to Briefcase?

This will give you result you want

use HIS

SELECT

room_type,

case when rate_start_date < '2011-04-14'

then '2011-04-14'

...

To get column Name simply use As clause

case when rate_start_date < '2011-04-14'

then '2011-04-14'

else rate_start_date

...

First in the provided link you have got column name as RATE_END_RATE DATETIME instead of RATE_END_DATE DATETIME

Regarding your solution you need to use case statement in your select clause when...

Couldn't agree more

Knew about database mirroring.

Didn't know that log recovery works with both modes. thanks.

Surprised...