babak3334000 (10/7/2013)

---

Sean Lange (10/7/2013)

---

babak3334000 (10/7/2013)

---

select 'EXEC sp_rename N''' + sch.name + '.' + so.name + '.Phone'', N''TelePhone'', N''COLUMN'';',

*

from sys.objects so

join sys.columns sc on so.object_id = sc.object_id

join sys.schemas sch on...

karunakar2351 (10/7/2013)

---

CREATE PROCURE w AS

ALTER TABLE t ADD x char(1)

UPDATE t set x =1

Even when it lets me create that stored procedure (if I create it when x exists), when...

babak3334000 (10/7/2013)

---

This is done with the command ??

execsp_msforeachtable N'

IF EXISTS(SELECT 1 FROM sys.columns WHERE object_id=OBJECT_ID(''?'') AND name = ''Col1'')

EXEC (''UPDATE ? SET Col1= case when Col1 = ''''ppp''''...

babak3334000 (10/7/2013)

---

select 'EXEC sp_rename N''' + sch.name + '.' + so.name + '.Phone'', N''TelePhone'', N''COLUMN'';',

*

from sys.objects so

join sys.columns sc on so.object_id = sc.object_id

join sys.schemas sch on sch.schema_id = so.schema_id

where...

NineIron (10/7/2013)

---

Could someone desipher this query that was handed to me? Primarily, how are they joining OeOrders with DOeCategories? I can't understand how you can join tables this way.

Shouldn't there...

That looks to my like it...

babak3334000 (10/7/2013)

---

I mean that this command can not be used (Sp-rename)

It does not matter to me what can be done with the command

Just change the column name in all tables...

I think you mean how do you rename the column once you find it?

You mentioned the proc in your first post...

Quite simple. If you want your results in a given order, you need to add an ORDER BY to your query.

You really need to quote the original post in your responses so we have a clue what you are...

Which query?

I think you could use this for the same. It is a bit simpler but should accomplish the same thing.

DELETE TableA

FROM TableA a

WHERE a.ConsumerID IN

(

SELECT ConsumerID

FROM TableB

group by...

RamSteve (10/7/2013)

---

Hi i do not want to delete consumerID 100 as deleteflag is 0 for one product

and moreover this is not a home work , but i am trying...

You...

DaveDB (10/7/2013)

---

People are complaining that they want to see the number as 15.385. I am in the process of setting up a report server so that will be later. I...