摘要：
office 07：select * from OpenDataSource('Microsoft.ACE.OLEDB.12.0','Data Source=路径;Extended Properties=EXCEL 12.0')...[sheet1$] ;select *from OpenDataSource('Microsoft.ACE.OLEDB.12.0','Text;HDR=Yes;DATABASE=H:\')...[csv名字#csv]office 03：select * from OpenDataSource(' 阅读全文
摘要：
1.哪个表（视图、存储过程）中有这个字段Select Object_Name(ID) 表名,Name 字段名 From Syscolumns Where Name like '%字段名%'2.显示出这个字段的类型（表、视图）selecta.Name as 表名,b.Name as 列名,c.Name as 类型,b.max_length as 字节数,b.Precision as 整数位,b.Scale as 小数位from Sys.tables ainner join Sys.columns b on a.object_id=b.object_idinner join sys 阅读全文
摘要：
Msg 468, Level 16, State 9, Line 11Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.原因：数据库中的varchar排序规则不同，如果是数字类型的就没有问题。解决办法：点击两个数据库的属性，看里面的Collation是否一样可在在join条件后面加上collate database_default 阅读全文