No announcements
Found 2553186 threads
-
0 VotesEquivalent Sql Queries of Some Ado.net methods
no no. All i needed was Inner Join. Thanks. Just I thought that there must be equivalent queries with the all ADO.net methods. So, my brain was a little bit ...Answered | 7 Replies | 3919 Views | Created by Ferhad Cebiyev - Thursday, August 18, 2011 2:48 PM | Last reply by Larcolais Gong - Wednesday, August 24, 2011 8:56 AM
-
2 Votes
INNER JOIN Equivalent of SQL in ADO.NET
The query seems to be correct so I recommend that you run your query against the backend SQL and confirm the data is correct. If it is then try a simpler query against each ...Answered | 5 Replies | 6468 Views | Created by Md.Ibrahim - Wednesday, June 6, 2012 1:50 PM | Last reply by CoolDadTx - Monday, June 11, 2012 2:01 PM -
0 Votes
Immobile rows equivalent in ADO.NET
appended to end of row set." by using immobile rows database property. I need to use this so that all my inserted row order will be kept as is for the .mdb. Do we ...Answered | 1 Replies | 3098 Views | Created by get2ksh - Thursday, March 25, 2010 3:25 AM | Last reply by Miha Markic - Thursday, March 25, 2010 7:51 AM -
0 Votes
some tough SQL Server queries
3) Is there any equivalent of the Oracle 'valid' state in SQL Server? e.g. In Oracle 'valid' state is defined for views, indexes. Are thereUnanswered | 2 Replies | 7739 Views | Created by sachinsanjayfederer - Wednesday, October 4, 2006 11:30 AM | Last reply by BeeeT - Friday, October 6, 2006 10:29 AM -
2 Votes
parametrized Queries with ADO.NET
Hello blacksIBOT, First of all I am some-what familiar with OleDB commands I've been going through a lot of forums and see a ...Answered | 3 Replies | 1633 Views | Created by blacksaibot - Friday, May 18, 2012 4:45 PM | Last reply by Carmelo La Monica - Friday, May 18, 2012 6:51 PM -
0 Votes
ADO.NET - the forgotten methods
lightweight as possible while providing a consistent API for ADO.NET connectors. I myself call it the forgotten methods in the ADO.NET API. If you want something more than ...Discussion | 1 Replies | 3926 Views | Created by DavidThi808 - Sunday, February 28, 2010 6:06 PM | Last reply by Michael Sun [MSFT] - Monday, March 1, 2010 6:14 AM -
3 Votes
Various methods of DAO to ADO.NET conversion
equivalent Move methods and Find or Seek. The DataReader is the only class that operates in a connected state but of course is read/forward ...Answered | 4 Replies | 11304 Views | Created by M Nair - Friday, April 30, 2010 2:24 AM | Last reply by Martin_Xie - Friday, May 7, 2010 4:03 AM -
0 Votes
Listing SQL Queries executed via ADO.NET
executed on standard console. I want something like "show sql" for ADO.NET which will enlist SQLs to be executed. I don't want to ...Answered | 1 Replies | 1028 Views | Created by ShaileshBhagwat - Thursday, September 20, 2012 8:24 AM | Last reply by Fernando Soto - MCSD - Thursday, September 20, 2012 2:39 PM -
0 Votes
adodb.connection --> DBMS Name property equivalent in ADO.NET ...
the database that I connect. I wonder if there is any equivalent property in ADO.NET. The Server Version property of ODBCConnection object returns ...Answered | 1 Replies | 8191 Views | Created by prathap3 - Tuesday, May 16, 2006 1:35 PM | Last reply by Il-Sung Lee - MSFT - Tuesday, May 16, 2006 4:33 PM -
0 Votes
What is a "ADO.Net Methods" and "ADO.Net Properties"
Hi Vijay, This question is quite vague and broad for a forum. Here's an overview of ADO.NET httpAnswered | 1 Replies | 7272 Views | Created by VijaySK - Saturday, June 16, 2012 1:09 PM | Last reply by Bob Beauchemin - Saturday, June 16, 2012 4:36 PM -
0 Votes
Linq Equivalent of SQL Subquery
Hello all, Could some one please give me the linq equivalent of SQL Query : select ItemID from ...Answered | 3 Replies | 3962 Views | Created by Rithesh Krishnan - Sunday, March 4, 2012 5:57 PM | Last reply by Rithesh Krishnan - Monday, March 5, 2012 5:44 PM -
0 Votes
ADO.Net Data Access Methods
time and the page now seems somewhat slow as it already has a lot of processing work that happens. So, just wanted to know which is the best ...Answered | 2 Replies | 3246 Views | Created by Vineed - Friday, August 3, 2007 12:07 PM | Last reply by Vineed - Friday, August 3, 2007 1:26 PM -
0 Votes
The forgotten methods for ADO.NET
We've put the extensions we created up on codeplex at http://kailua.codeplex.com/ - I think most who use ADO.NET will find these useful.Discussion | 1 Replies | 3802 Views | Created by DavidThi808 - Monday, February 21, 2011 5:41 PM | Last reply by Alan_chen - Tuesday, February 22, 2011 12:57 AM -
0 Votes
Some queries
obsolete quickly. I have seen some of my Azure articles going obsolete in a time span of ...Proposed | 15 Replies | 1314 Views | Created by sakurai_db - Thursday, August 9, 2018 2:44 PM | Last reply by sakurai_db - Monday, August 13, 2018 3:20 PM -
0 Votes
Encryption of SQL Queries
Hi.I am running SQL select queries over a network from a SQL Server to a mySQL server by creating a linked server. I need data to be encrypted (nothing heavy), but ...Answered | 2 Replies | 11170 Views | Created by Karlo Swart - Thursday, November 3, 2005 4:44 PM | Last reply by Mulhall - Friday, November 18, 2005 12:36 PM -
0 Votes
Equivalent of NOCYCLE in SQL
". In SQL Server, the equivalent for "START WITH" is the anchor on a recursive CTE. The "CONNECT BY .. PRIOR" equivalent, is the UNION ALLed part ...Unanswered | 3 Replies | 6975 Views | Created by Pad M Lingam - Tuesday, September 15, 2009 10:54 AM | Last reply by Pad M Lingam - Thursday, September 17, 2009 12:11 PM -
0 Votes
Security of sql queries
Hello all good people! For my finish school exam i need to prepare application with VB.NET and database in sql server and i got this all. The next step is to catch ...Answered | 4 Replies | 1878 Views | Created by JimmyJimm - Sunday, May 20, 2012 8:25 PM | Last reply by JimmyJimm - Thursday, May 31, 2012 9:03 AM -
0 Votes
Simple methods to optimise SQL queries
was important what order the criteria were entered. They weren't sure themsleves but the idea was that starting from the bottom of the query you should add the criteria that ...Unanswered | 2 Replies | 6707 Views | Created by Matt_br - Monday, September 18, 2006 9:03 AM | Last reply by Matt_br - Monday, September 18, 2006 2:49 PM -
0 Votes
some c# equivalent in vb
thanks!it works but I have another request.... I have to do some call to webservice and I want have a "call code " more ...Answered | 5 Replies | 5412 Views | Created by magozeta - Friday, February 5, 2010 11:03 AM | Last reply by magozeta - Tuesday, February 9, 2010 9:10 AM -
0 Votes
adodb.connection --> DBMS Name property equivalent in ADO.NET ??
database that I connect. I wonder if there is any equivalent property in ADO.NET. The Server Version property of ODBCConnection object returns ...Answered | 4 Replies | 5937 Views | Created by prathap3 - Tuesday, May 16, 2006 1:30 PM | Last reply by prathap3 - Wednesday, May 17, 2006 6:13 AM - Items 1 to 20 of 2553186 Next ›
No announcements
