GitHub

Powershell T-SQL Output Excel

DECLARE @agname SYSNAME, @listnername VARCHAR(128), @primaryserver VARCHAR(128), @agserverlist VARCHAR(MAX), @agdblist VARCHAR(MAX); INNER JOIN master.sys.availability_replicas Replicas ON ...
Simon Fraser University

Running an SQL Query and Customizing the Output

When your SQL query is ready, you can run the query immediately or you can add a title, change its options, limit its output, and so on, to make the report look better. See Viewing the SQL Code, ...
Simon Fraser University

Saving SQL Code or Output

You can create a new SAS, DB2, or other database management system table from your output; see Creating New Tables for details You can save the SQL query to a catalog entry of type SQL. You can save ...
GitHub

Transaction rollback fails with "use_output_insert == false" if a SQL error happened during the transaction

We're running a Rails 4.2.0 app with activerecord-sqlserver-adapter 4.2.2 and SQL Server 2012 and have run into an issue with both emoji encoding and transaction rollback in that scenario. Trying to ...