Simple script to backup all databases at once
Script to backup all non system databases To backup all your MS SQL databases quickly on a SQL instance use the following script in a new query window. You must change the “SET @path” string to a suitable location.
In: SQL · Tagged with: backup, script, sql, T-SQL
Setting SQL Server to accept date in DD/MM/YYYY format
I’ve been working on a web based database project for the wifes business and during development I realised that half of the dates where being saved in M-D-Y format. As I live in the UK we use the correct date format which is D-M-Y obviously ;). The problem turned out to be a single settings […]
In: ASP.NET, SQL, Tech · Tagged with: asp.net, database, dmy, sql
Cannot shrink transaction log SQL 2005
If you ever come across a MS SQL 2005 transaction log that refuses to shrink, this little bit of code might help you out.
In: SQL · Tagged with: dbcc, sql, Transaction log
SQL Cheat Sheet
ThisSQL Cheat Sheet has examples of various SQL commands that work on most major flavours of SQL. Though they all work on T-SQL.
In: SQL · Tagged with: cheat sheet, delete, insert, join, select, sql, T-SQL, update
T-SQL Example code: Data Types
The various datatypes: