se10 numeric(10) null,
qId int null,
rId int null,
sId int null,
rfDate date null
How do i convert numeric(10) to equivalent TD data type ?
if exists (select 1 from sysprocedure
where proc_name='get_se_data' and creator=suser_id('ABCD')) then
drop procedure ABCD.get_se_data;
In Sybase I believe NUMERIC datatype is same as DECIMAL. Teradata has DECIMAL datatype, you can specify the precision and scale for DECIMAL as per requirement.
I think NUMERIC(10) should be similar to DECIMAL(10,0) in Teradata.
Regarding your second question... GO is generally used as as batch separator in a script which ensures that the all the SQL before the GO statement will finish before proceeding further. Semicolon (;) has the same functionality in most of the dbs...