34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [dbo].[tb](
[A] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[B] [datetime] NULL,
CONSTRAINT [PK_tb] PRIMARY KEY CLUSTERED
(
[A] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
select A from tb where a=aStr
if exists(select * from 表where charindex('字符',字段)>0)
print '字符存在'
else
print '字符不存在'