TJay Belt


spAddField

spAddField is the proc I use to add all fields to the db in our upgrade scripts.  With this proc, you pass it the tablename, fieldname, datatype, and null or not null.  This will call spGetFieldsExists and see if the fields exists or not.  If it does, spAddField will drop that column.  Then it readds […]

2002-03-05

207 reads

Blogs

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Daily Coping 23 Oct 2020

By

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

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Read the latest Blogs

Forums

Need help to form query to get missing month data

By anuxps

I want to know what are the customers having missing month data based on...

What would cause slow disk access on an AWS EBS SQL Server? (PAGELATCHIO_SH)

By apresley

I have an EC2 instance (r5a.4xlarge) which should be able to do 2Gbps+ in...

What's Causing the Pushback with DevOps?

By Grant Fritchey

Comments posted to this topic are about the item What's Causing the Pushback with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers