SQL Server Tuesday, 15 July 2014 by How to install SQL Management Studio 2008 R2 SQL Management Studio is the must use tool for SQL database administrators, however every time I’ve needed to install it... 6 SQL – How to convert datetime to formatted date string dd-mm-yyyy When you have a date or datetime column in an SQL database, it will output a value that looks like 2017-01-01... SQL Server – How to set a datetime field to automatically use current date/time Senario You have a ‘datetime’ field in an SQL server database table and need it to automatically use the current... T-SQL – How to output day name from date The following T-SQL statement shows how output the name of a day from a date. For example, 16 March 2019... SQL Management Studio – How to generate change scripts SQL Management Studio allows you to open a table in design mode, make changes then generate a “change script”. The... SQL – SELECT query where case insensitive and wildcard Below you’ll find two ways to search an SQL table column for a case insensitive string. Both examples use the... T-SQL – How to use where filter with column alias Problem If you try to use a column alias in a where statement, you recieve an error message that reads... T-SQL – How to output ordinal number – 1ST 2ND 3RD 4TH The following T-SQL statement shows how output a number as an ordinal number (st, nd, rd, th). For example, 3... SQL – Quick and easy way to performance test SQL statements There are many commercial tools to help you design and test SQL statements, as well as the execution tests in... T-SQL – How to output ordinal day from date – 1ST 2ND 3RD 4TH The following T-SQL statement shows how output the day from a date as an ordinal number (st, nd, rd, th).... T-SQL – How to reset auto increment to 1 The following T-SQL shows how to reset a tables identity auto increment back to 1. This may be useful if... T-SQL – How to output name of month The following T-SQL statement shows how output the name of the month from a date. For example, 16 March 2019...
How to install SQL Management Studio 2008 R2 SQL Management Studio is the must use tool for SQL database administrators, however every time I’ve needed to install it... 6
SQL – How to convert datetime to formatted date string dd-mm-yyyy When you have a date or datetime column in an SQL database, it will output a value that looks like 2017-01-01...
SQL Server – How to set a datetime field to automatically use current date/time Senario You have a ‘datetime’ field in an SQL server database table and need it to automatically use the current...
T-SQL – How to output day name from date The following T-SQL statement shows how output the name of a day from a date. For example, 16 March 2019...
SQL Management Studio – How to generate change scripts SQL Management Studio allows you to open a table in design mode, make changes then generate a “change script”. The...
SQL – SELECT query where case insensitive and wildcard Below you’ll find two ways to search an SQL table column for a case insensitive string. Both examples use the...
T-SQL – How to use where filter with column alias Problem If you try to use a column alias in a where statement, you recieve an error message that reads...
T-SQL – How to output ordinal number – 1ST 2ND 3RD 4TH The following T-SQL statement shows how output a number as an ordinal number (st, nd, rd, th). For example, 3...
SQL – Quick and easy way to performance test SQL statements There are many commercial tools to help you design and test SQL statements, as well as the execution tests in...
T-SQL – How to output ordinal day from date – 1ST 2ND 3RD 4TH The following T-SQL statement shows how output the day from a date as an ordinal number (st, nd, rd, th)....
T-SQL – How to reset auto increment to 1 The following T-SQL shows how to reset a tables identity auto increment back to 1. This may be useful if...
T-SQL – How to output name of month The following T-SQL statement shows how output the name of the month from a date. For example, 16 March 2019...