Click here to Skip to main content
15,883,603 members
Home / Discussions / Database
   

Database

 
AnswerRe: SSIS Package : Revision Number Pin
SimulationofSai29-Sep-08 2:07
SimulationofSai29-Sep-08 2:07 
QuestionUpdating the xml to be returned from stored procedure Pin
ONeil Tomlinson28-Sep-08 9:38
ONeil Tomlinson28-Sep-08 9:38 
AnswerRe: Updating the xml to be returned from stored procedure Pin
Wendelius28-Sep-08 17:57
mentorWendelius28-Sep-08 17:57 
GeneralRe: Updating the xml to be returned from stored procedure Pin
ONeil Tomlinson29-Sep-08 3:39
ONeil Tomlinson29-Sep-08 3:39 
GeneralRe: Updating the xml to be returned from stored procedure Pin
Wendelius29-Sep-08 4:43
mentorWendelius29-Sep-08 4:43 
GeneralRe: Updating the xml to be returned from stored procedure Pin
ONeil Tomlinson29-Sep-08 4:53
ONeil Tomlinson29-Sep-08 4:53 
GeneralRe: Updating the xml to be returned from stored procedure Pin
Wendelius29-Sep-08 5:08
mentorWendelius29-Sep-08 5:08 
GeneralRe: Updating the xml to be returned from stored procedure Pin
ONeil Tomlinson29-Sep-08 5:54
ONeil Tomlinson29-Sep-08 5:54 
Im feeling very stupid today. for some reason im always getting errors. copy, paste and try the below code. It parses ok but when Execute im getting this error ------- "The data types varchar and xml are incompatible in the add operator."


########################################
ALTER PROC [dbo].[sp_Testing2]
@empdata xml,
@code varchar

AS

DECLARE @hDoc int
declare @somethingToAdd xml


exec sp_xml_preparedocument @hDoc OUTPUT,@empdata


set @somethingToAdd = '<Employee ID= ''101''><Code>'+@code+'</Code><Name>''Name101''</Name></Employee>'

Select @empdata
set @empdata.modify('insert sql:variable('+ @somethingToAdd+') into (/Employees)[1]')


-- return the XMl
Select @empdata

####################################################
GeneralRe: Updating the xml to be returned from stored procedure Pin
Wendelius29-Sep-08 6:12
mentorWendelius29-Sep-08 6:12 
GeneralRe: Updating the xml to be returned from stored procedure Pin
ONeil Tomlinson29-Sep-08 22:15
ONeil Tomlinson29-Sep-08 22:15 
GeneralRe: Updating the xml to be returned from stored procedure Pin
Wendelius30-Sep-08 2:54
mentorWendelius30-Sep-08 2:54 
Questionhow to install sql server database on windows XP OS ? Pin
Tridip Bhattacharjee28-Sep-08 4:25
professionalTridip Bhattacharjee28-Sep-08 4:25 
AnswerRe: how to install sql server database on windows XP OS ? Pin
Wendelius28-Sep-08 4:34
mentorWendelius28-Sep-08 4:34 
QuestionSQL Express Pin
Ali Tavakol27-Sep-08 0:46
Ali Tavakol27-Sep-08 0:46 
AnswerRe: SQL Express Pin
Paul Conrad27-Sep-08 5:37
professionalPaul Conrad27-Sep-08 5:37 
Answerhey everyone! It's URGENT! Pin
leckey27-Sep-08 13:39
leckey27-Sep-08 13:39 
GeneralRe: hey everyone! It's URGENT! Pin
Ali Tavakol27-Sep-08 20:43
Ali Tavakol27-Sep-08 20:43 
General:face palm: Pin
leckey28-Sep-08 6:45
leckey28-Sep-08 6:45 
GeneralRe: :face palm: Pin
Paul Conrad29-Sep-08 6:50
professionalPaul Conrad29-Sep-08 6:50 
QuestionIndexing Question Pin
Meysam Mahfouzi26-Sep-08 20:49
Meysam Mahfouzi26-Sep-08 20:49 
AnswerRe: Indexing Question Pin
Wendelius26-Sep-08 22:38
mentorWendelius26-Sep-08 22:38 
GeneralRe: Indexing Question Pin
Meysam Mahfouzi26-Sep-08 23:25
Meysam Mahfouzi26-Sep-08 23:25 
GeneralRe: Indexing Question Pin
Wendelius26-Sep-08 23:51
mentorWendelius26-Sep-08 23:51 
GeneralRe: Indexing Question Pin
Meysam Mahfouzi27-Sep-08 0:03
Meysam Mahfouzi27-Sep-08 0:03 
GeneralRe: Indexing Question Pin
Meysam Mahfouzi27-Sep-08 2:35
Meysam Mahfouzi27-Sep-08 2:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.