在这一段 Select a.object_id,object_name From t a Where Not Exists(Select 1 From t Where object_id=a.object_id And LevelNo>a.LevelNo) And Not Exists(Select 1 From sys.extended_properties Where major_id=a.object_id And minor_id=0 And class=1 And Name=N'microsoft_database_tools_support') And (Exists(Select 1 From @Tmp Where name=a.object_name) Or Not Exists(Select 1 From @Tmp)) Group By object_id,object_name,LevelNo Order By LevelNo Desc 出现 语句被终止。完成执行语句前已用完最大递归 32767。 设置为0 则超时,这句能改造嘛
封装了Model??这样的话可以用反射机制去解读Model类里的各属性
从SQL中获得表结构,都不知道什么结构怎么获取呢?
select *然后遍历DataTable???
这样也行
这个差不多 不过有没有直接可以生成create table脚本的程序
Select a.object_id,object_name
From t a
Where Not Exists(Select 1 From t Where object_id=a.object_id And LevelNo>a.LevelNo) And
Not Exists(Select 1 From sys.extended_properties Where major_id=a.object_id And minor_id=0 And class=1 And Name=N'microsoft_database_tools_support')
And (Exists(Select 1 From @Tmp Where name=a.object_name) Or Not Exists(Select 1 From @Tmp))
Group By object_id,object_name,LevelNo
Order By LevelNo Desc
出现
语句被终止。完成执行语句前已用完最大递归 32767。
设置为0 则超时,这句能改造嘛