Is numeric data type available in TD ?

Database

Is numeric data type available in TD ?

Hi,

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;
end if;
go

Like the one above. What is the use of "go" in it ?

Thank You!

Paddy

1 REPLY
Enthusiast

Re: Is numeric data type available in TD ?

duplicate post...