SQL Management Studio – How to create read only users

• 1

SQL – How to select current year from lookup table

SQL – How to insert new line/line break in string

How to install SQL Management Studio 2008 R2

• 6

SQL Query – Find numbers with more than two decimal places

• 4

SQL – How to convert datetime to formatted date string dd-mm-yyyy

SQL Management Studio – Change ‘Select Rows’ and ‘Edit Rows’ Amount

SQL Server – How to set a datetime field to automatically use current date/time

SQL – How to concatenate/combine column values into comma separated text string

SQL – SELECT query where case insensitive and wildcard

SQL – Return TRUE/FALSE if query rows returned

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

SQL Management Studio – How to generate change scripts

SQL – How to count unique values in database

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

SQL Management Studio – ‘Saving changes is not permitted’ message when changing table

• 1

MS SQL Server 2008 – How to update value using SELECT results

SQL – Divide by zero error

SQL – How to format decimal to space delimited currency $ 1 234 567.89

SQL Management Studio – How to change varchar(n) to varchar(MAX)

SQL Management Studio – unable to delete row ‘String or binary data would be truncated’

SQL -Find and replace text in string

SQL – How to search with accented characters

SQL – How to convert line separated text to comma separated

SQL – How to copy column data to another column