var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sqlserver and powershell
I need help.
How I get this to run using powershell
PS D:\restore> "select count(*) from [group]" |sqlcmd
Msg 208, Level 16, State 1, Server xxxxxx, Line 1
Invalid object name 'group'.
Could some one please help.
Found the answer,
"set quoted_identifier on; select count(*) from `"group`"" | sqlcmd ....database etc.
Last edited by Ivancevallos; 09-26-14 at 01:22.
You can also use the traditional syntax of SQLCMD:
sqlcmd /S $server /E /Q "select count(*) from [group]"
Last edited by MCrowley; 09-26-14 at 09:09.
Reason: Fixed a typo
What is [Group]? Do you actually have a table named "Group"? Also we don't have your DDL for the table Group so I don't know what columns you have.