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

208 reads

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Read the latest Blogs

Forums

Use Domain Account for SQL Server service on Linux

By S_DBA

Currently, while installing SQL server we use a local linux account to run the...

Reversing a String in Python

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reversing a String in Python

Group By and JOIN within SQL Server (when dealing with multiple columns)

By lynhudson1

I have 2 tables, df1, and df2. I would like to join the two...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers