Technical Article

Create a view to Alter a Table and Add three Columns

I am teaching a database class at Queens College. The project entails the truncation of all of the data and loading new data into the  existing database "BIClass" from a single of the flattened data. One of the tasks of the project was to add these three additional columns to each of the tables (AlterTableAddColumnsUserAuthorizationKeyAndTwoTimeStamps): […]

3 (3)

You rated this post out of 5. Change rating

2019-11-18 (first published: )

989 reads

Blogs

Microsoft Purview FAQ

By

I get many of the same questions about Microsoft Purview, so I wanted to...

Undercover Catalogue 0.4.5 Released – Database Module Bug Fix

By

Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in...

Saving Emergency Space on my Laptop

By

With my new laptop, one of the things I realized I’d forgotten to do...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

How to Add a New Shared Disk to a WSFC as a SQL Resource

By muhkam

Comments posted to this topic are about the item How to Add a New...

Beginner questions

By fk.da

Hello everyone and thank you for joining the forum. I am new to SQL...

Visit the forum

Question of the Day

Disabling Indexes

I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?

See possible answers