MS SQL Tips & Tricks
Jacek Szarapa's MS SQL Library
String related
- How to convert table values to comma-delimited string
- How to convert comma-delimited string to the table of items
- How to pad a number with leading zeros
- How to count the occurrences of a string in a text
- How to parse a ranges of numbers into a table
- How to split string in SQL
DateTime related
- How to get a table with list of days of current month
- How to find first and last day of the year
- How to find first and last day of the month
- How to find first and last day of the week
- How to get date part of datetime value
- How to get time part of datetime value
- How to get the week day regardless @@DATEFIRST setting
- How to get the calendar week number regardless @@DATEFIRST setting
- How to build up datetime type having year, month, day, hour, minute and second
- How to find a number of days in a month
- How to find a number of days in a year
- How to replace date part in datetime variable
- How to replace time part in datetime variable
Record selections
- How to select X random records from a table
- How to get a table of X numbered records
- How to get a table of X random values
- How to find first and last occurrence of entry given kind
- How to do custom pagging using SQL queries
- How to find duplicates in the table
- How to remove duplicates leaving only first occurrence
- How to create table with date range and interval
Database related
- How to disable trigger on table
- How to reindex all tables in database
- How to determine file names used by current database
- How to test table existance
- How to check if temporary table exists
- How to test field existance in a particular table
- How to test index existance
- How to get number of records in each table in database
- How to get the body of stored procedure or view using sql query
- How to get list of opened connections to current database
Numeric
Menu
- [List of topics]
- Outsourcing IT
- References
- Leave message
- Guest book
- Circulum Vitae
- Download CV (PDF format)
"If you do little things well, you'll do big ones better."
|
Network: GoldenLine · LinkedIn · Tiger's WebSite · Okucia budowlane Developed by Jacek Szarapa |
|