Mawhirter Home
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
Young Life
Experiments
IFrame test
PDF Test 2
Donate To Pikes Peak Habitat for Humanity
Fountain UMC Calendar
Site Map
SlideShow with Gallery Test
Web
Site
Search
Tuesday, March 09, 2010
..::
Reference
»
SQL Notes
::..
Register
Login
FAQs
Q1. How to truncate a SQL Server log file while the database stays online ?
Q2. How to copy data and structure to a new table (e.g. backup a table)
Q3. Using bulk insert
Q4. Logging SQL Syntax errors in SQL Server
Q5. Using TOP twice to psuedo paginate
Q6. Using Group By to get row count based on an aggregate.
Q7. Using Group By and Having to find duplicates
Q8. Doing an Update from one table to another.
Q9. Copy data from one table to another (structure already in place)
Q10. OpenQuery Notes
Q11. SQL Server functions - Scalar versus Table values
Q12. Doing a Group By along with a join to get info from another table
Q13. Cleanup orphaned data using NOT EXISTS
Q14. Getting the top N rows for each group.
Q15. Oracle views and performance
Q16. Useful blocks for YL / Field Development
Q17. Copy a PPL from one MU to another (to be done after copying donor contacts)
Q18. Mass inserts for Camp Trip app
Copyright 2009 by DotNetNuke Corporation
Terms Of Use
Privacy Statement
DotNetNuke® is copyright 2002-2010 by DotNetNuke Corporation