34,593
社区成员
发帖
与我相关
我的任务
分享
select * from table_a union all select * from table_b;
select * from table_a union select * from table_b;
UPDATE [m_Media] SET Postbuy_Sofres=B.Name
from
(
SELECT '1' AS ID,'A' AS Name
) B where B.ID=[m_Media].Media_ID
delete a
select * from a inner join b on a.id=b.id;
select * from a left join b on a.id=b.id;
select * from a right join b on a.id=b.id;
select * from a full join b on a.id=b.id;
select * from a,b where a.id=b.id;
declare @sql varchar(10)
declare @楼主 nvarchar(100)
declare @分数 int
set @楼主 = 'zhangsong1st'
if @分数 < 10
kill @楼主
select getdate()