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. Insert Update Trigger How To
25. Instant SQL Formatter
26. Integer values from 1 to any given number
27. Introduction to Functions
28. Jeff's SQL Server Blog
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. SQL NPI Validate Function
37. Sum won't take varchar data type
38. Survival Guide
39. Table Vs Local Temp Table
40. Table-Valued Parameters
41. The Power of SQL CASE Statements
42. Tips and Tricks
43. Title Case Function for SQL Server
44. UPDATE Syntax
45. Useful Undocumented Procedures
46. User Defined Function Primer
47. User Functions Workbench
48. User-Defined Functions
49. Using BETWEEN
50. 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