MIRRORGLASSBALL.COM
Bookmarks Cards Concerts Facebook Mixes
Photos Poetry Quotes Slideshow Top 10

back to bookmarks index add bookmark next category, previous category
SQL
1. Arrays and Lists in SQL Server
2. Building a T-SQL Loop
3. Curse and Blessings of Dynamic SQL
4. Database design for email messaging system
5. Date Formats For SQL
6. Dynamic Cross-Tabs and Pivot Tables
7. Essential SQL Server Date, Time and DateTime Functions
8. Examples of how to Calculate Different SQL Server Dates
9. Export Query results to Excel with Column names in T-SQL
10. Export/import data using BCP
11. Flattening Out Data with One of the Coolest SQL Tricks Ever
12. Fun with numbers in Transact-SQL queries
13. Functions, the good and the bad
14. Getting the Right Data with SQL Joins
15. Identify SQL Databases that are no longer in use
16. If you think SQL is boring or dumb or limited, try this
17. Instant SQL Formatter
18. Integer values from 1 to any given number
19. Introduction to Functions
20. Jeff's SQL Server Blog
21. My code library samples
22. PRINT debug messages
23. Random Numbers
24. Sample SQL Queries
25. Some Simple SQL Rules to Live By
26. Some Useful User-Defined Functions for SQL Server 2000
27. SQL 2000 User Defined Function Primer
28. SQL BETWEEN
29. SQL Crib Sheet
30. SQL DATE FORMATS
31. SQL Date Periods
32. SQL Garbage Collector
33. SQL Script for Comparing the Contents of Two Tables
34. SQL Server data types
35. SQL Server Excel Workbench
36. SQL Server Management Studio Shortcuts
37. SQL Server Storage Engine
38. SQL String User Functions
39. Sum aggregate operation won't take varchar data type
40. Survival Guide
41. Table-Valued Parameters
42. Ten bits of Query Analyzer that you might not have looked at already
43. The Power of SQL CASE Statements
44. Tips and Tricks
45. Title Case Function for SQL Server
46. UPDATE Syntax
47. User Defined Function to Strip HTML - Parse HTML - No Regular Expression
48. Using SQL Server's CHARINDEX and PATINDEX
49. Using the CASE expression instead of dynamic SQL in SQL Server
50. Write query results to Excel using a linked server and T-SQL

[ Open All ]

[use > to go next and < to go previous. tab and shift+tab can also be used]
Copyright © Dan E. Golden | Mirrorglassball 2009-2018