declare @pids varchar(max)=''
select @pids=convert(varchar(10),pid)+','+@pids from product where pname like '%red%'
select @pids
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAooAAABZCAIAAAA2I5J...
此文章为转载
使用CASE来重新定义数值类型
SELECT id,title,
(CASE date WHEN '0000-00-00' THEN '' ELSE date END) AS date
FROM your_table
SELECT id,title,
(CASE status WHEN 0 THEN 'o...
--实际只会更新一条。可有效防止误操作、特别是操作线上正式数据时。
UPDATE TOP(1) Table2 SET Culumn1='value'WHERE id IN(269102,269104)
<OrderKey>000000102153003,</OrderKey><OrderKey>...