Lab Sql

i'm trying to use the code below to copy data from a sql (2008 r2) table to multiple sheets in … Read more Excel Vba Copyfromrecordset Slows When Copying Over 100 Columns

I have a series of three tables which I would like to join together using ADODB in an Excel VBA app… Read more Nested Join In Excel Vba (adodb) Results In "join Expression Not Supported"

Using TADOConnection class to connect to SQL server 2005 db. Having ConnectionTimeOut := 5; // seco… Read more Ado Connection Timeout Problem

This error showed when I tried to select on an empty table in MS SQL Server 2005: 'either BOF o… Read more Delphi - Either Bof Or Eof Is True, Or The Current Record Has Been Deleted

I am getting an 'Object Was Open' error when opening a TADOQuery which returns a large data… Read more "object Was Open" Error Using Delphi, Sql Server And Ado

I am trying to create a dynamic client excel file(s) that is linked to a 'server' master ex… Read more Vba Ado Update Query

I have been told that SQL Native Client is supposed to be faster than the OLEDB drivers. So I put t… Read more Delphi With Sql Server: Oledb Vs. Native Client Drivers

I am using the Stored procedure 'sp_Missingdata' to get the data and to display in the MSFl… Read more Run-time Error '3704' Operation Is Not Allowed When The Object Is Closed In Vb6 While Using Sp Using Temp Tables

I have an Insert statement (Stored Procedure) that returns the SCOPE_IDENTITY() after insert, howev… Read more Returning Scope_identity() Using Adodb.command

I'm talking about Delphi + ADO + MSSQL. Okay, I know that queries with parameters are quite saf… Read more Is Fieldbyname Injection-safe?

I have been searching for a solution for a while, and I find myself coming up empty handed. The que… Read more Using Sql To Query An Excel Worksheet Without A Header Row

Can anybody help me with this please? The problem: I have the below code in a module which works pe… Read more Excel Vba Ado Cutting Decimals (possible Bug In Ado?)

I want to do the following. 1) Create a database. 2) Run a script when creates tables, stored pro… Read more How To Run A Database Script File From Delphi?

This question is part in a series of bugs in the Microsoft ODBC driver: ODBC driver fails to rai… Read more Reading Columns Out Of Order Returns Incorrect Values (sql Server Odbc Driver)

I'm trying to upload some data into a SQL database from a spreadsheet. I'm Using the code f… Read more Adodb Connection To Upload Data To Sql Using Bind Variables

Here is a minimal repro example. Database: CREATE TABLE temp (x int IDENTITY(1, 1), y int); Code (… Read more Server-side Forward-only Cursor Breaks @@identity

I run SQL in excel using ADO in excel-VBA. And the results are displayed on an excel worksheet. The… Read more The Sql Result Is Inaccurate Because Of Wrong Sql Date Comparison Setting

There are two worksheets in same workbook that have the same structure-same field names. for examp… Read more How To Combine Records From Different Tables?

I am using SQLServer EXPRESS on a local PC to house the database and connecting with an ADO records… Read more Difference Between Ado Client-side Vs Server-side Cursor When The Sql Server Database Is Local?

I have a Delphi app where I display a list of games that have been played from a query like this: s… Read more Adodataset Deleting From Joined Table