Viewing 15 posts - 1 through 15 (of 16 total)
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...
July 3, 2003 at 10:20 am
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...
July 3, 2003 at 10:06 am
Update tableA Set TableA.Value2 = TableB.Value2 from tableA join TableB on TableA.Value1 = TableB.Value1
Luani
May 29, 2003 at 10:08 am
if exists (select 1
from sysobjects
where ...
May 29, 2003 at 9:59 am
try this:
Update tableA Set TableA.Value2 = TableB.Value2 join TableB on TableA.Value1 = TableB.Value1
Luani
May 29, 2003 at 9:55 am
Correction:
db1.table1 is db1..table1
db1.table2 is db1..table2
Luani
May 29, 2003 at 9:16 am
SElect tb1.*,tb2.* from db1.table1 tb1 join db2.table2 tb2 on tb1.myfield=tb2.myfield
Luani
May 29, 2003 at 9:14 am
You must have fields with the same name on the two tables, refer them :
tablename1.myfield
tablename2.myfield
Luani
May 29, 2003 at 9:04 am
Do they fill the condition :
*******************
like 'fs%'
??
Luani
May 28, 2003 at 7:25 am
is the ID field a number?? I see u using the quotes?!
Luani
May 27, 2003 at 4:05 am
You can try :
SELECT ProductId
FROM tblProduct
WHERE ProductId NOt in (
SELECT ProductId FROM TblStoreInventory
)
tung
Luani
May 23, 2003 at 7:37 am
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
May 23, 2003 at 1:25 am
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...
May 22, 2003 at 4:54 am
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
March 13, 2003 at 8:17 am
Viewing 15 posts - 1 through 15 (of 16 total)