How to put singl quote one an SQL query string.

Question

How to put singl quote one an SQL query string.

Answer 1

Hello guys i have solved the problem.
Umm... I have just declared a variable for the rows1,rows2, rows3 and cancatenate thembin the query. Although, this should have worked in the first place when I tried it didn't. It showed an error code regarding conversion of int to nvarchar.

The problem was that SQL string cancatening does not accept any int values.
Here is the working query.

Alter PROC spInsertRows
@TableName nvarchar(10)

AS
BEGIN

Declare @Row1 nvarchar(10)
Declare @Row2 nvarchar(10)
Declare @Row2 nvarchar(10)

Set @Row1='1'
Set @Row1='2'
Set @Row1='3'

Declare @query nvarchar(max)
Set @query= 'Insert into '+QUOTENAME(@TableName)+ 'Rows values ' +'('+(CONVERT(nvarchar(12),@Row1)+'),' +'('+(CONVERT(nvarchar(12),@Row2)+'),' +'('+(CONVERT(nvarchar(12),@Row3)+')'

Execute (query)

END

Answer 2

If i put two single quotes like ''row1'' it gives another error like conversion failed while converting varchar values "row1" to data type int

Answer 3

Sorry, parentheses left over
set query= 'Insert into' + @tablename+ ' (Rows) values ('''row1''', '''row2''' , '''row3''') '

Answer 4

Sintax is

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

Answer 5

I think a space is missing after the into

set query= 'Insert into ' + @tablename+ ' (Rows) values ('''row1''', '''row2''' , '''row3''') ;'

Answer 6

I am cancatening a sting like
set @query= 'Insert into' + @tablename+ ' (Rows) values (' row1'),('row2') , ('row3') '
So how should I do it here ?

Answer 7

Putting the single quote before row1 terminates the string.

Answer 8

Try with
set query= 'Insert into' + @tablename+ ' (Rows) values ('''row1'''),('''row2''') , ('''row3''') '

Answer 9

It gives an error saying incorrect syntax near row1

Answer 10

Yes but I want to put the row1, row2 and row3 in different rows and leave the other columns empty .

Answer 11

I am making a table with table name as a varible using paramaters from my other end of the app with 9 columns (Rows,C1,C2...c9) namely.

What I want to do is i want to put three rows in the column name Rows and leave the other columns as null. ☺️

Answer 12

Ok, is correct the parentheses for this case

INSERT INTO table_name (column_list)
VALUES
(value_list_1),
(value_list_2),
...
(value_list_n);

Has you tried putting ; at the end?

set query= 'Insert into' + @tablename+ ' (Rows) values ('''row1''', '''row2''' , '''row3''') ;'

Answer 13

Yes did just now it's not working 😔

Answer 14

It's there 😊 in my actual code. I think the problem is that the queries as String is doing something strange. It does not want to accept datatype as nvarchar. It works well on int type. If i put ...'insert into ' + QUOTENAME (@TableName)+ ' (Rows) Values (1),(2),(3)'

Answer 15

What is the data type of column Rows?

Answer 16

It's nvarchar

Answer 17

Sorry, just asking, do you really need to use NVARCHAR? if not, probably it's worth trying to use the VARCHAR instead (considering MySQL in tags).

Other possible workaround *might* be to check and ensure the character set for the respective field(s) have been properly configured.

https://stackoverflow.com/questions/2214901/mysql-equivalent-data-types?lq=1