标签:SqlServer

SqlServer中常用的sql(删除类)

1 删除表中重复的数据,但保留重复数据中的一条 delete from kk_attachs where (attachguid) in (select attachguid from kk_attachs group by attachguid h...

常用sql(查询类-2)

1、查询表中image类型字段的文本值 ----将此字段进行转换后查询 select CAST(CAST(content AS VARBINARY(MAX)) AS VARCHAR(MAX)) from kk_Attachs ----查询某...