在同一个数据库里操作不用加dbo的啊
select a.productnm AS 商品名,
b.NameC AS 药品名称
from project_product a,product b
where a.ProductId = b.ProductId
select a.productnm AS 商品名,
b.NameC AS 药品名称
from project_product a,product b
where a.ProductId = b.ProductId
如果是自己建立的角色,则不能用直接用dbo来调用
--作者:未知
--用法:exec ChangeObjectOwner 'crm','dbo'
--即可将所有nmkspro所有者的对象改为dbo所有
--运行成功后将提示:"注意: 更改对象名的任一部分都可能破坏脚本和存储过程。"
CREATE PROCEDURE dbo.ChangeObjectOwner
@OldOwner as NVARCHAR(128),--参数原所有者
@NewOwner as NVARCHAR(128)--参数新所有者
ASDECLARE @Name as NVARCHAR(128)
DECLARE @Owner as NVARCHAR(128)
DECLARE @OwnerName as NVARCHAR(128)DECLARE curObject CURSOR FOR
select 'Name' = name,
'Owner' = user_name(uid)
from sysobjects
where user_name(uid)=@OldOwner
order by nameOPEN curObject
FETCH NEXT FROM curObject INTO @Name, @Owner
WHILE(@@FETCH_STATUS=0)
BEGIN
if @Owner=@OldOwner
begin
set @OwnerName = @OldOwner + '.' + rtrim(@Name)
exec sp_changeobjectowner @OwnerName, @NewOwner
end FETCH NEXT FROM curObject INTO @Name, @Owner
ENDclose curObject
deallocate curObject
GO