This script will take a string (8000) and add a carriage return at the closest space to nth char. e.g. You only want 50 characters per line. This will add carriage return at the closest space before the 50th character.
2003-09-30
227 reads
Use this script to make HTTP posts or requests from withing SQL. It uses the XML HTTP COM object.
2003-07-08
1,032 reads
A proc which gets a list of all databases (Exluding "excluded" ones) and backs them up.The backup files are stored in the directory \DatabaseName\DatabaseName.bakUNC names are supported provided SQL Server has write access to the location.It deletes backups older than x (Current 3) days.This can be changed.Add a job to execute the script of proc […]
2003-06-26
697 reads
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...
By Steve Jones
I had a suggestion from somone on a place where AI helps them and...
Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it,...
Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...
Comments posted to this topic are about the item Does Version Control Scare You
Comments posted to this topic are about the item Unlimited Text
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?
See possible answers