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. Parse HTML
29. PRINT debug messages
30. Query Analyzer tricks
31. Random Numbers
32. Results to Excel using a linked server
33. Sample SQL Queries
34. Some Simple SQL Rules to Live By
35. Sum won't take varchar data type
36. Survival Guide
37. Table Vs Local Temp Table
38. Table-Valued Parameters
39. The Power of SQL CASE Statements
40. Tips and Tricks
41. Title Case Function for SQL Server
42. UPDATE Syntax
43. Useful Undocumented Procedures
44. User Defined Function Primer
45. User Functions Workbench
46. User-Defined Functions
47. Using BETWEEN
48. 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