I want to know if it is possible to retrieve a row no. for each row of a SQL
Statement, row no below is not a part of the Table, but needs to be
generated by the SQL Statement ???
Row Name State City
1 JJJ CA YYy
2 XXX VA Ayyaya
3 aaa OH Anabab
Re: Which identity? ... > Some postings I read suggested using MAXto retrieve the inserted record ... > each of these 3 SQL features?... Another way to do it if using the .AddNew method on a Jet based ADO...Dim rsTest As ADODB.Recordset ... (microsoft.public.access.queries)
Re: White Paper on How MSAccess interacts with SQL Server Back End ... these keys to retrieve the other fields from the tables by group of 10 rows. ... or with VBA functions that Access cannot translate directly into T-SQL ...Sylvain Lafontaine, ing. ... my SQL 2000 db using ACC2003 as the front end via linked tables. ... (microsoft.public.access.adp.sqlserver)
Re: VS.NET 2003, ADO.NET 1.1 and Access 2000: Getting a Concurrency violation ... I am using an Access update query, with parameters, for the ... Then my app goes against a SQL... OleDbDataAdapter that I use to retrieve the original table from the ... So your named parameters for SQL Server suddenly become anonymous ... (microsoft.public.dotnet.framework.adonet)
Re: Linq. Select. ... The SQL way is to order by a GUID and select the top 10 rows. ... Unfortunately, SQL is made to retrieve the rows you specify, not just ... Lead developer of LLBLGen Pro, the productive O/R mapper for .NET ... My .NET blog: http://weblogs.asp.net/fbouma ... (microsoft.public.dotnet.languages.csharp)
