No announcements
Found 2565815 threads
-
0 VotesStored Proc - with XML passed as parameter
-e8b8d88f03b0/create-table-from-stored-procedure?forum=transactsql About using XML as a parameter of stored procedure, you could have a ...Answered | 3 Replies | 385 Views | Created by JaguarsJag - Wednesday, September 21, 2016 4:14 PM | Last reply by Albert_ Zhang - Monday, September 26, 2016 2:37 AM
-
1 Votes
Stored Proc - with XML passed as parameter
Hi - below is my Database diagram. How can i write a stored proc for this, with XML passing to this as a ...Answered | 6 Replies | 666 Views | Created by JaguarsJag - Monday, September 26, 2016 7:25 PM | Last reply by Manoj Pandey (manub22) - Tuesday, September 27, 2016 9:08 AM -
0 Votes
Validating XML before processing in SSIS - a good workaround
between the quotes, and you'll then have a copy of your schema loaded into SQL Server that can be referenced as dbo.MyXMLSchema. Next, I wrote a stored proc that ... -
0 Votes
Passing XML Table as Parameter to SQL Stored Proc?
Hi All, Is there any way I can pass a table (set of re-occurring data records of same field layout) of XML data to a SQL stored proc as a ...Unanswered | 1 Replies | 5564 Views | Created by _Ray Price_ - Tuesday, June 26, 2007 1:27 AM | Last reply by Hunchback - Tuesday, June 26, 2007 12:57 PM -
1 Votes
CREATE A TEMP TABLE WITH MORE THAN ONE COLUMN BASED ON PARAMETER PASSED IN
Hi, When I need to create a temp table with one column, I normally pass a comma delimited parameter to the stored proc like this: ...Answered | 1 Replies | 4844 Views | Created by Claudio Pallone - Monday, August 31, 2009 11:23 AM | Last reply by Plamen Ratchev - Monday, August 31, 2009 12:53 PM -
0 Votes
passing XML as stored proc parameter to a linked server
Hello! I was just wondering if there are any "best practice" solutions to enable an XML document to be passed as an XML parameter to a ...Answered | 2 Replies | 8506 Views | Created by GroovenDrew - Monday, January 29, 2007 2:32 AM | Last reply by GroovenDrew - Wednesday, January 31, 2007 12:47 AM -
0 Votes
running stored proc with parameter
hi, im getting an error when i run the stored proc with a string parameter in execute sql task object. this is the only code i ...Unanswered | 3 Replies | 6551 Views | Created by chempz - Sunday, September 3, 2006 6:42 AM | Last reply by Rafael Salas - Monday, September 4, 2006 4:02 AM -
0 Votes
Using XML as Input Parameter Reslts in "Invalid at the top level of the document"
In an Execute SQL Task i'm using a stored procedure with one input parameter. The parameter is defined as varchar(max), but the expectation is that valid ...Unanswered | 3 Replies | 4160 Views | Created by Phil500 - Thursday, August 27, 2009 9:24 PM | Last reply by Food Fan - Wednesday, November 14, 2012 7:59 PM -
0 Votes
Formatting/Returning stored proc results as XML
I found an approach that would preserve backwards compatibility while allowing me to manipulate results retrieved by a stored proc. It has to do with TableAnswered | 2 Replies | 9112 Views | Created by Yazan Diranieh - Tuesday, August 7, 2007 2:58 PM | Last reply by ChavanTatyabhau - Thursday, December 30, 2010 2:57 PM -
0 Votes
SQL Statement as Parameter for Stored Proc
I am not sure what your requirement is? Do you want users to input the parameter or you just want the stored procedures to execute with predefined ...Answered | 8 Replies | 1345 Views | Created by Kirk P. _ - Monday, September 29, 2014 3:28 PM | Last reply by Kirk P. _ - Tuesday, September 30, 2014 2:10 PM -
1 Votes
Stored Proc parameter as a condition
filter out or add results. In the below stored proc there is an input parameter that will be 1 for AND or 0 for NOT. How can I return results which do not ...Answered | 7 Replies | 4545 Views | Created by Jack McD - Wednesday, February 10, 2010 12:04 AM | Last reply by Naomi N - Wednesday, February 10, 2010 3:25 AM -
0 Votes
stored proc parameter type mismatch
If you use stored proc which having parameter then you need to pass parameter in your application other wise it throws error like mentioned you"expects ...Unanswered | 3 Replies | 3041 Views | Created by farmstrongFT - Wednesday, July 31, 2013 3:19 AM | Last reply by Papy Normand - Wednesday, July 31, 2013 8:28 AM -
0 Votes
Stored Proc Input Parameter Limited?
Hi all, Sorry about this post, I made a terrible mistake, I left out a variable nvarchar that limit my parameter somewhere in ...Answered | 3 Replies | 7219 Views | Created by darentan - Tuesday, April 25, 2006 3:20 AM | Last reply by Sergey Gavrilenko - Tuesday, April 25, 2006 8:09 AM -
0 Votes
Oracle stored proc with OUT parameter
Hi, I am calling an Oracle stored proc which contains an IN and an OUT parameter also. To the stored proc, ...Answered | 2 Replies | 5769 Views | Created by Tanmaya - Thursday, November 30, 2006 12:07 PM | Last reply by KapilGupta - Monday, May 12, 2008 7:49 PM -
0 Votes
Retrieveing Parameter from stored proc with sqldatasource
I see you solved this one, but if you are slinging code anyway, you can explicitly set up the parameter. This does not work with the drag and drop, but it gives you a bit more ...Answered | 3 Replies | 2566 Views | Created by Hayes0 - Thursday, November 13, 2008 2:43 PM | Last reply by Gregory A. Beamer - MVP - Thursday, November 13, 2008 3:50 PM -
2 Votes
Multi value parameter with stored proc
Hello, In Reporting Services, all selected values of multi-value parameter will be passed as a comma-delimited string when using stored ...Answered | 5 Replies | 4576 Views | Created by anaylor01 - Thursday, November 22, 2012 1:42 AM | Last reply by Fanny Liu - Friday, November 23, 2012 1:13 AM -
0 Votes
XML Datasource as parameter to Stored Procedure
want to use the result from the WebService that my XML Datasource uses as the expression for the parameter to be input to the Stored ...Unanswered | 1 Replies | 6030 Views | Created by David Maynard - Friday, June 9, 2006 2:07 PM | Last reply by Ian Roof - MSFT - Saturday, June 10, 2006 12:30 AM -
0 Votes
Passing complete XML file as 1 parameter to SQL Stored Proc using (@xmlDoc xml)
Answered | 3 Replies | 528 Views | Created by JaguarsJag - Thursday, September 29, 2016 3:40 PM | Last reply by Arindam Paul Roy - Thursday, September 29, 2016 4:51 PM -
0 Votes
InvalidXML through vb.net (2.0) using endpoint, valid directly into stored proc
? The xml is valid, since it does work when directly passed into the stored proc as a regular input parameter. Here is ...Answered | 3 Replies | 9145 Views | Created by BethM - Monday, February 13, 2006 7:59 PM | Last reply by Matt Neerincx - Saturday, April 1, 2006 5:52 AM -
0 Votes
Passing table of values from Excel/Access to SQL Stored Proc
which is passed to the Stored Proc. One could also pass the table as XML which is then parsed by SQL Server using nodes() or Openxml or ...Answered | 2 Replies | 14541 Views | Created by Chaitanya Dabholkar - Friday, March 4, 2011 2:13 PM | Last reply by Chaitanya Dabholkar - Thursday, March 10, 2011 5:09 AM - Items 1 to 20 of 2565815 Next ›
No announcements
