问题描述
特定存储过程在我的机器上与老板机器上的工作方式(在我的机器上工作，在他的机器上失败)有很大的不同.
在存储过程中为以下行:
IF是否存在(SELECT * FROM dbo.sysobjects，其中id = object_id(N''[dbo].[t]'')和OBJECTPROPERTY(id，N''IsUserTable'')= 1)
在老板计算机上的Microsoft SQL Server Management Studio Express中，sysobjects显示为绿色(这似乎是用于注释的颜色)，而在我的计算机上，sysobjects显示为黑色.另一个区别是，在我的计算机上，N''[dbo].[t]''和N''IsUserTable''中的N是黑色，而在其上它是红色.我认为颜色与所显示内容的特征有关，但不知道为什么这两个过程应该有所不同.
问:知道会发生什么吗?为什么程序显示方式有所不同?
谢谢.
There is a significant difference in the way a particular stored procedure works on my machine vs. my boss''s machine (works on mine, fails on his).
In the stored procedure is the following line:
IF exists(SELECT * FROM dbo.sysobjects WHERE id = object_id(N''[dbo].[t]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)
In Microsoft SQL Server Management Studio Express on my boss''s machine, sysobjects is displayed in green (that seems to be the color used for comments) and on my machine sysobjects is displayed in black. Another difference is that on my machine the N in N''[dbo].[t]'' and N''IsUserTable'' is black while on his it is red. I assume the color relates to a characteristic of what is being displayed but have no idea why the 2 procedures should be different.
Q: Any idea what might be going on? Why the difference in how the procedure is displayed?
Thank you.
推荐答案
这篇关于dbo.sysobjects在Microsoft SQL Server Management Studio Express中显示为注释的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！