Posted by Desmodromic on 11/23/07 00:30

On Nov 22, 5:20 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Desmodromic (davies...@yahoo.com.au) writes:
> > The command below runs fine from within Management Studio
>
> > exec sp_MSforeachtable @command1="exec sp_spaceused '?' "
>
> > However, I'd like to run it via sqlcmd. I've tried various
> > combinations of escaping the doulbe and single quotes but without
> > success.
>
> > sqlcmd -E -Q "sp_MSforeachtable @command1=\"exec sp_spaceused '?'\""
> > Sqlcmd: 'exec sp_spaceused '?'\""': Unexpected argument. Enter '-?'
> > for help.
>
> Try:
>
> sqlcmd -E -Q "sp_MSforeachtable @command1='exec sp_spaceused ''?'''"
>
> In SQL you use ' delimit strings. " may also work as a string delimiter,
> depending on the setting QUOTED_IDENTIFIER, but as this setting is normally
> on, stick to ' and double it when nested.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Excellent! Works fine and is just what I was looking for. Many thanks.

\M

• Next in forum: Re: Sql injecting
• Prev in forum: Re: foreign keys - on which kind of keys do the base on?
• Thread view: Re: sqlcmd and escape characters

[Reply to this message]