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

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)

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,

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

Update Contacts
FirstName = b.FirstName,
LastName = b.LastName,
ContactNo = b.ContactNo
#tempContact as b
Contacts.Id = b.ID

3 votes
Sign in
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


Sign in
Sign in with: facebook google
Signed in as (Sign out)

Feedback and Knowledge Base