Smart data archiving stored procedure

This stored procedure uses a series of input parametes to generate, and optionally execute a series of SQL commands to move production data to an archive table.  The procedure assumes that the production and archive tables will have the same structure.  The procedure uses the following input parameters:@SourceTable:  This is the name of the table […]

2007-09-05 (first published: )

1,672 reads

Blogs

Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”

By

This blog post relates to where you might be doing scale operations of your...

Bash: “command not found” in IF statement

By

This blog post is about a situation where writing an IF THEN ELSE statement...

The First Data Saturday is Tomorrow

By

Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...

Read the latest Blogs

Forums

Data Privacy Grows in California

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data Privacy Grows in California

Grant user access to view database only

By sql_Reporter

Hi I need to grant a user access to a DB on the server...

Need to strip off the beginning of a field in SELECT statement

By tim8w

I have this table that unfortunately has spaces in the field, which I am...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Amend a Commit

See possible answers