mtassin, you forgot to take care about NULLs.

Also, your script gonna miss the case when user decides to add a space to a string.

No, you're absolutely right.

Programming skills of most of developers nowadays...

Why can't you use ntext?

Jeff Moden (3/31/2008)

---

Sure could... now, pretend it's 5PM on a Friday and you have a really hot gig at...

Yes.

But you can exclude any doubts by doing this in one go:

SELECT @myERROR = @@ERROR,

@myRowCount = @@ROWCOUNT,

@OrderId = SCOPE_IDENTITY()

IF @myERROR != 0...

Topic "SET (described)" in BOL has the answer on your question and a lot of other useful information.

That's actually the logic you may find...

1st you need to assign the variable value correctly.

Try this:

use northwind

declare @ProductList varchar (50)

set @ProductList = ('Chai','NuNuCa Nuß-Nougat-Creme','Geitost','Wimmers gute Semmelknödel','Original Frankfurter grüne Soße')

--unchanged so far

select @ProductList

update tableb set ntextb=ntexta

from tablea

where nida = 55

and nidb = 222

And if you put the list of your columns into specially designed table:

CREATE TABLE dbo.TriggerUpdatedColumns (

TriggerName sysname,

ColNo smallint

)

You can use simple script :

IF EXISTS (

SELECT 1 FROM dbo.TriggerUpdatedColumns

WHERE TriggerName =...

Alex, int value returned by POWER function holds 4 bytes, 32 bits.

It's more than enough for your 14 columns.

There is no need for any SUBSTRING.

Your problem is the way you...

SQL ORACLE (3/19/2008)

---

It will be easy if your table has a column with timestamp data type. Here is an example.

DECLARE @Date DATETIME

SELECT @Date = MAX(DateUpdated) FROM myTable

IF @Date > DATEADD(d,...

I wonder how Jeff got himself responding to somebody with a nickname like YOURS.

😀

Look at his...

I would suggest relational database approach.

Something like this:

[Code]

SELECT *

FROM tblData D

WHERE EXISTS (select 1 from dbo.Calendar C

where C.Month = D.MonthID

AND C.[Quarter] = @Quarter

)

[/Code]

Create a new table table_Copy

Copy all data from table to table_Copy except image.

Drop table, rename table_Copy to table.

If you've got some FK or other constraints don't forget to drop and...