Incorrect Syntax near Create Expecting ID

• jsshivalik

  SSChasing Mays

  Points: 612

  More actions

  August 17, 2022 at 4:53 am

  #4077233

  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

• DesNorton

  SSC-Insane

  Points: 24073

  More actions

  August 17, 2022 at 5:35 am

  #4077242

  DOUBLE is not a valid data type in SQL

  https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16

  ---

  How to post data/code on a forum to get the best help.