function

Blogs

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

ADF: Querying JSON documents

By

In my previous blog post I talked about how to read from an XML...

Read the latest Blogs

Forums

Distributed AG DB movement

By Syed_SQLDBA

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?

By VoldemarG

How can I overcome/fix this? object_name (st.objectid) in the code below returns NULL. (in...

List all stored procedures which return datasets

By AlexF

Is there any way to do that? I need to list that kind of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers