Category Archives: microsoft

iBoth

Posted on 10/05/2011 by Eric Fickes

I’m a PC, but I’m also a MAC. Thank you Steve.

Posted in apple, iphone, microsoft, osx | 1 Comment

An aggregate may not appear in the set list of an UPDATE statement

Posted on 02/20/2011 by Eric Fickes

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

Posted on 02/18/2011 by Eric Fickes

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 , , , , , , | 2 Comments

Use sys.dm_exec_sessions to disconnect SQL user connections

Posted on 01/03/2011 by Eric Fickes

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 — init vars DECLARE … Continue reading →

Posted in database, internets, microsoft, SQL, tsql | Leave a comment