mssql的等效语法是什么 [英] what is the equivalent syntax mssql

问题描述

Hi,

OPENROWSET('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DEFAULTDIR=e:\data\xml\;Extensions=txt;','SELECT * FROM invdata2.txt')

上面的查询是ms访问是否与msssql等效.

在此先感谢

The above query is ms access is there any equivalent to msssql.

thanks in advance

推荐答案

阅读以下链接:

http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/ [ http://www.simple-talk.com/sql /t-sql-programming/the-tsql-of-text-files/ [ http://forums.databasejournal.com/showthread.php?t=47966 [ ^ ]

Read the following links :

http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/[^]

http://www.simple-talk.com/sql/t-sql-programming/the-tsql-of-text-files/[^]

http://forums.databasejournal.com/showthread.php?t=47966[^]

这篇关于mssql的等效语法是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！