数据库|mysql教程
刷新,SQL,Server,所,视图,函数,存储,过程,脚
数据库-mysql教程
php商城系统源码,新手可以用vscode吗,ubuntu16软件源,idea的tomcat版本,Django与sqlite,ps网页设计培训学校,服务器装系统激活后起不来,滚动条样式插件,前端框架vau,网站更新爬虫,php 打开错误提示,英文SEO外链专员招聘,SpringBoot被挂马,织梦网站打开速度慢,php实现网页即时对话,opencart 2.3主题模板,dede后台进不去500,web手机端页面模版,超市管理系统窗体,希尔伯特黄变换 程序lzw
此脚本用于在删除或添加字段时刷新相关视图，并检查视图、函数、存储过程有效性。 无 –视图、存储过程、函数名称DECLARE @NAME NVARCHAR(255);–局部游标DECLARE @CUR CURSOR –自动修改未上状态为旷课SET @CUR=CURSOR SCROLL DYNAMIC FOR SELECT NAME FROM
猜水果源码,vscode调试进程,ubuntu系统搭建应用,cmd 删除tomcat,sqlite 排序名次,多选select插件,现在前端的框架,并行网络爬虫,php 课程,seo 链接优化,各国语言网站源码,手机网页下拉就刷新,免费的织梦响应式模板,注册页面模板 jq,图书信息管理系统java课程设计,背单词小程序源码lzw
收款码三码合一源码,ubuntu编辑更新源,tomcat 重复初始化,爬虫程序慢,老虎机 源码 PHP,seo浙江lzw
此脚本用于在删除或添加字段时刷新相关视图，并检查视图、函数、存储过程有效性。
.CodeEntity .code_pieces ul.piece_anchor{width:25px;position:absolute;top:25px;left:-30px;z-index:1000;}.CodeEntity .code_pieces ul.piece_anchor li{width:25px;background: #efe;margin-bottom:2px;}.CodeEntity .code_pieces ul.piece_anchor li{border-left:3px #40AA63 solid;border-right:3px #efe solid;}.CodeEntity .code_pieces ul.piece_anchor li:hover{border-right:3px #40AA63 solid;border-left:3px #efe solid;}.CodeEntity .code_pieces ul.piece_anchor li a{color: #333;padding: 3px 10px;}.CodeEntity .code_pieces .jump_to_code{visibility:hidden;position:relative;}.CodeEntity .code_pieces .code_piece:hover .jump_to_code{visibility:visible;}.CodeEntity .code_pieces .code_piece:hover .jump_to_code a{text-decoration:none;}.CodeEntity .code_pieces h2 i{float:right;font-style:normal;font-weight:normal;}.CodeEntity .code_pieces h2 i a{font-size:9pt;background: #FFFFFF;color:#00A;padding: 2px 5px;text-decoration:none;}
--视图、存储过程、函数名称DECLARE @NAME NVARCHAR(255);--局部游标DECLARE @CUR CURSOR --自动修改未上状态为旷课SET @CUR=CURSOR SCROLL DYNAMIC FOR SELECT NAME FROM DBO.SYSOBJECTS WHERE NAME NOT IN (SYSCONSTRAINTS,SYSSEGMENTS)AND(OBJECTPROPERTY(ID, NIsView) = 1--视图OR OBJECTPROPERTY(ID,NIsProcedure) = 1--存储过程OR OBJECTPROPERTY(ID,NIsScalarFunction) = 1--标量函数OR OBJECTPROPERTY(ID,NIsTableFunction) = 1--标题函数OR OBJECTPROPERTY(ID,NIsInlineFunction) = 1--内联函数);OPEN @CUR;FETCH NEXT FROM @CUR INTO @NAMEWHILE (@@FETCH_STATUS=0)BEGINDECLARE @OldText NVARCHAR(MAX);DECLARE @NewText NVARCHAR(MAX);--读取创建脚本，当脚本超长时分成多条记录时合并SELECT @OldText=@OldText + CHAR(10) + CHAR(13) + RTRIM(TEXT) FROM SYSCOMMENTS WHERE ID = OBJECT_ID(@NAME);--将创建脚本替换为更新脚本SET @NewText=REPLACE(@OldText,NCREATE VIEW,NALTER VIEW);SET @NewText=REPLACE(@NewText,NCREATE PROCEDURE,NALTER PROCEDURE);SET @NewText=REPLACE(@NewText,NCREATE FUNCTION,NALTER FUNCTION);BEGIN TRYEXEC(@NewText);END TRYBEGIN CATCHPRINT N---------------------------------------------------------------------------;PRINT @NAME + N : + ERROR_MESSAGE();--PRINT @OldText;PRINT N---------------------------------------------------------------------------;END CATCHFETCH NEXT FROM @CUR INTO @NAMEENDCLOSE @CUR;DEALLOCATE @CUR;
CREATE PROCEDURE RefreshAllView ASDECLARE MyCursor CURSORFOR select Name from dbo.sysobjects where OBJECTPROPERTY(id, NIsView) = 1 and (not name in (sysconstraints,syssegments))DECLARE @name varchar(40)OPEN MyCursorFETCH NEXT FROM MyCursor INTO @nameWHILE (@@fetch_status -1)BEGIN IF (@@fetch_status -2) begin exec sp_refreshview @name end FETCH NEXT FROM MyCursor INTO @nameENDCLOSE MyCursorDEALLOCATE MyCursor
select name from sysobjects where xtype=TR --所有触发器select name from sysobjects where xtype=P --所有存储过程select name from sysobjects where xtype=V --所有视图select name from sysobjects where xtype=U --所有表
SELECT表名=case when a.colorder=1 then d.name else \ end,表说明=case when a.colorder=1 then isnull(f.value,\) else \ end,字段序号=a.colorder,字段名=a.name,标识=case when COLUMNPROPERTY( a.id,a.name,IsIdentity)=1 then √else \ end,主键=case when exists(SELECT 1 FROM sysobjects where xtype=PK and name in (SELECT name FROM sysindexes WHERE indid in(SELECT indid FROM sysindexkeys WHERE id = a.id AND colid=a.colid))) then √ else \ end,类型=b.name,占用字节数=a.length,长度=COLUMNPROPERTY(a.id,a.name,PRECISION),小数位数=isnull(COLUMNPROPERTY(a.id,a.name,Scale),0),允许空=case when a.isnullable=1 then √else \ end,默认值=isnull(e.text,\),字段说明=isnull(g.[value],\)FROM syscolumns aleft join systypes b on a.xusertype=b.xusertypeinner join sysobjects d on a.id=d.id and d.xtype=U and d.namedtpropertiesleft join syscomments e on a.cdefault=e.idleft join sys.extended_properties g on a.id=g.major_id and a.colid=g.minor_idleft join sys.extended_properties f on d.id=f.major_id and f.minor_id=0--where d.name=course --如果只查询指定表,加上此条件order by a.id,a.colorder
Select o.Name As ObjectsName , c.name As ColumnsName , t.name As ColumnsType , c.length As ColumnsLengthFrom SysObjects As o , SysColumns As c , SysTypes As tWhere o.type in (u,v) And o.id = c.id And c.xtype = t.xtypeOrder By o.name , c.name , t.name , c.Length
如果觉得《刷新SQL Server所有视图 函数 存储过程》对你有帮助，请点赞、收藏，并留下你的观点哦！
