No announcements
Found 2280477 threads
-
0 VotesProblem with parameterized query.
I'm trying to use a parameterized query where the parameter is the table I'm querying from (i.e. "select * from @datatable). Answered | 1 Replies | 8657 Views | Created by Ken Harris - Friday, July 29, 2005 2:02 PM | Last reply by Brian Welcker - Sunday, August 14, 2005 11:03 PM
-
0 Votes
Problem with adding a parameterized query
want to send me a zipped copy of the project that exhibits the problem, I'll have a look at what's wrong (I'll probably see it quite quickly). You already have my ...Answered | 7 Replies | 1101 Views | Created by Jyuma1 - Wednesday, January 23, 2013 5:09 PM | Last reply by Jyuma1 - Thursday, January 24, 2013 12:52 PM -
1 Votes
Parameterized Query accessing a View with a Sub-Query and Ranking Function is much slower than a Non-Parameterized Query
OPTIMIZE FOR query hint does not resolve the issue. Erland, I definitely have a real problem with this. Ha, I don't spent time trying to find ...Answered | 6 Replies | 626 Views | Created by Ben-Page - Monday, August 14, 2017 5:13 PM | Last reply by Hunchback - Tuesday, August 15, 2017 4:03 PM -
0 Votes
SqlCeTransaction.Commit() Kills Prepare()'d SqlCeCommand Query Plan??
SQL CE 3.5 SP2. Repeatedly calling ExecuteNonQuery() on a parameterized SqlCeCommand which is Prepare()'d and retained in the scope of a single SqlCeConnection ...Answered | 3 Replies | 1959 Views | Created by Tim Trese - Wednesday, February 15, 2017 11:15 PM | Last reply by Tim Trese - Thursday, June 15, 2017 6:42 PM -
0 Votes
Microsoft access and C#
/mimrantaj/Database102102008130743PM/Database1.aspx One problem with that article is hardcoded query string. It can cause sqlinjection. To avoid use stored ...Answered | 3 Replies | 3348 Views | Created by sunil_sonu322 - Saturday, April 3, 2010 10:49 AM | Last reply by Ramesh Swaminathan - Saturday, April 3, 2010 5:59 PM -
0 Votes
Parameterized Query Problem
After last SQLUSA's reply I noticed that it is exec inside of your SQL string and this is the root of the problem. You need to remove it from the string and set command type of your cmd toAnswered | 8 Replies | 4599 Views | Created by Rick G. Garibay - Sunday, May 11, 2008 3:30 AM | Last reply by Little Panther - Friday, June 6, 2014 3:31 PM -
0 Votes
Parameterized Query
for you, so sometimes it can create parameterized query from your ad-hoc query With kind regards Krystian Zieja httpAnswered | 4 Replies | 5996 Views | Created by Ryan_XH - Tuesday, April 19, 2011 2:46 PM | Last reply by Krystian.Zieja - Tuesday, April 19, 2011 3:03 PM -
0 Votes
SQL Query
Hi, I'm having a problem with a litlle lookup SQL, i'm trying to return the cost of anAnswered | 5 Replies | 2997 Views | Created by JonSamwell - Thursday, August 2, 2007 8:14 AM | Last reply by JonSamwell - Thursday, August 2, 2007 9:47 AM -
0 Votes
SQL Query
Hi, I'm having a problem with aAnswered | 7 Replies | 2797 Views | Created by JonSamwell - Thursday, August 2, 2007 9:05 AM | Last reply by JonSamwell - Thursday, August 2, 2007 4:27 PM -
0 Votes
Parameterized query with ExecuteScalar
The problem was in the date. I used: Dim day As String = DateTime.Parse(dtMonthRep.Value).DayOfWeek instead of Dim ...Answered | 3 Replies | 617 Views | Created by XesChild - Tuesday, May 13, 2014 11:50 AM | Last reply by XesChild - Tuesday, May 13, 2014 12:56 PM -
0 Votes
parameterized query
I created a search engine using a parameterized query.The query is from two tables having a one to many relationship.When i search with data from the first table,my ...Answered | 2 Replies | 2812 Views | Created by cire nage - Friday, December 4, 2009 3:43 PM | Last reply by Jeff Shan - Wednesday, December 9, 2009 11:52 AM -
0 Votes
Parameterized query with SQL Adapter
@id ¿Is it possible to use this kind of queries from the SQL server adapter?Answered | 5 Replies | 6800 Views | Created by lluiss - Friday, September 23, 2011 6:02 PM | Last reply by DPS Bali - Sunday, September 25, 2011 10:14 AM -
0 Votes
Parameterized Query
Hey Folks, Can Someone tell me why I am getting this message. Not Sure what this means. Many Thanks!!! Parameterized ...Answered | 2 Replies | 6518 Views | Created by TJ9139 - Thursday, May 4, 2006 2:34 AM | Last reply by VMazur - Friday, May 5, 2006 10:20 AM -
0 Votes
dataset with parameterized top query
I had the same problem and my solution is as follows. I created a parameterized stored procedure and used it as the source of the dataset with the default ...Answered | 7 Replies | 6371 Views | Created by John Craven - Tuesday, October 31, 2006 9:30 PM | Last reply by Pelso - Thursday, March 3, 2011 2:52 PM -
0 Votes
Using dateadd in a parameterized query
The simplified version did not remove the problem. I did try the exact query that I posted and got the error about data ...Answered | 7 Replies | 5491 Views | Created by Michael Oder - Tuesday, April 15, 2008 8:28 PM | Last reply by Jenn_allen - Thursday, June 15, 2017 6:33 PM -
0 Votes
Parameterized query with XQuery clause
I'll try this in an ODBC program to see if it works or not. I"ll let you know soon. If you could profide some sample data against which the query should work, that would be ...Answered | 1 Replies | 10653 Views | Created by RussSchick - Wednesday, May 27, 2009 6:47 PM | Last reply by Jay Kint MSFT - Thursday, May 28, 2009 5:21 PM -
0 Votes
Parameterized Query with Enterprise Library ExecuteSqlStringAccessor()
For me below code is working fine for a parameterized query DatabaseFactory.SetDatabaseProviderFactory(new DatabaseProviderFactoryAnswered | 1 Replies | 4868 Views | Created by JAISH MATHEWS - Monday, July 15, 2013 4:35 PM | Last reply by Caillen - Tuesday, July 16, 2013 11:47 AM -
1 Votes
slow parameterized query
than the literal. Plus, the average time to run the parameterized query is actually higher than the first run. I agree with you about the desirability of ...Answered | 13 Replies | 2561 Views | Created by KevClark64 - Wednesday, October 10, 2018 2:32 PM | Last reply by KevClark64 - Thursday, July 25, 2019 3:50 PM -
0 Votes
Parameterized Query Does Not Return Null Values
cell contains information. How can I return all records, including those with NULL cells, from my parameterized ...Answered | 1 Replies | 3111 Views | Created by Damonj - Friday, June 11, 2010 2:25 PM | Last reply by Jason Kresowaty - Saturday, June 12, 2010 12:06 AM -
0 Votes
parameterized query performance/speed issue
Hello all, I am running a query on a SQL 2000 table with roughly 50 million phone numbers stored in varchar format. I am converting from an old asp page to asp.net ...Answered | 3 Replies | 3197 Views | Created by John Saccoccio - Wednesday, August 2, 2006 11:30 PM | Last reply by Sarah Parra - MSFT - Thursday, August 3, 2006 4:57 PM - Items 1 to 20 of 2280477 Next ›
No announcements
