Hi
DECLARE @OpgBalance Double
CREATE TABLE #temp(DocDate dateTime,VoucherNo nvarchar(20),shift nvarchar(2),
Description nvarchar(200),Debit numeric(19,6),Credit numeric(19,6),Balance numeric(19,6))
Thanks
Hi
DECLARE @OpgBalance Double
CREATE TABLE #temp(DocDate dateTime,VoucherNo nvarchar(20),shift nvarchar(2),
Description nvarchar(200),Debit numeric(19,6),Credit numeric(19,6),Balance numeric(19,6))
Thanks
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Amit MohantyPosted Aug 17, 2022, 7:23 AM
Double is not a datatype in Sql Server. You can use float/decimal/numeric.
Nitin SontakkePosted Aug 17, 2022, 12:52 PM
Vishal YelvePosted Aug 17, 2022, 7:05 AM