Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)

  • RE: Merge Replication!

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

  • RE: Merge Replication!

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

  • RE: Multiple row/value updates

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

    Luani

  • RE: Checking if An object Exists

    if exists (select 1

    from sysobjects

    where ...

  • RE: Multiple row/value updates

    try this:

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

    Luani

  • RE: Ambiguous column name

    You are welcome!:)

    Luani

  • RE: Ambiguous column name

    Correction:

    db1.table1 is db1..table1

    db1.table2 is db1..table2

    Luani

  • RE: Ambiguous column name

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

    Luani

  • RE: Ambiguous column name

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

    tablename1.myfield

    tablename2.myfield

    Luani

  • RE: Missing records when using a joined table

    Do they fill the condition :

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

    like 'fs%'

    ??

    Luani

  • RE: Select statement

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

    Luani

  • RE: lising a SUBSET of values

    You can try :

    SELECT ProductId

    FROM tblProduct

    WHERE ProductId NOt in (

    SELECT ProductId FROM TblStoreInventory

    )

    tung

    Luani

  • RE: ER Diagramming Tool

    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

  • RE: Variable where clause

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

  • RE: select columns

    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

Viewing 15 posts - 1 through 15 (of 16 total)