DECLARE @col VARCHAR(9) ,
DECLARE @val VARCHAR(100)
SET @col = 'firstname'
EXEC('SELECT * FROM table WHERE firstname like ''%' +@val+'%'' ORDER BY '+@col)
GO
1200字范文，内容丰富有趣，写作的好帮手！
时间：2021-08-02 11:57:58
DECLARE @col VARCHAR(9) ,
DECLARE @val VARCHAR(100)
SET @col = 'firstname'
EXEC('SELECT * FROM table WHERE firstname like ''%' +@val+'%'' ORDER BY '+@col)
GO
mysql单引号转义_sql语句中使用单引号\'作为转义字符
2020-09-13
2020-05-21
2019-01-17
使用SQL生成SQL语句时单引号的转义处理之q\'{}\'方法
2020-11-21
2024-09-07
2024-09-07
2024-09-07
2024-09-07
2024-09-07
2024-09-07
2024-09-07
2024-09-07
2024-09-07
2024-09-07