Hi,
please give me the terms and conditions for oracle10g production license
Regards,
vijaya
vijjibalu
Last Activity: Aug 27 '08, 06:21 AM
Joined: Aug 12 '08
Location:
-
oracle10g production license
-
Hi, here is the procedure i created in mysql as replacement of the above mssql one.
[code=mssql]
CREATE PROCEDURE TABLE_DEPEND_IN SERT_ORDER()
begin
CREATE TEMPORARY TABLE TABLE_DEPEND_OR DER_SUMMARY (
TABLE_NAME varchar(128),
SORT_ORDER int
);
INSERT INTO TABLE_DEPEND_OR DER_SUMMARY call TABLE_DEPEND_OR DER ('T','F')
SELECT TABLE_NAME FROM TABLE_DEPEND_OR DER_SUMMARY ORDER... -
how to insert data by calling procedure
Hi all,
as part of my project requirement we are migrating procedures from mssql to mysql
below is the code in mssql
[code=mysql]
CREATE PROCEDURE TABLE_DEPEND_IN SERT_ORDER
AS
CREATE TABLE #TABLE_DEPEND_O RDER_SUMMARY (
TABLE_NAME varchar(128),
SORT_ORDER int
)
INSERT INTO #TABLE_DEPEND_O RDER_SUMMARY EXEC TABLE_DEPEND_OR DER 'F'
SELECT TABLE_NAME FROM #TABLE_DEPEND_O RDER_SUMMARY... -
How to use the RETURN keyword in a MySQL Stored Procedure?
Hi all,
as part of my project requirement we are migrating procedures from mssql to mysql
below is the code in mssql
[code=mssql]
DECLARE
"@rowcnt" int
select"@rowcnt" = count(*) from tg_services WHERE name ="@name"
IF (@rowcnt <> 0)
BEGIN
-- print"@name" + ' already exists in the tg_services table'
...Last edited by Atli; Aug 16 '08, 05:50 AM. Reason: Added [code] tags and improved the thread title slightly.
No activity results to display
Leave a comment: