2019-11-18
1,142 reads
SQLCMD
2019-03-18
562 reads
2019-03-11
582 reads
2017-08-24
939 reads
2017-08-21
805 reads
2017-08-14
933 reads
2017-08-08
822 reads
2016-11-09
1,108 reads
SQLCMD to export data in txt file
SQLCMD is one of many methods to export your database data to some text file
2016-10-12 (first published: 2016-09-27)
10,695 reads
SQLCMD and Batch File magic
Execute scripts in a folder with a single click using SQLCMD and a batch file.
2017-07-28 (first published: 2015-11-19)
15,568 reads
Blogs
How to: exec sp_help on temp tables?
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
Daily Coping 26 Feb 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
ADF: Querying JSON documents
By Ed Elliott
In my previous blog post I talked about how to read from an XML...
Forums
Distributed AG DB movement
I have a DAG between On prem and Azure. We have a maintenance window...
object_name (st.objectid) returns NULL. How can I overcome/fix this?
How can I overcome/fix this? object_name (st.objectid) in the code below returns NULL. (in...
List all stored procedures which return datasets
Is there any way to do that? I need to list that kind of...
Ask SSC