When amending data in a large SQL database it makes sense that the bread-and-butter command is the classic UPDATE statement. this statement is reasonably simple and has the following syntax: (the MSDN link is here: https://msdn.microsoft.com/en-us/library/ms177523.aspx ) UPDATE TABLE_NAME SET column1=value1,column2=value2,…… Continue Reading
You will likely be aware of the ‘like’ operator and its use and the common use of the % symbol to denote a string of 0 or greater length of any characters. What you may not know is how to… Continue Reading
Querying the sys, tables in a database can make looking for references to objects or listing out columns a very simple task. Whilst the tables being queried hold a lot of interesting and useful information it’s generally necessary to be… Continue Reading