Menu
Home
Knowledge Base
Blog
Latest comments
Tools and resources
Password generator
What is my IP?
Who is – domain name info
Screen colour picker
How to convert to MP4 and compress videos
WCAG Colour Contrast Analyser
About
IT Support Guides
Search For
Search
Home
Knowledge Base
SQL
SQL – How to select current year from lookup table
How to install SQL Management Studio 2008 R2
6
SQL – How to convert datetime to formatted date string dd-mm-yyyy
How to generate SQL create table script using phpMyAdmin
SQL – How to concatenate/combine column values into comma separated text string
Crystal Reports – Display unique records only
How to use a REGEX in an SQL SELECT query
SQL Query – Find invalid email addresses
SQL – How to decode HTML entities when using FOR XML PATH
WordPress – How to use LIKE in WPDB PREPARE SQL statements
SQL – How to count unique values in database
WordPress – How to use IN in WPDB PREPARE SQL statements
SQL – How to remove spaces before and after database values
T-SQL – How to use where filter with column alias
SQL – How to get current financial year using SQL
SQL – How to select current financial year from lookup table
SQL – Quick and easy way to performance test SQL statements
MS SQL Server 2008 – How to update value using SELECT results
SQL – How to search with accented characters
SQL – How to convert line separated text to comma separated
Recent Posts
3 reasons to switch to 1.1.1.1 DNS
5 ways swim lane workflow diagrams fail
Blocked folder names in Windows 10
How to secure your LastPass account and passwords
Facebook HEARS everything?
About
Donate
Privacy policy
Copyright