SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[#TEMPID1]') AND type in (N'U')sys.objects ,OBJECT_ID(N'[dbo].[#TEMPID1]'); type in (N'U');各部分什么意思?

来源:学生作业帮助网 编辑:作业帮 时间:2024/06/05 10:51:21

SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[#TEMPID1]') AND type in (N'U')
sys.objects ,OBJECT_ID(N'[dbo].[#TEMPID1]'); type in (N'U');各部分什么意思?

sys.ojects是一张表名,
oject_id是取对象的ID.
N表示使用Union Code,防止乱码.