maotou526的博客

注册表输入路径：计算机\HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Server Management Studio\18.0_IsoShell\DataProjectPS：如果没有DataProject，那么用SSMS操作一下表，添加表字段保存后再去注册表查看就有了随后找到红框所示的，调整相应的值即可（默认1,2,6;把它改成1,2,6,7,17;）数字说明：1:Column Name2:Data Type3:Length4:Precision5:S

工具=》选项=》设计器=》表设计和数据库设计器

SELECT CASEWHEN t.[type] = ‘U’ THEN‘表’WHEN t.[type] = ‘V’ THEN‘视图’END AS ‘类型’,SCHEMA_NAME(t.schema_id) + ‘.’ + t.[name] AS ‘(表/视图)名称’,i.[name] AS 索引名称,SUBSTRING(column_names, 1, LEN(column_nam...

SELECT f.name AS '关系名称',　　　　OBJECT_NAME(f.parent_object_id) AS '表名称',　　　　COL_NAME(fc.parent_object_id,fc.parent_column_id) AS '字段名称',　　　　OBJECT_NAME (f.referenced_object_id) AS '关联表名称',　　　　COL_NAM...

select * from INFORMATION_SCHEMA.COLUMNSwhere TABLE_NAME in ( select name from sysobjects where type = ‘U’)AND COLUMN_NAME =‘Unit’

BULK INSERT dbo.SysReferenceFROM 'E:\testbulk.txt'WITH(FIELDTERMINATOR = ',',ROWTERMINATOR = ';')FIELDTERMINATOR ——字段分割ROWTERMINATOR——行分割txt文档格式CS_OrderDA,15,12,204,null,CP_...