Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Remove non printable characters

    Paul White:
    How do I actually use your inline table function?

    After the creating the function, I ran this:

    DECLARE @Bitbucket...

  • RE: Pad length

    Michael makes a great point!

    You can use the REPLICATE function to accomplish this much more simply, and

    if needed you could use the DATELENGTH() string function to set the length

  • RE: Pad length

    In my case, I needed to add the 'N' parameter for @UseFixedLength in the SELECT statement to avoid an error regarding invalid number of arguments. Also the result displayed for...

  • RE: Export all tables to CSV files

    When I run this and then try to execute one of the sample rows

    Sample results:

    bcp "SELECT * FROM [XXXapp].[dbo].[tsmReportSetting]" queryout c:\tsmReportSetting.csv -c -t, -T -S XXXappServerName

    I'm getting this error:

    Msg...

Viewing 4 posts - 1 through 4 (of 4 total)