Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Pages that link to SQL Server Programming Hacks - 100+ List
From Wiki
(List of links)
< SQL Server Programming Hacks - 100+ ListThe following pages link to SQL Server Programming Hacks - 100+ List:
View (previous 50) (next 50) (20 | 50 | 100 | 250 | 500)- How to find the first and last days in years, months etc (← links)
- Trouble With ISDATE And Converting To SMALLDATETIME (← links)
- Case Sensitive Search (← links)
- No Functions on Left Side of Operator (← links)
- Query Optimizations With Dates (← links)
- No Math In Where Clause (← links)
- Don't Use (select *), but List Columns (← links)
- Testing for Null Values (← links)
- How To Check If Any, ALL Or No Parameters Have A NULL Value (← links)
- Return The First Non Null Value (← links)
- Return Null If A Value Is A Certain Value (← links)
- Concatenation with NULL values (← links)
- NOT IN and NULLs (← links)
- Epoch Date (← links)
- Get Datetime Without Time (← links)
- Date Ranges Without Loops (← links)
- Calculate Birthday In Years (← links)
- Formatting Dates (← links)
- Calling Stored Procedures With Datetime Parameters (← links)
- Return Top N Rows (← links)
- Dynamic TOP (← links)
- Sorting Numbers Stored In A Varchar Column (← links)
- Split A String By Using A Number Table (← links)
- Concatenate Values From Multiple Rows Into One Column (← links)
- Rank (← links)
- Dense Rank (← links)
- Row Number (← links)
- Sort certain values last (← links)
- Returning The Maximum Value For A Row (← links)
- 5 ways to return rows from one table not in another table (← links)
- Order IP Addresses (← links)
- Data formatting dates (← links)
- Data formatting SSN (← links)
- 6 Different Ways To Get The Current Identity Value (← links)
- Use XACT ABORT to roll back non trappable error transactions (← links)
- Random Sorting (← links)
- Sort Values Ascending But NULLS Last (← links)
- Adding Leading Zeros To Integer Values (← links)
- How do I format money/decimal data with commas? (← links)
- Find Out How Many Occurrences Of A Substring Are In A String (← links)
- Ten SQL Server Functions That You Have Ignored Until Now (← links)
- Use the *1 trick to do math with two varchar values (← links)
- Store The Output Of A Stored Procedure In A Table Without Creating A Table (← links)
- Find all The Rows Where Any Of The Columns Is Null Or Zero Or Both (← links)
- Update triggers (← links)
- Integer math (← links)
- Identity Values And Triggers (← links)
- Use XACT STATE() To Check For Doomed Transactions (← links)
- Three differences between COALESCE and ISNULL (← links)
- Non deterministic functions and nullif (← links)
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.