I suggest you ...

SQL80001 and SQL46010

Copy and paste this into VS 2015 RC. I keep getting an error that is quite annoy and is a problem at "From" for some old reason. You might want to fix it since this is an error going on since VS 2010 from what I have read. I am trying to create it on 2014 SQL Server from VS

CREATE PROCEDURE [dbo].[ContactBulkUpdate]
@XMLData xml

AS
Create table #tempContact(
ID int not null,
FirstName varchar(50) not null,
LastName varchar(50) not null,
ContactNo varchar(50) not null
)

Insert into #tempContact (ID, FirstName, LastName, ContactNo)

Select
contact.query('ID').value('.','int') as ID,
contact.query('FirstName').value('.','varchar(50)') as FirstName,
contact.query('LastName').value('.','varchar(50)') as LastName,
contact.query('ContactNo').value('.','varchar(50)') as ContactNo,

From
xmlData.nodes.nodes('/contacts/contact') as xmlData(contact)

Update Contacts
Set
FirstName = b.FirstName,
LastName = b.LastName,
ContactNo = b.ContactNo
from
#tempContact as b
Where
Contacts.Id = b.ID
RETURN

3 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Justin Burcaw shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

Thank you for your feedback. If you have specific bugs you would like to report, we encourage you to use the “Report a Problem” feature under the Help | Send Feedback menu in Visual Studio. This provides us with necessary context so that we can most efficiently address the issue.

Paul Chapman
Visual Studio Program Manager

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base