文章分类 - 数据库技术

摘要：·SQL Server ODBC Standard Security: "Driver={SQLServer};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;" Trusted connection: "Driver={SQLServer};Server=Aron1;Database=p... 阅读全文

posted @ 2006-02-28 15:13 关中刀客阅读(134) 评论(0) 推荐(0)

（MS SQL Server）SQL语句导入导出大全

摘要：SQL语句导入导出大全 /******* 导出到excel EXEC master..xp_cmdshell ’bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""’ /*********** 导入Excel SELECT * FROM OpenDataSource( ’Micro... 阅读全文

posted @ 2005-02-19 23:17 关中刀客阅读(127) 评论(0) 推荐(0)