Sql Server-How to insert values to database?

[jeenajos]

Hi all,
while writing a query to insert values into a database it gave me an error.

Query goes like this:
Insert into [DatabaseName].[dbo].[DB]
([Type]
,[Message]
,[Category])
Values
(<Cargo,Varchar(50),>
,<Shipping experts ABC.Call-xx-xxxx,varchar,>
,<Cargo,Varchar(50)>)

Its showing the error "Incorrect syntax near '<' "
Can anyone help???

Thanks Jeen

[iburyak]

Try this:

Insert into [DatabaseName].[dbo].[DB]
([Type]
,[Message]
,[Category])
Values
('Cargo',
'Shipping experts ABC.Call-xx-xxxx',
'Cargo')

I could only guess what are you trying to do with this mess.
Hope your table name is DB.

[jeenajos]

thank You for your solution. It worked.

Jeen