SP_HELPTEXT Modified for XML

This is the standard sp_helptext from SQL Server 2000 modified slightly to return the object definition as an XML document.The document is structured in the following format:I admit it was not a lot of work since I merely modified the final SELECT statement from Microsoft's own procedure, but I still find this very useful.The only […]

2003-09-26

136 reads

Blogs

Daily Coping 20 Apr 2021

By

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

The Diverse Data Platform–Dativerse.io

By

The other day I got a note from Ben Weissman the other day that...

Extended Events and Azure SQL Database

By

Knowledge of how your system behaves is vital to better control, maintain, and grow...

Read the latest Blogs

Forums

usage of BCP and BULK INSERT

By 892717952

as I'm not clear how to use bcp and bulk insert in the following...

sequence of SQL server execution plan

By 892717952

As per my understanding,  when we read the execution plan, the sql server is...

An Empty Integer Numpy Array

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Empty Integer Numpy Array

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers