No announcements
Found 3653063 threads
-
0 VotesParametrized Mdx Query question?
Hi Ram, That works great, can you please help me too below query?Answered | 3 Replies | 2055 Views | Created by gk1393 - Thursday, May 2, 2013 2:32 PM | Last reply by Bharath_RAM - Monday, May 6, 2013 5:10 AM
-
1 Votes
Parametrized query from variable: query too big!!!
I've been having an issue when trying to run a parametrized query using a String variable to store my query in.Answered | 2 Replies | 3970 Views | Created by Eduardo Z - Thursday, May 28, 2009 5:27 PM | Last reply by Eduardo Z - Thursday, May 28, 2009 7:28 PM -
0 Votes
Check constraint does not work for parametrized query in a view
The static approach (runs in 10 minutes) uses 1 table of 200 million rows while the parametrized approach (runs in 20 minutes) uses 2 tables of some 600 million ...Answered | 5 Replies | 4389 Views | Created by tennisbuff - Friday, December 4, 2009 10:39 PM | Last reply by Dan Guzman - Wednesday, December 9, 2009 1:43 PM -
0 Votes
SELECT ...
I tried using the ArrayBindSize construct, however the query is only return results for the first value in the array.Answered | 6 Replies | 316 Views | Created by Anonymous - Tuesday, April 6, 2010 5:30 AM | Last reply by Anonymous - Monday, November 21, 2011 11:24 AM -
1 Votes
how to make a parametrized query for check boxes?
If I understand correctly you are tryign to dynamically compose a SQL query using control values.Answered | 5 Replies | 3158 Views | Created by kavita bhaskaran kukkala - Wednesday, July 2, 2008 4:14 PM | Last reply by kavita bhaskaran kukkala - Wednesday, July 2, 2008 7:23 PM -
0 Votes
UPDATE where SELECT query
With the following statement you update only 10 records without a set My_Timestamp update TOP (10) My_Table set My_TimeStamp = GETDATE() where My_TimeStamp IS ...Answered | 1 Replies | 740 Views | Created by Corp_AF - Wednesday, August 26, 2015 2:19 PM | Last reply by Olaf Helper - Wednesday, August 26, 2015 2:26 PM -
0 Votes
Where can I find the ODP.NET install which will give me ODP.NET 1.102.2.20
Visual Studio Forums > Visual Studio Setup and Installation located here: ...Answered | 1 Replies | 8120 Views | Created by Core_Support - Friday, July 10, 2009 12:02 AM | Last reply by Shrikant Maske - Friday, July 10, 2009 9:06 PM -
0 Votes
Parametric Dynamic Pivot Query
where convert(date, convert(varchar(8),primmonth) + '01') <= convert(date,@varmonth + '01') group by PrimMonth , StoreID ) select value , ...Answered | 2 Replies | 2997 Views | Created by innocent1973 - Wednesday, July 27, 2011 1:03 PM | Last reply by gao.seng - Wednesday, July 27, 2011 2:39 PM -
1 Votes
SQL (SELECT FROM ..
Passing the values as parameters prevents errors and possible SQL Injection, see Commands and Parameters: DT.Clear() Dim ...Answered | 4 Replies | 6602 Views | Created by Abkarov096 - Sunday, December 22, 2013 9:36 AM | Last reply by Leo (Apple) Yang - Tuesday, December 24, 2013 9:24 AM -
0 Votes
Sync Services + ODP.NET
The constructors of OracleParameter use Oracle DbTypes by default.Answered | 4 Replies | 14897 Views | Created by NinoBenvenuti - Monday, June 23, 2008 8:27 PM | Last reply by Uwe Reisewitz - Wednesday, October 21, 2009 7:37 PM -
0 Votes
Question on ODP.NET
http://www.bing.com/search?Answered | 6 Replies | 9948 Views | Created by Fonzerelli - Monday, January 11, 2010 11:10 AM | Last reply by Fonzerelli - Wednesday, February 3, 2010 4:32 PM -
0 Votes
Doubt in where clause of select query
Regards Syed Hello Syed, Your syntax is incorrect which is why I indicated to use parameters, ...Answered | 5 Replies | 1614 Views | Created by syed javid ali - Tuesday, July 2, 2013 10:10 AM | Last reply by syed javid ali - Tuesday, July 2, 2013 1:33 PM -
0 Votes
typed dataset using the ODP.NET data provider from Server Explorer
In Visual Studio, from View menu select Server Explorer.Answered | 1 Replies | 6693 Views | Created by Shankara4u - Wednesday, February 11, 2009 6:21 AM | Last reply by incaman.org - Thursday, August 20, 2009 7:33 PM -
0 Votes
Lookup transformation - parametrize connection
[SqlCommand] property of Data Flow Task as below: "select * from " + @[$Package::Parameter] +" where [aa]='prasad'" In ...Answered | 3 Replies | 895 Views | Created by maestro_h - Friday, August 14, 2015 6:59 AM | Last reply by Katherine Xiong - Wednesday, August 19, 2015 8:08 AM -
0 Votes
using function in select query
Why not to use GETDATE()?Answered | 3 Replies | 52378 Views | Created by dpkas - Friday, April 15, 2011 12:24 PM | Last reply by Atif-ullah Sheikh - Friday, April 15, 2011 12:38 PM -
0 Votes
Multiple parametrized query with same connection and command objects using vbscript
You mean to say that someone is still using vbscript and classic ASP?Answered | 1 Replies | 452 Views | Created by venturert - Saturday, January 16, 2016 1:41 PM | Last reply by DA924 - Saturday, January 16, 2016 3:34 PM -
2 Votes
Difficulties to parametrize a LogicApp template
In the meantime, you might want to take a look at this article from Paco de La Cruz, which goes over a technique similar to what you are using.Answered | 2 Replies | 1423 Views | Created by Denis_28 - Wednesday, January 17, 2018 10:24 AM | Last reply by WSilveiraNZ [MVP] - Thursday, January 18, 2018 6:02 AM -
0 Votes
soreprocedure using in the select query
; COUNTRY ON EMPLOYEE_MF.COUNTRY_ID = ...Answered | 2 Replies | 1588 Views | Created by jessy varkey - Thursday, March 21, 2013 10:14 AM | Last reply by Uri Dimant - Thursday, March 21, 2013 10:46 AM -
0 Votes
How to configure Sharepoint 2013 with ODP.NET to use entity framework.
But when I try to use it in a sharepoint project, It fails.Answered | 3 Replies | 3400 Views | Created by Emre_Tuncer - Monday, March 4, 2013 3:13 PM | Last reply by Dmitry Kaloshin - Monday, March 11, 2013 6:56 AM -
2 Votes
How to pass an array of byte arrays using ODP.Net?
Hi all, I am trying to pass an array of byte arrays (byte[][]) to Oracle procedure using ODP.Net, which from the Oracle perpective is an array ...Answered | 1 Replies | 8107 Views | Created by DiligentKarma - Friday, December 2, 2011 11:36 PM | Last reply by Wang Huang - Saturday, December 3, 2011 9:20 AM - Items 1 to 20 of 3653063 Next ›
No announcements
