https://www.cnblogs.com/zhaosw/p/6088040.html 关于sql 拼接字符串的问题
Sql Server添加单引号
标签：ima 单引号 分享图片 一个 post color with com rom
Sql Server添加单引号
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;