I am developing sw for that i need to upload xml data to MS Sql server, i dont know to do dat will u help me?
455510
If you have Enterprise Manager, you can use All Tasks --> Import & Export data, identifying the XML document as the source; or, you can use Data Transformation Services (DTS) in Enterprise Manager to convert your XML documents and put them into SQL tables.\n\nAll commericial distros of SQL Server come with Enterprise Manager.
14293
SQL Server 2005 is a comprehensive database platform providing enterprise-class data management with integrated business intelligence (BI) tools. The SQL Server 2005 database engine provides more secure, reliable storage for both relational and structured data, enabling you to build and manage highly available, performant data applications for use in your business.\n\nThe SQL Server 2005 data engine lies at the core of this enterprise data management solution. Additionally, SQL Server 2005 combines the best in analysis, reporting, integration, and notification. This enables your business to build and deploy cost-effective BI solutions that help your team drive data into every corner of the business through scorecards, dashboards, Web services, and mobile devices.\n\nClose integration with Microsoft Visual Studio, the Microsoft Office System, and a suite of new development tools, including the Business Intelligence Development Studio, sets SQL Server 2005 apart. Whether you are a developer, database administrator, information worker, or decision maker, SQL Server 2005 provides innovative solutions that help you gain more value from your data.
386389
Flash doesn't have direct connectivity with databases; you have to push everything out into XML in order to work with it in ActionScript.\n\nMaybe a future incantation of Flash will have actual ODBC connectivity or the like. For now, it doesn't.
913657
Microsoft had the brilliant idea of not including DTS (the import/export wizard) with the express edition of SQL server. It is available under a new name called SSIS (SQL Server Integration Services) under the enterprise edition.\n\nHowever, I did a bit of digging around and came across an article that will allow you to setup the DTS of SQL Server 2000 with the Express edition of 2005 and use it to import and export like before.\n\nIf you do not want to do this, you might be out of luck. Now if you have the enterprise edition or any other edition other than express, you should have the SSIS tools needed to import straight from the MS Access file.\n\nThe link below shows you how to setup the old SQL 2000 DTS wizard to work with express 2005.\n\nEnjoy!
937744
If what you are asking is what you can use to store and manage data (don't know about the 'buy' part) I can take a stab at it. \n\nI am a software engineer that has been writing database applications for 13 years. What I have used are:\nMicrosoft Access (http://office.microsoft.com/en-us/access/default.aspx)\nMySQL (an Open Source, free database) (http://www.mysql.com/)\nMicrosoft SQL Server (http://www.microsoft.com/sql/default.mspx) and \nOracle (http://www.oracle.com/index.html).  \n\nThese are pretty much the viable solutions depending on the application. MS Access is more of a poor-mans solution but certainly capable of handling 100's of thousands of rows of data, MySQL is a bit more complex but has evolved and even has a User Interface to manage the database now and fairly capable in terms of it's data capacity. SQL Server/Oracle are the full-blown Database Management Systems (DBMS) that cost the big bucks to license but are what large enterprises/web sites use to hold all their data.\n\nHope this helps.
1115367
You can download SQL Server Express from Microsoft. It is a very good database server and works very well with the other .Net Express programs. There is a great wealth of information available on how to use it. Best of all, it is completely free to download, use and distribute.
561445
Hi Sam,\n\nIf you're new to programming - but want a really robust solution - you should really check out Servoy. With Servoy you can deploy via client/server AND/OR the web at the same time from the same code base.\n\nThe programming language can be either JavaScript or inline Java - and there is a object model tree and you can double-click to create code. Also, there are "samples" for each of the available functions that will all work with a single click - so you can learn as you go.\n\nIt has point-and-click form control, and you can create relations between different tables (and even between different SQL database engines) with a few clicks - WITHOUT having to know any SQL programming.\n\nYou can have people log in without them having to install anything, and if, down the road, you want to offer offline capabilities - that's available as well.\n\nI would stay away from desktop database products like FileMaker, Access, etc. because they use proprietary databases, don't scale, are a NIGHTMARE to update on the client side, and are difficult to maintain.\n\nJust my $0.02 worth - I hope this helps.
312118
Yes you can. ASP.NET has a lot of library, and one of them is the API to deal with creation/manipulation.\nThis link might help you: http://www.w3schools.com/aspnet/aspnet_xml.asp
1054783
Dude... whoever said "use the connection wizard" just isn't creative at all...\n---------------------------------------------------------\n\nHere is code that helps you get started:\n\npublic DataTable listExistingForAdmin()\n{\n//a temporary table for storing the data into a dataset\nstring temptable = "yourTableNameHere";\n\n//prepare the SQL statement...\nstring sql = "EXEC df_groups_listExistingForAdmin"; //your SQL code here\n\n//open the connection - use your connection string!!!\nthis.con = new SqlConnection("packet size=4096;user id=dbuser;password=dbuser;data source=YourDbServerName;persist security info=False;initial catalog=yourDbName");\nthis.con.Open();\n\n//instantiate the command\nthis.com = new SqlCommand(sql, this.con);\nthis.com.CommandText = sql;\n\n//instantiate the data adapter\nSqlDataAdapter adapt = new SqlDataAdapter();\nadapt.SelectCommand = this.com;\n\n//instantiate the DataSet\nDataSet ds = new DataSet();\n\n//complete the transaction\nadapt.Fill(ds, temptable);\nDataTable dt = ds.Tables[temptable];\n\n//clean house\nadapt.Dispose();\nthis.com.Dispose();\nthis.con.Close();\n\nreturn dt;\n}//end ()\n\nHope this helps!!
1007079
perhaps see what export formats the SAP application you're working with can handle?? maybe try importing the .xml file into say...Excel?? Save as an .xls file, then import the .xls file into the table?? just a guess...\n\nor just try this site:\nhttp://www.sswug.org/searchresults.asp?keywordstofind=xml%20files
1035740
If your trying to learn how to set up and administrate databases the best reference I have found is link below:\nhttp://www.microsoft.com/technet/prodtechnol/sql/2000/books/pkadmindefault.mspx\n\nIf your trying to learn how to connect VB to MS SQL Server datasets then you should refer to the MSDN site for examples.  This site has reference links to VB and MS SQL\nhttp://www.microsoft.com/msdn\n\nGood luck
871548
see if your are new in this field it could be bit difficult for you, you need to learn some theory to get into this programming game, any i can give some tips so that you could do this particular task.\n\nThere can two ways to have form data, one is using email other is using database.both of them required a dynamic scripting service available on your server.\n\nto get the information using email, first you need to know which emailing component is available at your server. e.g. if it IIS(Microsoft) webserver then probably you can find CDONT in it.\nyou can use this component to get the user submitted information in your email.\n\nother way is to store your information in database, now you need to find out which database server is installed in your server, you need to create a new database in you database server, as per your requirement, then you need to write some script to store  data in form submission, and also to read data for later use.\n\nfor your serer information your consult with service provider, and for coding the emailing/database storing thing you can search the yahoo/google, you can find many free scripts, you need to modify them as per your requirement.\n\nhope this will solve your problem\n\ncheers\nrizwan yahya
294743
These sites are great learning resources.\n\n\nhttp://www.softwaretrainingtutorials.com/ms-transact-sql.php
768463
You get database libraries for the 'C' language. For eg. SQL server has such a library, you can find some examples also. You can use standard API like ODBC, JDBC also.
271292
Yes.\n\nhttp://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx
766832
go to this page and it has detailed instructions.\nI will warn you ahead of time...  you may have to run the sqlinstaller piece twice to get it to work.\n\nhttp://itdomino.act.com/act.nsf/docid/19408
174573
If you have a locally running db such as Oracle start it up before opening a new project in VB.\n\nOnce the bd service is running VB has a wizrd to help you locate the db server.  \n\nYou'll need to specify to Oracle and also VB that you want to use ODBC connectivity.\n\nYou'll also need to define how your db information is organized.\n\nFor your needs MS Access might be much easier.\n\nIn any case PHP with MySQL is deifinitely easier.\n\nHope this helps, please vote for me!\n\nJIm