SQL Server administration, infrastructure, automation, instrumentation etc.
Pages
▼
2011-08-29
Servername in SQLCMD script
A variable can be used in both SQLCMD and T-SQL statements.
This is a very short example: :Setvar _servername "SANDY.sqladmin.lan" :CONNECT $(_servername) SELECT N'$(_servername)' AS [_servername] ,SERVERPROPERTY('SERVERNAME') AS [servername];
No comments:
Post a Comment