Technical Article

Dynamically Alter all your Tables.....

This script allows you to dynamically alter all the tables in your database.  In the script i am building up an alter statement that adds a 'TimeStamp' column a table.If anyone knows a better way to do this kind of thing, feel free to drop me a mail (jamie.moffat@infographics.co.uk)

You rated this post out of 5. Change rating

2002-07-04

740 reads

Blogs

Attacking the Weakest Link

By

When I look at a system and think about its security model, the first...

Webinar – Microsoft Fabric for Dummies

By

On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...

Migrate datetime data to datetimeoffset with AT TIME ZONE

By

I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...

Read the latest Blogs

Forums

ghost backups processed 0 pages

By Snargables

I've got something I'm not aware of performing backups of my dbs at random...

Stored Procedures - passed string than variable length

By Arthur Kirchner

Dear all, I was just wondering: Can you change the default behaviour as illustrated...

Multi row tally query with max value

By ibbo14

Hello folks, I would be very grateful if someone could assist me with this...

Visit the forum

Question of the Day

The Backup File Extension

I run this command in SQL Server 2022. What is the extension of the backup file?

BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'

See possible answers