Post reply

use Of TSql in Xml and Run In Sql server

  • May 5, 2014 at 3:38 am

    #288386

    Hi

    I can not speak English well

    i have a table(f1 int) and file xml

    and save of xml in sql

    problem:

    i want use of a order tsql(example:select max(id)+1 from t1) in xml

    and result save in table

    ---Sorry if I explained badly

  • May 5, 2014 at 9:35 am

    #1710755

    No one can help me

  • May 5, 2014 at 9:35 am

    #1710756

    If you are looking to increment the number automatically whenever you insert a new record, try Identity(1,1) on that column, so that it gets automatically incremented.

    Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.

  • May 5, 2014 at 11:04 am

    #1710806

    No other way?

  • May 5, 2014 at 12:10 pm

    #1710831

    Can you provide an example (rows in a table and hoe those should look in the XML you're looking for)?

    Might help to "knock down" the language barrier.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • May 5, 2014 at 2:20 pm

    #1710869

    kiasystemsoft (5/5/2014)

    Hi

    I can not speak English well

    Around here you only need to speak some SQL, post some example data and we will help you!

    😎

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply