sqlcmd examples

5 Jan 2007 11:25 PM

ChrisHarrington

I am suprised - Googling found nothing. Does anyone have any sample scripts
they can share? Or have pointers to any?

Thanks

Chris Harrington
Active Interface, LLC.
http://www.activeinterface.com

6 Jan 2007 12:14 AM

Hari Prasad

Take a look into

http://www.dbazine.com/sql/sql-articles/cook15

Thanks
Hari

Show quote

"ChrisHarrington" wrote:

> I am suprised - Googling found nothing. Does anyone have any sample scripts
> they can share? Or have pointers to any?
>
> Thanks
>
> Chris Harrington
> Active Interface, LLC.
> http://www.activeinterface.com
>
>
>

6 Jan 2007 4:04 AM

ChrisHarrington

Thanks. Good reference. I didn't know about "SQLCMD mode" in SQL mgmt
studio.

Show quote

"Hari Prasad" <HariPra***@discussions.microsoft.com> wrote in message
news:2FD78705-3F3E-4126-A6B7-0342009C25D3@microsoft.com...
> Take a look into
>
> http://www.dbazine.com/sql/sql-articles/cook15
>
> Thanks
> Hari
>
> "ChrisHarrington" wrote:
>
>> I am suprised - Googling found nothing. Does anyone have any sample
>> scripts
>> they can share? Or have pointers to any?
>>
>> Thanks
>>
>> Chris Harrington
>> Active Interface, LLC.
>> http://www.activeinterface.com
>>
>>
>>

6 Jan 2007 3:58 AM

Mike C#

It's just regular T-SQL. The same things you run in SSMS Query window
should run just fine in sqlcmd. SQLCMD also allows scripting variables.
The docs for sqlcmd are here:
http://msdn2.microsoft.com/en-us/library/ms162773.aspx

Show quote

"ChrisHarrington" <charrington-at-activeinterface.com> wrote in message
news:eH5f9CSMHHA.3552@TK2MSFTNGP03.phx.gbl...
>I am suprised - Googling found nothing. Does anyone have any sample scripts
>they can share? Or have pointers to any?
>
> Thanks
>
> Chris Harrington
> Active Interface, LLC.
> http://www.activeinterface.com
>
>