I found :

Schema Changes on Publication Databases

Schema changes can be replicated during snapshot replication, transactional replication, and merge replication. Column additions and deletions are implemented at the table level and...

I thought to change to 0 (it is 128 for replicated tables) the field relpinfo in sysobject of desired table alter the column and then reset it to 128...

Update tableA Set TableA.Value2 = TableB.Value2 from tableA join TableB on TableA.Value1 = TableB.Value1

Luani

if exists (select 1

from sysobjects

where ...

try this:

Update tableA Set TableA.Value2 = TableB.Value2 join TableB on TableA.Value1 = TableB.Value1

Luani

You are welcome!:)

Luani

Correction:

db1.table1 is db1..table1

db1.table2 is db1..table2

Luani

SElect tb1.*,tb2.* from db1.table1 tb1 join db2.table2 tb2 on tb1.myfield=tb2.myfield

Luani

You must have fields with the same name on the two tables, refer them :

tablename1.myfield

tablename2.myfield

Luani

Do they fill the condition :

*******************

like 'fs%'

??

Luani

is the ID field a number?? I see u using the quotes?!

Luani

You can try :

SELECT ProductId

FROM tblProduct

WHERE ProductId NOt in (

SELECT ProductId FROM TblStoreInventory

)

tung

Luani

You can try the Sybase PowerDesigner 7.5 or 8 to do your ER diagram, and it will seperate the phisical Model from the conceptual model as wanted

tung

Luani

Have you tried:

If @Var1 <>''

Exec ('Select * from news_items where division =''' + @Var1 + ''' ')

else

Exec ('Select * from news_items')

You can create your filter and then add it to...

You can use ADO recordset to do so (if ADO is in your framework) ! I don't know any Transact-SQL function having this scope!

Luani