Hi can someone help me get this syntax correct.
I am wanting to declare the field 'nett' ready for a stored procedure.
Nett could be a bigger number as 9999999.
This does not work. Could someone give me an example of this working.
and what data_type to use for storeing values like nett, cost, gross, (big numbers)
A what i have doesnt seem to work.
DECLARE nett BIGINT(10000000) default 0 ;