How to insert multiple columns in sql database

Help Studio
,
1

I want to insert multiple columns in SQL like clientid,clientname,clientamount and so on…
i used this sql query
Insert into TableName (Column1, Column2, Column3),(Value1, Value2, Value3);
but i got some error.can u please explain in detail.

Thanks.

1 Like
2

@jaranrikki_17

use this query

INSERT INTO TableName (Column1, Column2, Column3…) VALUES (‘Value1’, ‘Value2’, ‘Value3’…);

use quotes in values

Cheers…!

1 Like
Forum Engagement Daily Reports
3

Hi

Welcome to UiPath forum

INSERT INTO MyTable ([First columnName], [Last columnName]) VALUES (‘FirstName’, ‘LastName’)

Mention the value in single quotes and try

Hope this helps

Cheers @jaranrikki_17

1 Like
4

Tq @Dilli_Reddy

Its working

1 Like
5

Tq for your reply@Palaniyappan
Its working

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.