---游标 declare @dname nvarchar(255) declare cur cursor for select left(单位,charindex('|',单位)-1) from( select distinct(单位) 单位 from view_sys_data_院内科室) temp open cur fetch next from cur into @dname whi
SELECT NAME as VIEW_NAME, OBJECT_DEFINITION (id) as VIEW_DEFINITION,'none' as CHECK_OPTION, '0' as IS_UPDATABLE,* FROM sysobjects WHERE xtype='V' SELECT NAME as VIEW_NAME, OBJECT_DEFINITION (object_i