No announcements
Found 2437375 threads
-
0 VotesE_NOINTERFACE method result on OLEDB ODBC connection result set update
The application environment automatically declare a m_pSet variable for the database connection result set and opens the result set with OpenAll() method, calling ...Answered | 1 Replies | 1452 Views | Created by Misulache - Thursday, December 24, 2015 9:44 AM | Last reply by Dave Patrick - Thursday, December 24, 2015 1:54 PM
-
0 Votes
Result set Null - change to blank
I agree with Brad - I think there is no setting to use to replace all NULL with 'NULL' in the select statement without listing each field separately.Answered | 3 Replies | 4548 Views | Created by JohnLawlor - Wednesday, January 20, 2010 4:59 PM | Last reply by Naomi N - Wednesday, January 20, 2010 5:16 PM -
0 Votes
How to return the result set of multiple select statements as one result set?
In your example I'm guessing id is an int and name is a varchar or nvarchar.Answered | 2 Replies | 1128 Views | Created by Developer life - Tuesday, September 23, 2014 10:17 PM | Last reply by Developer life - Wednesday, September 24, 2014 4:28 AM -
0 Votes
Search Result Set
Hi Mridul, The number of rows in a result set is 500 rows.Answered | 1 Replies | 1303 Views | Created by Mridul Arora - Monday, August 19, 2019 11:54 AM | Last reply by Chelsea Wu - Tuesday, August 20, 2019 1:57 AM -
0 Votes
Trying to set colum to be '*A'+ID+'*'
I am trying to update subdescription2 to be *A(number from ID column)* But when I run the below I get, Conversion failed when converting the varchar ...Answered | 4 Replies | 698 Views | Created by Brian..D - Tuesday, May 27, 2014 4:28 PM | Last reply by Brian..D - Tuesday, May 27, 2014 4:39 PM -
2 Votes
compare two result sets
, the result is the same.Answered | 6 Replies | 10925 Views | Created by Sudeep Puvvadi - Friday, August 12, 2011 9:36 AM | Last reply by Stavros Macrakis - Monday, March 25, 2019 4:09 PM -
1 Votes
set the result of execute() into a variable ?
Your query missed an single quote after declaring "@result int OUTPUT".Answered | 6 Replies | 48544 Views | Created by novicedba - Wednesday, August 3, 2011 9:30 AM | Last reply by jnztech - Tuesday, March 6, 2018 4:28 PM -
0 Votes
generation id in update command
↑ Grab this Headline AnimatorAnswered | 16 Replies | 4552 Views | Created by SunnyIngulia - Thursday, October 28, 2010 1:59 PM | Last reply by ramireddy - Thursday, October 28, 2010 2:48 PM -
4 Votes
Multiple Result Sets Using in SSRS
Hi, Thank you for your Reply. i change my stored procedure Result Set Order.Now its working Fine.Answered | 3 Replies | 20568 Views | Created by Raju Malla - Thursday, March 11, 2010 12:14 PM | Last reply by BI Analyst - Wednesday, November 7, 2012 9:53 AM -
2 Votes
execute sql task result set
Set the resultset to Single Row on the General tab.Answered | 1 Replies | 5467 Views | Created by arun_arunarun - Thursday, March 17, 2011 8:47 AM | Last reply by SSISJoost - Thursday, March 17, 2011 9:04 AM -
0 Votes
Updating the ID Column display name
As you noted, moving an item will generate a new ID in the new list.Answered | 4 Replies | 1796 Views | Created by Timothy P Hackett - Thursday, June 30, 2016 2:01 AM | Last reply by Mike Smith MCT MVP - Monday, July 4, 2016 4:05 PM -
0 Votes
How to execute sp_executesql for each row in a result set to perform an update
@Daniel I was not updating sys.columns, I was querying it to find out the tables that had that field name and then generate an update statement for each.Answered | 6 Replies | 5277 Views | Created by JasonDWilson77 - Monday, July 20, 2015 7:25 PM | Last reply by Eric__Zhang - Tuesday, July 21, 2015 8:40 AM -
1 Votes
Update Procedure by ID and Call
HauMin The Identity column is fine however, my issue is in executing the procedure by passing the id into the exec and updating the only field that I supply.Answered | 4 Replies | 1603 Views | Created by Skrappy - Monday, November 19, 2012 4:00 AM | Last reply by Jackson_1990 - Monday, November 19, 2012 4:47 AM -
0 Votes
Update Statement is not affecting result
Did you know that the old 1970's Sybase UPDATE..Answered | 7 Replies | 1565 Views | Created by Paul Aziz - Wednesday, January 30, 2013 3:21 AM | Last reply by Paul Aziz - Friday, February 1, 2013 1:39 AM -
0 Votes
Transpose of Result set
.* from Customer c cross apply ( select ''r''+ cast(ID as nvarchar(100)) ,''name'',name union all select ''r''+ ...Answered | 3 Replies | 2658 Views | Created by Mujahid.hassan - Wednesday, July 25, 2012 8:14 AM | Last reply by Chintak Chhapia - Wednesday, July 25, 2012 10:37 AM -
0 Votes
update results from a select count
in the above code just before update, use select * from mycte to get the new result set.Answered | 9 Replies | 2826 Views | Created by Unwind_1 - Tuesday, November 20, 2012 5:47 PM | Last reply by Johnson T A - Tuesday, November 20, 2012 6:57 PM -
3 Votes
Can not update order id field not updateable
Usually ID column is Primary key and set to not null.Answered | 9 Replies | 5920 Views | Created by joe mayo 1969 - Friday, June 10, 2011 12:42 PM | Last reply by Mitja Bonca - Sunday, June 12, 2011 11:39 PM -
0 Votes
INSERT missing dates in result set
DECLARE @Data TABLE ( ID INT, DESCRIPTION VARCHAR(100), EventDate date ) INSERT INTO @Data VALUES (1, 'SomeData', '1/1/2015') INSERT INTO @Data ...Answered | 3 Replies | 816 Views | Created by CarlGanz - Monday, December 7, 2015 3:45 PM | Last reply by Rajat Jaiswal - Monday, December 7, 2015 4:27 PM -
3 Votes
Does updating a column result in a table lock?
Imagine this: -- You declare a temporary table with the column or columns that you belong to the primary key DECLARE @TempTable TABLE (id ...Answered | 10 Replies | 1344 Views | Created by steveosmith - Thursday, May 16, 2013 9:11 PM | Last reply by Rechousa - Thursday, May 16, 2013 10:54 PM -
2 Votes
EXECUTE WITH RESULT SETS (Denali)
(Took a while for me to actually get a Denali set up to actually try out WITH RESULT SETS.)Answered | 8 Replies | 6703 Views | Created by Jason Kresowaty - Wednesday, November 10, 2010 3:37 AM | Last reply by Jason Kresowaty - Tuesday, January 11, 2011 12:47 AM - Items 1 to 20 of 2437375 Next ›
No announcements
