OPENROWSET ( { \'provider_name\' , { \'datasource\' ; \'user_id\' ; \'password\' | \'provider_string\' } , { [ catalog. ] [ schema. ] object | \'query\' } | BULK \'data_file\' , { FORMATFILE = \'format_file_path\' [ <bulk_options>] | SINGLE_BLOB | SINGLE_CLOB | SINGLE_NCLOB } } ) <bulk_options>::= [ , CODEPAGE = { \'ACP\' | \'OEM\' | \'RAW\' | \'code_page\' } ] [ , ERRORFILE = \'file_name\' ] [ , FIRSTROW = first_row ] [ , LASTROW = last_row ] [ , MAXERRORS = maximum_errors ] [ , ROWS_PER_BATCH = rows_per_batch ]
[ , ORDER ( { column [ ASC | DESC ] } [ ,...n ] ) [ UNIQUE ]
sql跨库查询 (3)
内容版权声明:除非注明,否则皆为本站原创文章。