Sql Server添加单引号
时间：2021-07-01 10:21:17
帮助过：13人阅读
TOP 1 ‘‘‘‘+CONVERT(
nvarchar(
50),keyid)
+‘‘‘‘ name1
FROM Rel_ProductStockLock
with (nolock)
WHERE KeyId
IS NOT NULL
SELECT TOP 1 ‘‘‘‘+CONVERT(
nvarchar(
50),keyid)
+‘‘‘,‘ name2
FROM Rel_ProductStockLock
with (nolock)
WHERE KeyId
IS NOT NULL
SELECT ‘‘‘‘ name3;
SELECT ‘123‘‘‘ name4;
SELECT ‘123‘+‘‘ name5;
SELECT ‘"123"‘ name6;
SELECT TOP 1 ‘123‘+AreaName name7
FROM dbo.Dim_Area;
SELECT TOP 1 ‘123‘‘‘+AreaName name8
FROM dbo.Dim_Area;
SELECT TOP 1 ‘123‘‘‘+AreaName
+‘‘ name9
FROM dbo.Dim_Area;
SELECT TOP 1 ‘123‘‘‘+AreaName
+‘‘‘‘ name10
FROM dbo.Dim_Area;
https://www.cnblogs.com/zhaosw/p/6088040.html 关于sql 拼接字符串的问题
Sql Server添加单引号
标签：ima 单引号 分享图片 一个 post color with com rom
