Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

use Of TSql in Xml and Run In Sql server Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 3:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 2, 2014 11:05 PM
Points: 18, Visits: 33
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



Post #1567450
Posted Monday, May 5, 2014 9:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 2, 2014 11:05 PM
Points: 18, Visits: 33
No one can help me
Post #1567569
Posted Monday, May 5, 2014 9:35 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 10:09 AM
Points: 141, Visits: 313
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.
Post #1567570
Posted Monday, May 5, 2014 11:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 2, 2014 11:05 PM
Points: 18, Visits: 33
No other way?
Post #1567630
Posted Monday, May 5, 2014 12:10 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:34 PM
Points: 7,040, Visits: 12,966
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
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1567662
Posted Monday, May 5, 2014 2:20 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:46 AM
Points: 1,310, Visits: 3,755
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!
Post #1567704
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse