Mawhirter Home
Volt Blog
Sudoku
Reference
Building an Arcade Machine
Website Reference
Sending site email through gmail
CAD/CAM Geometry
SQL Notes
VirtualPC
Video Notes
File Conversion Info
3D Printing
Gtablet
Young Life
Experiments
IFrame test
PDF Test 2
Donate To Pikes Peak Habitat for Humanity
Fountain UMC Calendar
Site Map
SlideShow with Gallery Test
Tag Cloud
Web
Site
Search
Monday, February 06, 2012
..::
Reference
»
SQL Notes
::..
Register
Login
FAQs
Q1. How to truncate a SQL Server log file while the database stays online ?
Created: 6/10/2011
Q2. Generate Insert Statements
Basics Created: 6/10/2011
Q3. How to delete duplicates
Basics Created: 6/10/2011
Q4. Using the Pivot clause to turn rows into columns
Basics Created: 6/10/2011
Q5. How to import XML data
Basics Created: 6/10/2011
Q6. Get list of Contacts who are deleted donors for an area (to mark inactive or delete)
YL Specific Created: 6/10/2011
Q7. How to copy data and structure to a new table (e.g. backup a table)
Created: 6/10/2011
Q8. Oracle 4 part naming (used in update from)
Created: 6/10/2011
Q9. Update From
Created: 6/10/2011
Q10. Copy PPL Events
Created: 6/10/2011
Q11. Mass inserts for Camp Trip app
YL Specific Created: 6/10/2011
Q12. Copy a PPL from one MU to another (to be done after copying donor contacts)
Created: 6/10/2011
Q13. Useful blocks for YL / Field Development
YL Specific Created: 6/10/2011
Q14. Oracle views and performance
Oracle Created: 6/10/2011
Q15. Getting the top N rows for each group.
Created: 6/10/2011
Q16. Cleanup orphaned data using NOT EXISTS
Created: 6/10/2011
Q17. Doing a Group By along with a join to get info from another table
Created: 6/10/2011
Q18. SQL Server functions - Scalar versus Table values
Created: 6/10/2011
Q19. OpenQuery Notes
Created: 6/10/2011
Q20. Copy data from one table to another (structure already in place)
Created: 6/10/2011
Q21. Doing an Update from one table to another.
Created: 6/10/2011
Q22. Using Group By and Having to find duplicates
Created: 6/10/2011
Q23. Using Group By to get row count based on an aggregate.
Created: 6/10/2011
Q24. Using TOP twice to psuedo paginate
Created: 6/10/2011
Q25. Logging SQL Syntax errors in SQL Server
Created: 6/10/2011
Q26. Using bulk insert
Created: 6/10/2011
Q27. Alumni Export
YL Specific Created: 8/12/2011
Q28. ASIST Status report numbers
YL Specific Created: 8/12/2011
Copyright 2010 by DotNetNuke Corporation
Terms Of Use
Privacy Statement
DotNetNuke® is copyright 2002-2012 by DotNetNuke Corporation