:w00t: Thank You So Much Master :w00t:

Always be healthy " Sean Lange "

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 sch.schema_id...

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'''' then...

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 sc.name...

The Name tables should be placed as one

EXEC sp_rename N'TableName1.Phone', N'Telephone', N'COLUMN';

EXEC sp_rename N'TableName2.Phone', N'Telephone', N'COLUMN';

There are many Tables and Views

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 should...

After finding the table name command to rename writing

HanShi (9/5/2013)

---

You need to change the HAVING clause to get your desired results. With the code below you can check if both 'Walker' and 'Cane' exists at least once.

HAVING sum(case...

excuseme

Contact information table was forgotten

Plz Download New Database Attachment

SELECT FirstName, LastName, CompanyID, NCode, FatherName, nPercent, NationalCode

FROM View_Report

WHERE ...

Attach Sample Database (SQl 2008)

My Query is :

SELECT NationalCode, CompanyID, nPercent, NCode, FirstName, LastName, FatherName

FROM View_Report

WHERE...

First Table Personal Information Included Feilds :

NationalCode(Key), FirstName, LastName, CompanyID, NCode, FatherName, nPercent,

Second Table Tools Information Included Feilds :

ID_Tools(key),NationalCode ,TypeTools,NameTools,PriceTools

Third View(View_Report) Included Feilds :

NationalCode,FirstName, LastName, CompanyID,...

Mrci

You are quite right in my Answer

But I have a view and send it to the different conditions By Collection (Asp.net)

I added the condition to Having, but will...

My code is correct

I Tested

USE TestDb;

DECLARE @Table NVARCHAR(MAX),

@Col NVARCHAR(MAX)

DECLARE Table_Cursor CURSOR

FOR

SELECT a.name,b.name

FROM sysobjects a,syscolumns b

WHERE a.id = b.id

AND a.xtype = 'u'

AND...

Ok very Good

I quickly did...

Plz Download Attach Test Databace

And Run Your Query