My Work
My Blogs
Hotlinks
Category Archives: tips and tricks
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
Injecting javascript into asp.net via code
Microsoft has a great MSDN article on using javascript along asp.net, but they didn’t mention a technique I like to use, put it in a Literal control. While there are many ways to add javascript to a page, I find … Continue reading
Posted in .net, C#, development, microsoft, tips and tricks
Tagged asp.net, aspx, javascript, js, Literal, msdn, postback
2 Comments
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
