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. Calculate Different Dates
4. CHARINDEX and PATINDEX
5. Comparing the Contents of Two Tables
6. Crib Sheet
7. Curse and Blessings of Dynamic SQL
8. Data Types
9. Date and Time Functions
10. Date Formats
11. Date Periods
12. Determine Missing Identity Values
13. Dynamic Cross-Tabs and Pivot Tables
14. Email messaging system
15. Excel Workbench
16. Export Query results to Excel
17. Export/import data using BCP
18. Flattening Out Data
19. Fun with numbers
20. Fun With SQL Games
21. Functions, the good and the bad
22. Getting the Right Data with SQL Joins
23. Identify SQL Databases no longer in use
24. Instant SQL Formatter
25. Integer values from 1 to any given number
26. Introduction to Functions
27. Jeff's SQL Server Blog
28. My code library samples
29. Parse HTML
30. PRINT debug messages
31. Query Analyzer tricks
32. Random Numbers
33. Results to Excel using a linked server
34. Sample SQL Queries
35. Some Simple SQL Rules to Live By
36. Sum won't take varchar data type
37. Survival Guide
38. Table Vs Local Temp Table
39. Table-Valued Parameters
40. The Power of SQL CASE Statements
41. Tips and Tricks
42. Title Case Function for SQL Server
43. UPDATE Syntax
44. Useful Undocumented Procedures
45. User Defined Function Primer
46. User Functions Workbench
47. User-Defined Functions
48. Using BETWEEN
49. Using the CASE expression

[ Open All ]

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