摘要：Create table #temp([id] int,[name] nvarchar(1))Insert #tempselect 1,N'a' union allselect 1,N'b' union allselect 2,N'c' union allselect 2,N'd' union al... 阅读全文

摘要：EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'EXEC sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL'EXEC sp_MSForEachTable 'DELETE ... 阅读全文

摘要：SQL SERVER查看所有表名：select name from sysobjects where type='U'查询表的所有字段名：Select name from syscolumns Where ID=OBJECT_ID('表名')ACCESS/// /// 取所有表名 //... 阅读全文

摘要：C#获取当前应用程序所在路径及环境变量 一、获取当前文件的路径 string str1=Process.GetCurrentProcess().MainModule.FileName;//可获得当前执行的exe的文件名。 string str2=Environment.CurrentDirector 阅读全文