servser专题

SQL-servser完全卸载(全)

SQL-servser完全卸载(全) 转载: http://blog.csdn.net/weixin_43808666/article/details/87864369

sql servser游标和递归工作中案例

---游标 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

查询sql servser的视图、函数和存储过程、以及表和列

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