sharath kumar

sharath kumar

  • NA
  • 4
  • 2.3k

how to declare numeric datatype in sqlserver 2008

Feb 9 2013 1:01 AM
Incorrect syntax near '<'.

INSERT INTO [New2Hawaii].[dbo].[NH_MAST]

           ([NH_MODID]

           ,[NH_RCDTYP1]

           ,[NH_RCDTYP2]

           ,[NH_RCDTYP3]

           ,[NH_RCDT

           ,[NH_TEXT3]

           ,[NH_TEXT4]

           ,[NH_TEXT5]

           ,[NH_TEXT6]

           ,[NH_TEXT7]

           ,[NH_PIC1]

           ,[NH_PIC2]

           ,[NH_PIC3]

           ,[NH_PIC4]

           ,[NH_PIC5]

           ,[NH_PIC6]YP4]

           ,[NH_DTAKEY1]

           ,[NH_DTAKEY2]

           ,[NH_DTAKEY3]

           ,[NH_DTAKEY4]

           ,[NH_DTAKEY5]

           ,[NH_STATUS]

           ,[NH_TEXT1]

           ,[NH_TEXT2]

           ,[NH_PIC7]

           ,[NH_STRDT]

           ,[NH_EXPDT]

           ,[NH_PRICE]

           ,[NH_NUM1]

           ,[NH_NUM2]

           ,[NH_NUM3]

           ,[NH_NUM4]

           ,[NH_NUM5]

           ,[NH_NUM6]

           ,[NH_NUM7]

           ,[NH_NUM8]

           ,[NH_NUM9]

           ,[USER_ID]

           ,[TIME_STAMP])

     VALUES

           (<NH_MODID,   numeric(5,0),>

           ,<NH_RCDTYP1, nvarchar(max),>

           ,<NH_RCDTYP2, nvarchar(max),>

           ,<NH_RCDTYP3, nvarchar(max),>

           ,<NH_RCDTYP4, nvarchar(max),>

           ,<NH_DTAKEY1, nvarchar(50),>

           ,<NH_DTAKEY2, nvarchar(50),>

           ,<NH_DTAKEY3, nvarchar(50),>

           ,<NH_DTAKEY4, nvarchar(50),>

           ,<NH_DTAKEY5, nvarchar(50),>

           ,<NH_STATUS, char(10),>

           ,<NH_TEXT1, nvarchar(500),>

           ,<NH_TEXT2, nvarchar(500),>

           ,<NH_TEXT3, nvarchar(500),>

           ,<NH_TEXT4, nvarchar(500),>

           ,<NH_TEXT5, nvarchar(500),>

           ,<NH_TEXT6, nvarchar(500),>

           ,<NH_TEXT7, nvarchar(500),>

           ,<NH_PIC1, nvarchar(500),>

           ,<NH_PIC2, nvarchar(500),>

           ,<NH_PIC3, nvarchar(500),>

           ,<NH_PIC4, nvarchar(500),>

           ,<NH_PIC5, nvarchar(500),>

           ,<NH_PIC6, nvarchar(500),>

           ,<NH_PIC7, nvarchar(500),>

           ,<NH_STRDT, date,>

           ,<NH_EXPDT, date,>

           ,<NH_PRICE, numeric(5,2),>

           ,<NH_NUM1, nvarchar(100),>

           ,<NH_NUM2, nvarchar(100),>

           ,<NH_NUM3, nvarchar(100),>

           ,<NH_NUM4, nvarchar(100),>

           ,<NH_NUM5, nvarchar(100),>

           ,<NH_NUM6, nvarchar(100),>

           ,<NH_NUM7, nvarchar(100),>

           ,<NH_NUM8, nvarchar(100),>

           ,<NH_NUM9, nvarchar(100),>

           ,<USER_ID, datetime,>

           ,<TIME_STAMP, datetime,>)

 

 


Answers (1)