随笔分类 -  MSSQL

MSSQL工作经验分享
摘要:--废话不多说,直接上干,先按照下面的语句创建一个 名为:prc_TableField 的存储过程 /****** Object: StoredProcedure [dbo].[prc_TableFieldDesc] Script Date: 02/26/2021 15:55:49 ******/ 阅读全文
posted @ 2021-04-04 20:45 DavidChild 阅读(247) 评论(0) 推荐(0)
摘要:with pb1 as ( select c.id, c.pid, c.pname, c.peopletype, c.ptype from sys_pbinstance c with(nolock) ) , pb2 as ( select * from pb1 where id='2031ec0f- 阅读全文
posted @ 2021-04-04 20:04 DavidChild 阅读(731) 评论(0) 推荐(0)