If I want to do bulk insert using open xml , how would I achieve this using stored procedure.
for example,
<students>
<student> <firstname>Amir</firstname><age>23</age><address>666 park ave</address></student>
</students>
I want to pass the above xml to a stored procedure as a string or varchar and then use the SQL Open XML to insert into a temp table having three columns Firstname,age, Address
I'm trying to update an SQL DB from data in Quickbooks. I am trying to find if I can open a dsn connection in a stored procedure, called from an ASP page, to the quickbooks db using odbc. The driver I have for odbc does not allow for linked servers. I'm very new to stored procedures and such so please bear with me. Thxs.
View 3 Replies View RelatedReader Community
I've just started hosting my newly created Microsoft Visual Web Developer 2005 Express Edition web site. Unfortunately the Login group membership functions will not function correctly. Having contacted the web service hosting provider, They replied: "We do not support SQL express2005. The only way to use the extra functions of ASP.NET2 such as group membership is if it is using an SQL 2000 database to connect to. "
Is it possible to design web sites with Microsoft Visual Web Developer 2005 Express Edition that store membership details on an SQL 2000 database?
I've just paid £88 approx. $140 for a years subscription, have I chosen the wrong web service hosting provider?
Should I have designed the web site with a better web site design software tool that also makes designing membership login functionality easy, just as Microsoft Visual Web developer 2005 express edition?
Look forward to all comments?
Regards
Philip
Can anyone please give me the equivalent tsql for sql server 2000 for the following two queries which works fine in sql server 2005
1
-- Full Table Structure
select t.object_id, t.name as 'tablename', c.name as 'columnname', y.name as 'typename', case y.namewhen 'varchar' then convert(varchar, c.max_length)when 'decimal' then convert(varchar, c.precision) + ', ' + convert(varchar, c.scale)else ''end attrib,y.*from sys.tables t, sys.columns c, sys.types ywhere t.object_id = c.object_idand t.name not in ('sysdiagrams')and c.system_type_id = y.system_type_idand c.system_type_id = y.user_type_idorder by t.name, c.column_id
2
-- PK and Index
select t.name as 'tablename', i.name as 'indexname', c.name as 'columnname' , i.is_unique, i.is_primary_key, ic.is_descending_keyfrom sys.indexes i, sys.tables t, sys.index_columns ic, sys.columns cwhere t.object_id = i.object_idand t.object_id = ic.object_idand t.object_id = c.object_idand i.index_id = ic.index_idand c.column_id = ic.column_idand t.name not in ('sysdiagrams')order by t.name, i.index_id, ic.index_column_id
This sql is extracting some sort of the information about the structure of the sql server database[2005]
I need a sql whihc will return the same result for sql server 2000
I get the below error only when my IDE open. It connects well when it is found closed.
[SqlException (0x80131904): Cannot open user default database. Login failed.Login failed for user 'JPASPNET'.]
I could solve this by giving the logged in windows user to impersonate under IIS window > WEBSITE > ASP.NET tab > EDIT CONFIG > APPLICATION tab
But I wish someone could give me the proper solution.
I almost tried all from giving ASPNET user as a administrator to configuring the same in Express management tool.
Environment: XP pro, VWD and SQL Express
Hi there,
I got an approach like that:
1) Read something from DB - check the value, if true stop if false go on2) Read the second Value (another SQL Statement) - check the value etc.
Now I could open the connection at 1) and if I have to go to 2) I leave the connection open and use the same connection at 2). Is it ok to do that?
The other scenario would be opening a connection at 1), immediately close it after I read the value and open a new connection at 2).
Thanks for the input!
Post installation of SQL Server 2014 Express edition, I am able to connect to the Database Instance.
But while opening a new query window in SSMS or opening a table getting the error:
Package 'RadLangSvc.Package, RadLangSvc, Version 12.0.0.0, Culture=Neutral, Public Token=89845dcd8080cc91' failed to load
Object reference not set to an instance of an object. (mscorlib)..Have already tried installing the componentsDACProjectSystemSetup_enu.msi, TSql LanguageService_enu.msi, DACFramework_enu.msi from path VS 2010 WCU DAC.
Hi,
I am using SSRS Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00. I want to open linked report in new window.
I tried whats mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=240172&SiteID=1 but i get an error on Window.Open method.
How do I solve the problem?
Thanks
Just a quick question about connection management. My application willnever need more than 1 or 2 connections about at any given time. Also, I donot expect many users to be connected at any given time. For efficiency, Iwould like to keep connections alive throughout the lifetime of the objectsrequiring them, rather than opening a new connection, executing code andthen closing it again. What is the most efficient way of doing this?Should I perform the open/close or just one open when I create the objectand a close when I dispose of it?
View 1 Replies View RelatedMS states that CE does not work with ASP.Net applications 'by default'. What is needed to change this default?
Bascially, my desktop app. is configured from a browser app. (ASP.Net 2.0) and I want to use CE as the datastore for the application.
Thanks.
My documentation tells me that SQL Server Express only supports 1 gigabyte of RAM.
My computer can take 2 gigs, but I presently only have half a gig.
If I install 2 gigs on my machine, will that cause SQL Server Express to malfunction?
Or does it just mean that the extra gig will not be utilized?
Any advice would be much appreciated.
Dear friends
I am a new developer. I need some SQL Language examples to write some quaries.
Ex.
how you collect last record that relevent for the last record updated for a relevent employee in a record table which includes RecordNo and EmployeeNo, salses
Thanks
Any help is greatly apprciated
Amila
I have configured SQL XML Support in IIS but still i am not able to Use
http://localhost/ss?Sql=select+*+from+users+for+xml+auto
I am getting Internal Server Error
I understand the SANs are only Supported by SQL Server 2000 Enterprise and no other versions of SQL, can anyone supply information to the contrary please?
View 2 Replies View RelatedHas anybody heard or know anything about discontinued support for SQL Server 6.5?
I heard something about maybe 6 months after the release of SS 7.5.
Thanks in advance.
Do SQL 7 support row lock?
View 1 Replies View RelatedDoes anyone know when Microsoft is due to end support for 6.5?
View 1 Replies View RelatedHi everyone,
I have several SQL Server 6.5 machines. I would like to see what network support each server uses and change it if possible through the Enterprise Manager.
Thanks...Binh
I'm looking at an MS SQL server database and it stores city namesacross the world. All aarabic , chinese etc names are converted to the latin alphabet.I feel it is probably critical we support accents as a means todistinguish between cities that would be converted to the same Latinalphabet representation otherwise and as a matter of culturalpoliteness.Now ...... how do we do this?Use varchar? which character code page do we use?Use nvarchar? I heard a rumour that SQL server pads unused characterswith blanks and hence will use space unnecessarily.The data will be presented on sheets and emailed around the world - itwill also appear on a website.Any advice greatly appreciated - thanksOliver
View 1 Replies View RelatedAn update was supposed to be released for SQL Server Mobile which enabled support for CE 4.2. This was supposed to be released around the time of CF 2.0 sp1. SP1 came out over a month ago and there is still no sign of the SQL Mobile update. Does anyone have any information on a release date ?
View 6 Replies View RelatedI am trying to work a statement like the below - but am getting an error - I assume that @@ROWCOUNT is not supported?
UPDATE MobileInvoiceImport SET OrderDetailID = '123', QuantityReceived = '66' WHERE OrderDetailID = '123'
IF @@ROWCOUNT = 0
INSERT INTO MobileInvoiceImport (OrderDetailID, QuantityReceived) VALUES('123','1')
Hi,
Pardon me if this is not the right forum.
Is SQL Mobile supporting OMAP850 ?
If yes what cab should I use to manually instal sql mobile on the device, OMAP850 is not listed in compact framework nor sql mobile folders
if no is there a plan to support OMAP850 one day?
Thanks,
Philippe
SQL CE does not seem to support WITH NOCHECK constraint when altering the table to add a foreign key. How can I work around this?
View 3 Replies View RelatedDoes anybody know when Microsoft is planning to cut support for SQL 2000? Just recently we have learned that 7.0 is no longer supported.
Thank you in advance,
Leon Shargorodsky
How could i do if i need to use another language, unavailabel in collation such as laos, burma ?
View 2 Replies View RelatedCan CE be called from an app. that makes ODBC calls?
Thanks.
Hi, I need to get help for a SQL issue from Microsoft. On the website there seem to be two options--one is email support for $99 and another is "online" support for $259. What's the difference? Does the $259 option mean that Microsoft will remote log into my SQL Server and fix the issue while I watch? This is what I need done. Does this $259 pay for the whole issue, until it is resolved?
I am a Microsoft Certified Professional (MCSA)--do I get any discounts or is there any other avenues I should take to get remote support for SQL Server 2005? I wasn't sure where to ask this question, if it is more appropriate elsewhere then let me know.
Thanks!
Has anybody heard that Microsft is dropping support for servers running SQL Server 2000 SP3?
View 1 Replies View RelatedHi All.
What can we do to let the power that be know that there are many of us that want Dlinq to support SQL ev?
They say they are considering it, how can we help them deside?
Mike Greenway
I built a bulk Destination component for Oracle using lastest ODP.NET drivers. I was disapointed when I relised that SSIS does not support DTC (Distributed Transactional Coordinator) for ADO.NET connections, just for OLE DB ones. I do not see the reason for it as ADO.NET connection can enlist to a transaction in DTC (if provider supports it).
Is it possible somehow to change this default behaviour and have ADO.NET connection supporting DTC?
Thank you very much in advance
Vladimir
Hi friends,
I thinks this is not right place to post this question, but i don't know where can i post this one. I hope i will get reply. Actually our application is in two languages English & Spanish. We are having data in English in SQL Server 2005.
I need to Insert Spanish data in to tables. What is the way to Insert Spanish data? I need to create new table for inserting Spanish data? OR can i create new columns for spanish in existing table? OR I need to add data in the existing table without creating new table and new columns?
How they query, when they want Spanish data related to English?
Is it possible to get Spanish language words in SQL Server 2005 which is equal to English Words?
How can i write Scripts for retreiving Spanish data?
Could anyone help me to solve this problem. Thanks in Advance
Thanks
San
Good morning all,
I have an application that I need to run on 64-bit OS's, when will CE be supporting 64-bit OS's?
Will version 3.5 have this functionality and if so, would someone place a link to where I would be able to download this version, even if it is beta.
If not, is there a work around for this problem as discribed below?
The application installs.
Open the applications crashes on a CE dll, stating the library has caused the application to close.
The error given is that the DB is not on the machine or the user does not have access to the DB.
Application then closes.
After doing research I found that 3.1 doesn't support 64-bit OS's.
Will SP2 support the new XPS format for rendering? If not SP2, will you release a separate rendering extension on the web or will this have to wait for SP3?
We are looking to make the move from PDF to XPS as soon as possible but we generate so much content from SSRS 2005 it would not be practical until it natively supports the XPS format. In our case using the printer driver isn't an option because all of the reports are generated on a schedule on the server, not by a user through the UI.
Thank you in advance.