标签: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 ----查询某...