sql
-
MSSQL Quick Reference
Snippets below have been condensed from their original sources for brevity. See references for original articles. Great reference on joins: http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins Show all tables in specific database: (MSSQL equivalent of MySql “show tables”) Insert into: Insert if not exists: Trigger… Continue reading
-
Import OData / XML / RSS / Webservice Feeds into Excel
If you came here looking for some quick and easy code that you can plug right in and dump data in excel format.. You have come to the wrong spot. 🙂 Depending on the scenario you may need this functionality… Continue reading
{handshake sound} 