SQL Server Exists PredicateThe term “predicate” is used to refer to an expression that determines whether something is true or false. […] November 23, 2017 in SQL Server tagged null / predicate / subquery / exists by Mike
SQL Server Searching for WordsThis post discusses the query you will need to be able to search inside a column in a […] November 23, 2017 in SQL Server tagged search / validation / exists / string / like by Mike
SQL Server ViewsA SQL Server view is a type of table expression. A View is stored in the database (with […] August 9, 2017 in SQL Server tagged sys / encryption / create / objects / search / exists / view / views by Mike
SQL Server Sequential Numbers Part 2This post is part 2 in our series of generating sequential numbers in SQL Server. In this post […] June 15, 2017 in SQL Server tagged row_number / sequence / sequential / exists / over / SQL Server Sequential Numbers by Mike
SQL Server Drop a Table If ExistsSometimes when you are looking for sql code online you find that people give example code that includes […] May 17, 2017 in SQL Server tagged delete / drop / exists by Mike
SQL Server Check If File ExistsIn this post we will review a function that we have used in another post. This SQL Server […] April 9, 2017 in SQL Server tagged file / exists by Mike