sqlcmd

相关标签：javascript jquery android 多少钱 iPhone

Programmatically detect which SQL Server is principal,which is the mirror?

I am looking for a way to programmatically query which SQL server is serving as the principal SQL server and which one is the mirror in a pair. Does anyone know if t开发者_运维问答his is possible via[详细]

2023-03-26 14:42 分类：问答
8192 limitation on text column while exporting to file?

I have looked at this question which is essentially the same but the OP accepted \'using other tools\' as an answer. Basically, I am trying to export data from a table to a delimited file but because[详细]

2023-03-25 07:10 分类：问答
Issue executing an exe when the path has spaces.

This works: SET server=MyServer SET db=MyDb FOR /F \"usebackq tokens=1\" %%i IN (`sqlcmd -S %server% -d %db% -w200 -h-1 -E -Q \"set nocount on; select REPORTING_DATE FROM dbo.CURRENT_REPORTING_DATE[详细]

2023-03-23 08:50 分类：问答
TeamCity + Psake + SqlCmd Powershell infinite loop

I\'m trying 开发者_开发知识库to use the Powershell Runner in TeamCity 6.5.2 to run a Psake task that depends on a task that calls out to SqlCmd.If I try to do this, teamcity seems to get into an infin[详细]

2023-03-21 19:36 分类：问答
get .BAT file or SQLCMD to prompt user for input

I am attempting to run the following query sqlcmd -STEMP7 -E -devolive_base -w256 -QEXIT(\"DECLARE @开发者_如何学编程r int EXEC @r = usp_AddToObservationtbl $,$,$ SELECT @r\")[详细]

2023-03-19 05:07 分类：问答
How do I call a stored procedure with arguments using sqlcmd.exe?

I need to call a stored procedure and pass arguments in from Powershell. I think the best option is to usesqlcmd.exe but I\'m not sure how to pass argu开发者_运维问答ments to the stored proc using thi[详细]

2023-03-14 11:38 分类：问答
How to change the port when calling sqlcmd

I have this command sqlcmd.exe -E -i \"C:\\joe-db-scripts\\joe-db-tasks.Install.sql\" and I need to add the specific non开发者_高级运维-standard port of 32001. How do I do that? I was thinking of s[详细]

2023-03-08 06:07 分类：问答
sqlcmd: reconciling -W and -Y

I have an automated batch process that uses sqlcmd to pull data from a database and dump it into a text file. Many fields in that database are of type varchar(max), Sqlcmd limits these fields to 256 c[详细]

2023-03-07 22:10 分类：问答
sqlcmd - How to get around column length limit without empty spaces?

I\'m trying to use sqlcmd on a windows machine running SQL Server 2005 to write a query to a csv file. The command line options we typically use are:[详细]

2023-03-04 12:08 分类：问答
sqlcmd not working after installing sql server 2005 express

I downloaded the 53.5 MB setup of SQL Server 2005 Express from this URL: Micro开发者_如何学编程soft SQL Server 2005 Express Edition[详细]

2023-03-01 13:34 分类：问答