Hi. I need to insert a great number of records in a table (10 000). I did a Stored procedure, it runs well. This operation was done in 2 minutes, but now, the operation does in hours (I've erased this records. Insert another 10 000 records again) How could I do? I don't understand. Thanks
Oscar
Hi. I still problems with MS-Access and SQl server 7.0. I want execute a stored procedure from Access. I declare the variables in Access, and I want to use these variables as input parameters to Stored Procedure. This is the code:
Dim param1 As ADODB.Parameter
Dim param2 As ADODB.Parameter...
Hi. I want this:
- Storing a value in a variable declared in Access (I work with file *.adp) Example: Dim Ident as integer
- Using THIS VALUE in a Stored Procedure as a input parameter. I don't know how to do it!!! Help me please!!!
Thanks
Mauricio
How Can I to convert a variable from SQL Server to Access?
Variable is for example:
In SQL SERVER:
Declare @Ids as Int
In Access (Visual Basic For Applications):
Dim Ids As integer
I need to work with a input value from Access, and this value executes a stored Procedure.
Excuse me, but my...
Hi. I have a problem with the command PRINT. I work with Acess 2000 with a project (*.adp). But the message with PRINT is not displayed in a client's screen. I don't want to use RAISERROR. Please help me. Thanks.
OSCAR N
Hi. I have 2 different databases. I need the information from the first database to another one. ¿Can I get this information through SQL instruction? Please give me an example. Thanks.
Good afternoon.
I want copy the identity identifier field from a table (TblEmple) to another one (TblTercero). I used this trigger:
Declare @IntCodigo as int
Select @IntCodigo = IdsEmpId
from inserted
insert into tbltercero (IntTerEmple)
values (@intCodigo)
This trigger functions, but I use...
Good afternoon.
I want copy the identity identifier field from a table (TblEmple) to another one (TblTercero). I used this trigger:
Declare @IntCodigo as int
Select @IntCodigo = IdsEmpId
from inserted
insert into tbltercero (IntTerEmple)
values (@intCodigo)
This trigger functions, but I use...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.