declare @objid int,@objname char(40)set @objname = 'dbo.MyTestView'select @objid = id from sysobjects where id = object_id(@objname)select FID,FName ,'Column_name' = name ,'' AS 查看 ,'' AS 更新 ,'' AS 刪除 ,'' AS 新增 into MyWeight from syscolumns,MyWorker where id = @objid order by FID,FName

?

轉載于:https://www.cnblogs.com/armanda/p/3634297.html

總結

以上是生活随笔為你收集整理的生成两个表的笛卡尔积的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。