Sign in | Join | Help

Keith Rull » All Tags » T-SQL (RSS)

Browse by Tags

Keith Rull

Syndication

Recent Posts

Tags

News

Badges

Archives

How To: List databases in a SQL Server using T-SQL and truncate their logs

Finally i'm back after a month of crazyness due to my webhost not performing up to its promise of 99.9% uptime. Enough with the rant and on with the article, today i'm going to talk about how to list databases in a SQL Server by just using T-SQL...

Published Tue, Jan 01 2008 11:59 AM by keithrull

Filed under: SQL, T-SQL, sp_MSforeachtable, Truncate Table, DBCC, sysdatabases, sys.sysdatabases, Truncate Database Logs, SHRINKDATABASE, sp_msForEachDB, sp_databaases, sp_helpdb
How To: Create Cursors For Updating and Deleting of Records in SQL

Here are some samples on how to use cursors in SQL to do updates and deletes on records. Nothing fancy, just pure t-sql code. :)...

Published Tue, Apr 04 2006 12:02 PM by keithrull

Filed under: SQL Playbook, T-SQL, Update, Cursors, Delete
A custom T-SQL function for removing embedded HTML tags

This is an interesting piece of sql, the function accepts a string and removes HTML elements that is inside the string. This is genereally useful when you have data that has embedded HTML content on it. The function was written by Robert Davis....

Published Thu, Jun 06 2005 3:36 PM by keithrull

Filed under: SQL Playbook, T-SQL

Copyright DevPinoy 2005-2008