Hi, I got a big ASP website which created originally under the Access Database.
I converted the database to a SQL Server 2005 database.
My problem is that I got TONS of queries that falls because...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23536450.html
How do I re write this statement with a Group By clause to group the entries for each user.
SELECT tbl_nero_admin.username, tbl_nero_lead_history.datecreated, tbl_nero_company.companyname
FROM ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23798411.html
I am looking to create a web site but don't want to deploy mssql on my laptop. Can I do the site using Access and convert it to MSSQL?
I didn't know if there was a big difference in datatypes.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21496097.html
I am converting an Access to MSSQL and the code gives an error for date():
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error co...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21341443.htm...
Zones:
ASPDate Answered: 03/08/2005 Grade: A Views: 0
I have made an application in VBA(Access 2003) where I need to manupulate data in an MS-SQL database. I use ADO 2.8 Lib (db as New ADODB.Connection and Rec as new ADODB.Recordset ...)
The applicat...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2374...
