摘要:
select * from (select *,row_number() over(partition by PropertyRoofBeamID order by PropertyRoomID desc) as Sequencecount from PropertyRoom)t1 where Se 阅读全文
摘要:
select c.name as [字段名],t.name as [字段类型] ,convert(bit,c.IsNullable) as [可否为空] ,convert(bit,case when exists(select 1 from sysobjects where xtype='PK' a 阅读全文