|XML to SQL tables - SQL 2005 stored procedure
||...given XML to SQL Server, using stored procedure only (no .NET or dataset). SQL server is MS SQL Server...create SQL tables (more than 3), drop the tables for each run and insert XML data into these tables
The...The tables should have relationship (parent child primary key foreign key relationship)...
||XML, .NET, Script Install, SQL, C# Programming
||Sep 12, 2009
||Sep 12, 2009Ended
|parse xml and update/insert into sql
||...program in .net that will read and parse multiple xml files and then insert/update data into the sql 2000 database...
We have about 9000 records currently in Sql server that are are incorrect and need to be "repaired"...good XML skills, good SQL server skills, good .net skills. Most of all, it will require good ...
||PHP, ASP, Visual Basic, .NET, Engineering, SQL, C# Programming, Software Architecture, Software Testing, MySQL, Anything Goes
||Jun 5, 2007
||Jun 5, 2007Ended
|SQL to XML to ZIP (.NET)
||Create a small .NET Winforms executable which does the following:
1) Connects to a SQL Server database (configurable...(configurable via a config file).
2) Executes a number of INSERT, UPDATE and DELETE statements (to be defined in...from a second TXT file where a number of SELECT FOR XML AUTO statements will be defined. Each SELECT statement
||XML, .NET, SQL, C# Programming
||Nov 26, 2012
||Nov 26, 2012Ended
|Insert records in sql server in .NET
||Insert records in sql server in .NET
||Apr 4, 2015
||Apr 4, 2015Ended
|SQL Server Import/Export with XML
||...SSIS package or .NET c# class to enable our database to be exported to a single XML file (there are about...about 50 related tables). The export must contain all related data as sub nodes.
We require this work...chunks of data (and all related data) from one server to another. The code should not have an adverse
||Nov 23, 2012
||Nov 23, 2012Ended
|XML Dcoument Import and Export to SQL Server Tables
||...simple SQL Script or program which ever is easy to? export a XML document to SQL server Tables and import...back to XML document. The XML document is a simple document containing data from mainly? 2 tables (exactly...(exactly similar to invoice and invoice details tables and relationships).
Rent A Coder
||PHP, XML, Windows Desktop, Engineering, SQL, Software Architecture, Software Testing, Website Testing, Microsoft, MySQL, XSLT, Website Management, Web Hosting
||Apr 24, 2006
||Apr 24, 2006Ended
|Insert records in sql server in .NET -- 2
||Insert records in sql server in .NET
||Apr 4, 2015
||Apr 4, 2015Ended
|.insert Update program in Sql Server using xml
it can be either C# or VB.NET
Sql Server will be the database
Needed this in next 30-40
||XML, Visual Basic, .NET, C# Programming
||Apr 11, 2014
||Apr 11, 2014Ended
|XML data to MS SQL tables
||...capture data from several XML files to associated tables in MS SQL server (2005+).
VB.NET 2008 or 2010...
You will receive sample XML and associated XSD documents as well as MS SQL table layouts. However, you...additional tables from the XML schema as deemed necessary.
For this project, there will be 5 XML files
||ASP, Visual Basic, .NET, Windows Desktop, Software Architecture, Microsoft
||Oct 4, 2012
||Oct 4, 2012Ended
|Insert XML into tables
||We need to load data from XML into tables. XML has the structure (example, see attached file). There...employees). We need to load it into three different tables.
||Feb 1, 2013
||Feb 1, 2013Ended
|SQL to duplicate tables and insert a few rows
||I need a SQL script that I can run to setup a testing environment. I have two schemas: "prod" and "dev"
I need to have 10 tables from "prod" created in "dev". Just the table definitions, indexes,...data.
I then need a separate script that will insert the n most recent rows from each table in "prod"
||Nov 11, 2010
||Nov 11, 2010Ended
|SQL server/.NET issue
||This is the .NET code for a SQL Command:
CultureInfo ciEnglish = new CultureInfo("en-US", false);...ShowDate).ToString(ciEnglish);
This is the SQL parameter:
The ShowDate...2012-03-18 19:35
all by itself upon data insert?
Can you fix it permanently, quickly and
||ASP, C Programming, XML, .NET, Script Install, Windows Desktop, SQL, C# Programming, Shell Script, Microsoft, MySQL, XSLT, Google Chrome, Apple Safari
||Oct 16, 2012
||Oct 16, 2012Ended
|VB, SQL, .Net Help
||...and was published to an IIS server to run as aspx.
The site uses a SQL back-end for the database and...stores information in XML as well. I will need help to sort drop down menu's from the SQL queries, change some...some gui on the screens (tables), repopulate form fields based on changed items in drop-down menus, etc
||XML, Visual Basic, .NET, SQL, IIS
||Apr 11, 2012
||Apr 11, 2012Ended
|Import XML file to Sql Server 2000
||Import XML file to SQL Server 2000 (FrontEnd: VB.Net)
Read an XML file into a typed dataset, validate...in the database, then insert into proper database tables. The database tables are different then the...structure of the xml file.
Attached is an example of an XML file to be used.
1) Read XML file into a typed
||PHP, XML, Visual Basic, .NET, Engineering, Software Architecture, Software Testing, MySQL, XSLT
||Feb 9, 2007
||Feb 9, 2007Ended
|Specs for XML to SQL and back
||...that moves document-centric XML into a relational database, maintains the XML in that database and allows...allows the extraction of the original XML from that database. The 'how to' is outlined in a readable patent...The application is to be created in Visual Studio .Net (C#). We want to sell the resulting software commercially
||PHP, XML, Translation, Windows Desktop, Engineering, SQL, C# Programming, Software Architecture, Software Testing, Academic Writing, Article Rewriting, Microsoft, MySQL, XSLT, Google Chrome, Apple Safari, Database Administration
||Jul 1, 2002
||Jul 1, 2002Ended
|SQL Optimization/Reorganization of tables
||...to explain the problem is to do a little create/insert/pseudo code. If you understand what I'm doing here...varchar(20),info2 varchar(20),badcolumn varchar(390));
Insert into table1 values('data1','data2','ABCDEFGHIJKLMNO...that's slow. The other problem I have is that the SQL server is remote and on a VERY slow connection so the
||Dec 1, 2009
||Dec 1, 2009Ended
|Converting XML files to MS SQL tables
||...a 89 XML files and DTD's (see attached zip). These files need to be imported into a MS SQL Server 2000...1) A backup of a Microsoft SQL Server 2000 Database containing the tables as described above.
Microsoft SQL Server 2000 SP3
||PHP, XML, Windows Desktop, Engineering, SQL, Software Architecture, Software Testing, Microsoft, MySQL, XSLT
||Oct 10, 2005
||Oct 10, 2005Ended
|A configurable background service application to run on SQL Server (on Windows)
||...configurable background service application to run on a SQL Server (on Windows)
What I need is,
- This background...watch certain tables in certain databases and when one of these tables are changed (by insert, update or...or delete),
- It will create a xml string which holds the data from only rows that are inserted/updated/deleted
||.NET, Windows Desktop, SQL, Windows Server
||Mar 11, 2013
||Mar 11, 2013Ended
|Import XML to SQL database
||...a ZIP file for each listing. The ZIP contains an XML file with all the listing data, and all of the images...ZIP file and insert it into the mySQL database 2.Copy ALL images from the ZIP to the server in a directory...specified. Filenames must remain unchanged. 3. The XML file contains a LISTING ID. This ID MUST be used
||PHP, XML, Software Architecture, Software Testing, Website Testing, MySQL, XSLT, Website Management, Web Hosting
||Oct 8, 2009
||Oct 8, 2009Ended
|.NET Developer needed to create the database in SQL Server for 4-5 tables
||.NET Developer needed to create the database in SQL Server for 4-5 tables
||.NET, Microsoft SQL Server
||Jan 24, 2015
||Jan 24, 2015Ended