Domagoj Orec (1/19/2009)

---

Ninja's_RGR'us (1/19/2009)

---

That wouldn't have been so funny if you hadn't repeated it twice in a row :D:w00t::P.

Been guilty myself of a few typos over the years... so no...

That wouldn't have been so funny if you hadn't repeated it twice in a row :D:w00t::P.

Been guilty myself of a few typos over the years... so no harm done :).

That's worth repiting Grant :w00t::D:hehe:.

RBarryYoung (1/18/2009)

---

Here's another way to go:

--Test:

Select

Replace( Replace(ColumnName, '_5X7', '5X7'), '5X7', '_5X7')

From YourTable

Where ColumnName like '5X7'

--change:

Update YourTable

Set ColumnName

= Replace( Replace(ColumnName, '_5X7', '5X7'), '5X7',...

This is completly untested, make sure you try that on a backup copy of the data.

Also your question seems incomplete so there might be so caveat to this solution.

TEST.

SELECT ColumnName,...

Jeff Moden (1/17/2009)

---

Awesome... thanks for looking it up, Barry. Her mastery of the written word is just an...

GilaMonster (1/17/2009)

---

Not a bad question, but does this guy ever read the posts that he's answering?

http://www.sqlservercentral.com/Forums/FindPost638650.aspx

Question was "I didn't start an explicit transaction, I don't have a backup, how do...

Script the db on 2005, recreate it on 2000 (make sure evertyhing still works in the sps, views, etc).

Import the data from the old server to the new one.

There's nothing...

I'd give that to Jeff... he's NOT paid to do all that, unlike Steve.

It's already the longest thread on this board, it happened a couple weeks ago I think, and at least a couple 100s of posts ago.

There's always and only 1 answer to that question... it depends.

Make your own scenarios and test them.

CROSS APPLY is only used with functions that return resultsets based on pamareters. It's been created to allow the use of those function in an inner join when the...

Select TblName from Oracle.DbName.Owner.SystemTables (assuming they exist).

Loop in that list and execute this :

Select * into LocalDb.dbo.? FROM Oracle.DbName.Owner.?

That however doesn't transfer any constraint, indexes, identity properties.

Doh!!!, I just figured it out

SET @X = '278 * (1 / 4) - 2'

1 / 4 = 0 because both numbers are Ints.

if you use 1.0 instead of 1,...

This is a hack, but it works...

DECLARE @X AS VARCHAR(100)

DECLARE @sql AS nVARCHAR(4000)

SET @X = '8*1/2-6'

SET @sql = 'SELECT ' + @X

PRINT @sql

EXEC(@SQL)

Please notice that I removed the parenthesis to...