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 – Return TRUE/FALSE if query rows returned

SQL – SELECT query where case insensitive and wildcard

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 – How to count unique values in database

SQL Management Studio – How to generate change scripts

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 – How to format decimal to space delimited currency $ 1 234 567.89

SQL – Divide by zero error

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

T-SQL – How to reset auto increment to 1

T-SQL – How to reset auto increment to next available number

T-SQL – How to output day name from date

T-SQL – How to output day number from date

T-SQL – How to output ordinal number – 1ST 2ND 3RD 4TH

T-SQL – How to output ordinal day from date – 1ST 2ND 3RD 4TH

T-SQL – How to output name of month