SQL Management Studio 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 Query – Find invalid email addresses As a database administrator one of the important data health checks you can perform is checking that email addresses being... 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... 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 – 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 Management Studio – unable to delete row ‘String or binary data would be truncated’ Problem When attempting to delete a database table row using SQL Management Studio you receive the following error message: No... SQL Management Studio – ‘Saving changes is not permitted’ message when changing table Problem When designing a table you’re unable to save the changes. When you try you receive the following message: Saving... 1
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 Query – Find invalid email addresses As a database administrator one of the important data health checks you can perform is checking that email addresses being...
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...
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 – 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 Management Studio – unable to delete row ‘String or binary data would be truncated’ Problem When attempting to delete a database table row using SQL Management Studio you receive the following error message: No...
SQL Management Studio – ‘Saving changes is not permitted’ message when changing table Problem When designing a table you’re unable to save the changes. When you try you receive the following message: Saving... 1