摘要：
--1. SqlServer2000数据库字典--表结构.sqlSELECT TOP 100 PERCENT --a.id, s CASE WHEN a.colorder = 1 THEN d.name ELSE '' END AS 表名, CASE WHEN a.colorder = 1 THEN isnull(f.value, '') ELSE '' END AS 表说明, a.colorder AS 字段序号, a.name AS 字段名, CASE WHEN COLUMNPROPERTY(a.id, a.name, 'IsIden 阅读全文
摘要：
use mastergoIF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[func_CompareDBobjectsReColumns_Temp]') AND xtype in (N'FN', N'IF', N'TF'))DROP FUNCTION [func_CompareDBobjectsReColumns_Temp]gocreate function [func_CompareDBobjectsReColumns_Temp](@objectID int) 阅读全文
摘要：
--第一步：创建表drop table OrderTablecreate table OrderTable(Id int identity,Name varchar(20),ParentId int)--第二步：插入模拟数据--顶级ParentId要置为nullinsert into OrderTable values('部门1',null)insert into OrderTable values('部门2',null)insert into OrderTable values('部门1-1',1)insert into OrderTable 阅读全文
摘要：
System.Net.NetworkInformation.Ping p = new System.Net.NetworkInformation.Ping(); System.Net.NetworkInformation.PingOptions options = new System.Net.NetworkInformation.PingOptions(); options.DontFragme... 阅读全文
摘要：
代码： select A.TypesID, case when SubTypesNameOrderNo not in (select min(SubTypesNameOrderNo) from Types where TypesName = A.TypesName) then '................' else isnull(TypesName,'') end +case whe... 阅读全文
摘要：
一、遇到问题：Server Error in '/' Application.--------------------------------------------------------------------------------Compilation Error Description: An error occurred during the compilation of a reso... 阅读全文
