I'm currently working on a project where Stored Procedures from Sybase are being migrated to TD.
How do you convert "numeric(10)" data type in Sybase to equivalent TD data type ?
se10 numeric(10) null,
qId int null,
rId int null,
sId int null,
rfDate date null
And i noticed the use of "go" here and there in Sybase stored procs. I dont know why "go" is used in them ? Can someone help me with these pls. ?
if exists (select 1 from sysprocedure
where proc_name='get_se_data' and creator=suser_id('ABCD')) then
drop procedure ABCD.get_se_data;
Like the one above. What is the use of "go" in it ?