Stefan Krzywicki (8/7/2013)

---

paul.knibbs (8/7/2013)

---

If it's...

And even worse...what are going to do when the column is not wide enough to hold the current value plus this new string?

Are you trying to add that...

like this?

update table1 set Name1 = '!@#$%^&*()' + Name1

ChrisM@Work (8/7/2013)

---

1970's toilet graffiti: on the left-hand side of the cubicle is written "see other...

That isn't an error. It is a warning message. AFAIK there is no way to prevent SQL from returning that message when calling sp_rename. Can't you just prevent that in...

You might also click on the Stairways over on the left side. There are a number of series that start out basic and get more advanced as they go.

Also, make...

Since instr is a pretty common character index location function I will assume that this is from a programming language.

You could turn this into sql like this:

SELECT CASE

WHEN act_type.act_type_sc IN...

Check out the links in Chris's signature about Apply. Those 2 articles...

Since you are doing a catch-all type query you should read up about the performance of these types of queries. Gail's article does a great job explaining the performance issues...

Please don't cross post. It just fragments the replies.

Here is the other one. http://www.sqlservercentral.com/Forums/Topic1481654-392-1.aspx

Please don't cross post. It just fragments the replies.

Here is the other one. http://www.sqlservercentral.com/Forums/Topic1481652-392-1.aspx

bawinkley (8/6/2013)

---

I am having trouble working out exactly what you are asking but see below it may help you?

UPDATE

--table to update

Values1

SET

--column you want the value...

mister.magoo (8/6/2013)

---

Sean Lange (8/6/2013)

---

Lowell (8/6/2013)

---

no, you should say "Because @@rowcount is affected by any commands in the session, it's my practice to re-select from the table in case there was...

SQLCereal (8/6/2013)

---

Thank you for the reply Sean. I will make sure to post the ddl and sample data in the future.

The example you've provided is interesting. I've never thought...