My Work
My Blogs
Hotlinks
Category Archives: database
Use INFORMATION_SCHEMA to find data about your database
Have you ever been in this situation? You’re the new developer for a database powered application and you have to figure out what tables contain a specific column? Or maybe you’ve got a legacy database that needs it’s stored procedures … Continue reading
Posted in database, development, internets, SQL
Tagged automation, data discovery, db2, information_schema, mysql, oracle, rdmbs, schemata, sql server, sql-92, SQLSERVER, system tables, system views, tsql
1 Comment
An aggregate may not appear in the set list of an UPDATE statement
Ever seen the error “An aggregate may not appear in the set list of an UPDATE statement” when working with SQL Server? I ran into this one recently after trying to put a COUNT in an UPDATE statement. I was rewriting … Continue reading
Posted in database, development, internets, microsoft, SQL, tips and tricks, tsql
Leave a comment
Today I took 30 minutes to save hours
UPDATE – 1/6/2011 : Since writing this post I have bundled this entire reset process into a single windows batch file. In addition to restoring my database, I also have to remove temp files from my server, so it was … Continue reading
Posted in database, development, SQL, tips and tricks
Tagged automation, backup, bat, batch, batch file, cli, cmd, command line, cursor, DECLARE, del, exec, fetch, fetch_status, information_schema, kill, restore, sproc, SQL, sqlcmd, sys, tsql, workflow
Leave a comment
