Search results for query: *

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. How Can I convert a Access Var to SQL Server Var? Thanks

Hi. I want to relation one table with another one from other database (Do not import table). How Can I do that? Thank you

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. How can I make a personal error message with T-SQL code??? Besides, How Can I insert variable data in a personal error message? Thanks...

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.

Hi. I need to order a table by a field permanently, whenever I enter a new data in this table. 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...