STORED PROCEDURE
Posted: Wed 28 Jun 2006 03:12
Which is the correct way of calling a stored procedure?
My Table is Big enough Has 100,000 Records.
Example:
CREATE PROCEDURE `syscoi7`.`modelos`()
DETERMINISTIC
BEGIN
Select Empresa, Codigo, ClaveProveedor, Descripcion, Descripcion2,
Ubicacion, Corrida, Color, Descuento, Precio1, Precio2, Precio3,
Precio4, Precio5, Precio6, Precio7, Precio8, Precio9, Precio10
From Productos ;
END
MyDac 4.30.1.15 Delphi 7
Tanks !!!!
My Table is Big enough Has 100,000 Records.
Example:
CREATE PROCEDURE `syscoi7`.`modelos`()
DETERMINISTIC
BEGIN
Select Empresa, Codigo, ClaveProveedor, Descripcion, Descripcion2,
Ubicacion, Corrida, Color, Descuento, Precio1, Precio2, Precio3,
Precio4, Precio5, Precio6, Precio7, Precio8, Precio9, Precio10
From Productos ;
END
MyDac 4.30.1.15 Delphi 7
Tanks !!!!