No announcements
Found 2881745 threads
-
0 VotesCodeFirst 4.1 parameterized query sends unicode string to sqlserver
Hi, I'm trying to use EF 4.1 (CodeFirst) to query a table which has a char column (non-unicode). I qualify the POCO ...Unanswered | 2 Replies | 2475 Views | Created by crirodmur - Tuesday, October 11, 2011 6:02 PM | Last reply by crirodmur - Wednesday, October 12, 2011 4:42 PM
-
0 Votes
Parameterized Query
)', N'ANATR'; The main difference is that the only thing that changes from one execution to another, for the parameterized query, are the values of the ...Answered | 4 Replies | 5970 Views | Created by Ryan_XH - Tuesday, April 19, 2011 2:46 PM | Last reply by Krystian.Zieja - Tuesday, April 19, 2011 3:03 PM -
1 Votes
Parameterized query
'''') I need to implement it as parameterized query.Proposed | 4 Replies | 558 Views | Created by puneet122016 - Saturday, February 25, 2017 2:55 PM | Last reply by msbi_Dev - Sunday, February 26, 2017 1:40 AM -
0 Votes
Parameterized query
into a nvarchar that contains the rest of the query, and then you execute the resulting string with sp_executsql. But if you are doing this from a client written in C#, ...Proposed | 3 Replies | 411 Views | Created by puneet122016 - Saturday, February 25, 2017 6:42 AM | Last reply by Sabah Shariq - Monday, February 27, 2017 10:35 AM -
0 Votes
How to parameterized query.........
Hi, If you want to create a Parameterized query in your SSRS report then you can refer following BOL articles;Answered | 2 Replies | 5564 Views | Created by Anal Patel - Friday, April 1, 2011 9:50 AM | Last reply by Aniruddha Thengadi - Friday, April 1, 2011 12:22 PM -
0 Votes
ASCII string to UNICODE string
into UNICODE, instead of having to use the MultibyteToWideChar() function. Also i am unsure how to use this function(how should i declare the buffer the converted ...Answered | 6 Replies | 7376 Views | Created by daniboy120 - Friday, September 22, 2006 6:57 AM | Last reply by Sarath.C - Friday, September 22, 2006 10:10 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 | 6507 Views | Created by TJ9139 - Thursday, May 4, 2006 2:34 AM | Last reply by VMazur - Friday, May 5, 2006 10:20 AM -
2 Votes
unicode string
Because no matter you have '' or N'', SQL Server sees a Unicode string, because that is how SSMS sends the command to SQL Server. So SQL Server sees a ...Answered | 11 Replies | 1063 Views | Created by simonxy - Friday, April 17, 2015 8:55 AM | Last reply by simonxy - Tuesday, April 21, 2015 8:41 AM -
0 Votes
Inserting Unicode String
I am using Odata client library for windows phone to access my azure sql tables. One problem that I had is to insert Unicode string. When I use sql server ...Unanswered | 2 Replies | 7355 Views | Created by sunxinASU - Tuesday, August 2, 2011 5:25 AM | Last reply by sunxinASU - Wednesday, August 10, 2011 1:59 AM -
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 | 2802 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
String (Unicode) to Delphi String
there's a way to do Ansi (non-Unicode) interop. Hopefully this would cause COM to not interpret the argument at all (so it won't treat it as a string). I'm ...Answered | 32 Replies | 12123 Views | Created by Xor2 - Monday, February 15, 2010 12:55 PM | Last reply by Louis.fr - Tuesday, February 16, 2010 12:38 PM -
0 Votes
Unicode Byte to string
the string to ANSI text. pBytes = Marshal.StringToCoTaskMemAnsi(szString);Answered | 4 Replies | 6839 Views | Created by Jessica Alba - Thursday, September 7, 2006 7:16 AM | Last reply by Jessica Alba - Friday, September 8, 2006 2:36 AM -
0 Votes
Parameterized connection string & parameters - problem
It looks like adding second dataset to use datasource with parameterized string spoils something. -
3 Votes
Convert string to Unicode
How can I convert a string to Unicode? The output should be the Unicode string. Noam ...Answered | 6 Replies | 50619 Views | Created by Noam B - Tuesday, June 15, 2010 11:39 AM | Last reply by Noam B - Thursday, June 17, 2010 12:30 PM -
0 Votes
String Unicode and NVARCHAR
"OLE DB Destination" to change dataype of external columns of "OLE DB Destination" to unicode string but I can't, the change is not saved. On ...Answered | 6 Replies | 1531 Views | Created by Maxime302 - Friday, January 4, 2013 10:37 AM | Last reply by Maxime302 - Friday, January 4, 2013 12:37 PM -
0 Votes
Problem with parameterized query.
use an expression string for the query.="SELECT * FROM [" & Parameters!TableName.Value & "]"You need to be careful here about SQL injection. If ...Answered | 1 Replies | 8643 Views | Created by Ken Harris - Friday, July 29, 2005 2:02 PM | Last reply by Brian Welcker - Sunday, August 14, 2005 11:03 PM -
1 Votes
slow parameterized query
that is used in a parameterized query in postgres, it is an order of magnitude faster to cast the variable as "decimal". For ...Answered | 13 Replies | 2509 Views | Created by KevClark64 - Wednesday, October 10, 2018 2:32 PM | Last reply by KevClark64 - Thursday, July 25, 2019 3:50 PM -
0 Votes
convert unicode to string
If I have a string that I pull from my database (stored in unicode), how do I convert this string so I can display in a textbox? I am trying to ...Answered | 1 Replies | 2838 Views | Created by project2n5e0o1 - Tuesday, October 23, 2007 4:34 AM | Last reply by Surreal - Tuesday, October 23, 2007 11:27 AM -
0 Votes
Using EF 4.1 CodeFirst: How do I expose derived classes?
ContainerItem=>BaseItem), and mapped to SQL as Table-Per-Hierarchy. I have DBSets for base and derived classes, and I -
0 Votes
Converting from non-unicode to unicode string
So Console.Writeline is smart enough to figure out that cb is not a unicode string and convert it?Answered | 13 Replies | 3676 Views | Created by Wozza99 - Tuesday, February 10, 2009 2:39 PM | Last reply by Wozza99 - Tuesday, February 10, 2009 6:43 PM - Items 1 to 20 of 2881745 Next ›
No announcements
