Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 279

SQLCMD is Microsoft SQL Server's command line utility that allows you execute T-SQL commands from a command prompt.

2 votes
Accepted

How can I output more than 256 characters to a file?

While trying out the various suggestions in the comments I have stumbled across a solution. I replaced: '"' + Column4 + '"' as ReallyLongString, with: '"' + REPLICATE('O', 4000) + '"' AS ReallyLo …
ChrisF's user avatar
  • 302
4 votes
3 answers
10k views

How can I output more than 256 characters to a file?

The problem I'm having is that one of the fields contains text greater than 256 characters long and is getting truncated when fed through the SQLCMD command. … Is there something I can do to the stored procedure or is there a combination of options to SQLCMD that will produce the desired output? …
ChrisF's user avatar
  • 302