{"id":833,"date":"2020-04-20T08:06:00","date_gmt":"2020-04-20T08:06:00","guid":{"rendered":"https:\/\/www.sequallity.co.uk\/?p=833"},"modified":"2020-05-06T10:34:12","modified_gmt":"2020-05-06T10:34:12","slug":"how-to-use-between-in-sql-server-demo-examples","status":"publish","type":"post","link":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/","title":{"rendered":"How to use Between in SQL Server Demo Examples"},"content":{"rendered":"\n

How to use the Between Keyword in SQL Server T-SQL: SQL Developer Series<\/h2>\n\n\n\n

Hello and here we have some demos showing how to use Between in SQL Server. The whole script is at the bottom of the post.<\/p>\n\n\n\n

In our Sequallity training<\/a> classes, I’m always banging on about keeping the amount of text down. It just makes it easier for the brain to understand what’s going on with the T-SQL trickery we are looking at.<\/p>\n\n\n\n

So I really like the Between keyword as it reduces the text in a SQL statement. Although it’s not a CASE statement, it simply displays whatever evaluates to true between the two supplied expressions.<\/p>\n\n\n\n

For this example, I’m using the SQL Azure Database:<\/p>\n\n\n\n

\nSELECT @@version<\/code><\/pre>\n\n\n\n
giving…<\/p>\n\n\n\n
\nMicrosoft SQL Azure (RTM) - 12.0.2000.8 \n\tFeb 26 2020 10:26:43 \n\tCopyright (C) 2019 Microsoft Corporation<\/code><\/pre>\n\n\n\n
Simple Between Example<\/h2>\n\n\n\n
OK, so notice the drop table if exists keyword, great if you’re the only one using the table, not so good for many users though…<\/p>\n\n\n\n
\nDROP TABLE IF EXISTS dbo.BetweenKeywordTestInt;\n\nCREATE TABLE dbo.BetweenKeywordTestInt \n(\nStoredNumber INT\n)\n\nINSERT INTO dbo.BetweenKeywordTestInt VALUES (1);\nINSERT INTO dbo.BetweenKeywordTestInt VALUES (2);\nINSERT INTO dbo.BetweenKeywordTestInt VALUES (3);\nINSERT INTO dbo.BetweenKeywordTestInt VALUES (4);\nINSERT INTO dbo.BetweenKeywordTestInt VALUES (5);\n\nSELECT StoredNumber FROM dbo.BetweenKeywordTestInt;<\/code><\/pre>\n\n\n\n
\"Original<\/figure><\/div>\n\n\n\n
So five values in the table, but how does Between work on these integers?<\/p>\n\n\n\n
\nSELECT StoredNumber FROM dbo.BetweenKeywordTestInt \nWHERE StoredNumber BETWEEN 2 AND 3;<\/code><\/pre>\n\n\n\n
\"Between<\/figure><\/div>\n\n\n\n
This gives us 2 and 3, so this seems to be inclusive, right?<\/p>\n\n\n\n
\nSELECT StoredNumber FROM dbo.BetweenKeywordTestInt \nWHERE StoredNumber BETWEEN 4 AND 4;<\/code><\/pre>\n\n\n\n
\"Similar<\/figure><\/div>\n\n\n\n
OK, we can repeat the same number in the from and to expression…so what if we do it all wrong? It has happened before and it will happen again…<\/p>\n\n\n\n
\nSELECT StoredNumber FROM dbo.BetweenKeywordTestInt \nWHERE StoredNumber BETWEEN 5 AND 3;<\/code><\/pre>\n\n\n\n
\"Incorrect<\/figure><\/div>\n\n\n\n
Eek! Now I’ve tried to be too clever…<\/p>\n\n\n\n
How to use NOT BETWEEN in SQL Server<\/h2>\n\n\n\n
\nSELECT StoredNumber FROM dbo.BetweenKeywordTestInt \nWHERE StoredNumber NOT BETWEEN 2 AND 3;<\/code><\/pre>\n\n\n\n
\"How<\/figure><\/div>\n\n\n\n
Now that’s brought back everything not between 2 and 3, ok, makes sense. Ok, so that’s numbers covered but wait, what about…<\/p>\n\n\n\n
How to use Between and Like together in SQL Server<\/h2>\n\n\n\n
What I love about Microsoft’s<\/a> SQL Server is that I learn all the time, and playing, teaching and working with SQL, teaches the intracacies of how it actually works. OK, so let’s flip that integer over to a varchar.<\/p>\n\n\n\n
\nDROP TABLE IF EXISTS dbo.BetweenKeywordTestVarchar;\n\nCREATE TABLE dbo.BetweenKeywordTestVarchar \n(\nStoredText VARCHAR(255)\n)\n\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('Hello,');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('my');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('name');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('is');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('SQLJohn');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('And');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('I');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('know');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('T-SQL');\n\nSELECT StoredText FROM dbo.BetweenKeywordTestVarchar;\n<\/code><\/pre>\n\n\n\n
\"Between<\/figure><\/div>\n\n\n\n
OK, let’s use between and some characters now…<\/p>\n\n\n\n
\nSELECT StoredText FROM dbo.BetweenKeywordTestVarchar \nWHERE StoredText BETWEEN 'n' AND 'z';<\/code><\/pre>\n\n\n\n
\"Between<\/figure><\/div>\n\n\n\n
OK, so the query brought back everything between n and z. That’s cool. OK, so let’s put in some more data…<\/p>\n\n\n\n
\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('Nzzz');<\/code><\/pre>\n\n\n\n
And…<\/p>\n\n\n\n
\nSELECT StoredText FROM dbo.BetweenKeywordTestVarchar\nWHERE storedtext BETWEEN 'Nz%' AND 'Z';<\/code><\/pre>\n\n\n\n
\"Between<\/figure><\/div>\n\n\n\n
OK so the percent wildcard seems to work in the between keyword. Let’s now put in Nz only…<\/p>\n\n\n\n
\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('Nz');\n<\/code><\/pre>\n\n\n\n
\nSELECT StoredText FROM dbo.BetweenKeywordTestVarchar \n        WHERE storedtext BETWEEN 'Nz%' AND 'Z';<\/code><\/pre>\n\n\n\n
\"Missing<\/figure><\/div>\n\n\n\n
Notice how the query is not bringing back the new Nz when I think it should and an essential rule of a good DBA\/Developer, always check your work…<\/p>\n\n\n\n
\nSELECT StoredText FROM dbo.BetweenKeywordTestVarchar\n\tWHERE storedtext LIKE 'Nz%';<\/code><\/pre>\n\n\n\n
\"Between<\/figure><\/div>\n\n\n\n
And yes, it does exist in the table so the Wildcard does not work in Between.<\/p>\n\n\n\n
Between Conclusion<\/h2>\n\n\n\n
A really nice keyword and is inclusive but you can use LIKE but not with a wildcard, which kind of makes sense with some simple demos of how to use Between in SQL Server T-SQL.<\/p>\n\n\n\n
Full Between Demo Script<\/h2>\n\n\n\n
\nSELECT @@version\n\n-- Between and Integers\nDROP TABLE IF EXISTS dbo.BetweenKeywordTestInt;\n\nCREATE TABLE dbo.BetweenKeywordTestInt \n(\nStoredNumber INT\n)\n\nINSERT INTO dbo.BetweenKeywordTestInt VALUES (1);\nINSERT INTO dbo.BetweenKeywordTestInt VALUES (2);\nINSERT INTO dbo.BetweenKeywordTestInt VALUES (3);\nINSERT INTO dbo.BetweenKeywordTestInt VALUES (4);\nINSERT INTO dbo.BetweenKeywordTestInt VALUES (5);\n\nSELECT StoredNumber FROM dbo.BetweenKeywordTestInt;\n\nSELECT StoredNumber FROM dbo.BetweenKeywordTestInt \nWHERE StoredNumber BETWEEN 2 AND 3;\n\nSELECT StoredNumber FROM dbo.BetweenKeywordTestInt \nWHERE StoredNumber BETWEEN 4 AND 4;\n\nSELECT StoredNumber FROM dbo.BetweenKeywordTestInt \nWHERE StoredNumber BETWEEN 5 AND 3;\n\n--NOT Between\nSELECT StoredNumber FROM dbo.BetweenKeywordTestInt \nWHERE StoredNumber NOT BETWEEN 2 AND 3;\n\n\n-- Between and Characters\nDROP TABLE IF EXISTS dbo.BetweenKeywordTestVarchar;\n\nCREATE TABLE dbo.BetweenKeywordTestVarchar \n(\nStoredText VARCHAR(255)\n)\n\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('Hello,');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('my');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('name');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('is');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('SQLJohn');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('And');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('I');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('know');\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('T-SQL');\n\nSELECT StoredText FROM dbo.BetweenKeywordTestVarchar;\n\nSELECT StoredText FROM dbo.BetweenKeywordTestVarchar \nWHERE StoredText BETWEEN 'n' AND 'z';\n\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('Nzzz');\n\nSELECT StoredText FROM dbo.BetweenKeywordTestVarchar \nWHERE storedtext BETWEEN 'Nz%' AND 'Z';\n\nINSERT INTO dbo.BetweenKeywordTestVarchar VALUES ('Nz');\n\nSELECT StoredText FROM dbo.BetweenKeywordTestVarchar\nWHERE storedtext BETWEEN 'Nz%' AND 'Z';\n\nSELECT StoredText FROM dbo.BetweenKeywordTestVarchar\nWHERE storedtext LIKE 'Nz%';\n<\/code><\/pre>\n\n\n\n
I will do a future post on SQL Server datetimes and how interesting\/esoteric they are.<\/p>\n\n\n\n
Please check out our warranty<\/a> page.<\/p>\n","protected":false},"excerpt":{"rendered":"
How to use the Between Keyword in SQL Server T-SQL: SQL Developer Series Hello and here we have some demos showing how to use Between in SQL Server. The whole script is at the bottom of the post. In our Sequallity training classes, I’m always banging on about keeping the amount of text down. It just makes it easier for the brain to understand what’s going on with the T-SQL<\/p>\n
Read More<\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"footnotes":""},"categories":[756,755],"tags":[757,758,759],"class_list":["post-833","post","type-post","status-publish","format-standard","hentry","category-between","category-t-sql","tag-between","tag-like","tag-wildcard"],"yoast_head":"\nHow to use between in SQL Server plus also Between and Like Examples<\/title>\n<meta name=\"description\" content=\"Simple demo examples of how to use Between in SQL Server T-SQL. Between is a great keyword for reducing text, find out how.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use Between in SQL Server Demo Examples\" \/>\n<meta property=\"og:description\" content=\"Simple demo examples of how to use Between in SQL Server T-SQL. Between is a great keyword for reducing text, find out how.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Server Consultancy and SQL Server Training\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-20T08:06:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-06T10:34:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2020\/04\/image-1.png\" \/>\n<meta name=\"author\" content=\"John Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sequallity\" \/>\n<meta name=\"twitter:site\" content=\"@sequallity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/\"},\"author\":{\"name\":\"John Parker\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f\"},\"headline\":\"How to use Between in SQL Server Demo Examples\",\"datePublished\":\"2020-04-20T08:06:00+00:00\",\"dateModified\":\"2020-05-06T10:34:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/\"},\"wordCount\":466,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\"},\"keywords\":[\"Between\",\"Like\",\"Wildcard\"],\"articleSection\":[\"Between\",\"T-SQL\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/\",\"name\":\"How to use between in SQL Server plus also Between and Like Examples\",\"isPartOf\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website\"},\"datePublished\":\"2020-04-20T08:06:00+00:00\",\"dateModified\":\"2020-05-06T10:34:12+00:00\",\"description\":\"Simple demo examples of how to use Between in SQL Server T-SQL. Between is a great keyword for reducing text, find out how.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T-SQL\",\"item\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/t-sql\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to use Between in SQL Server Demo Examples\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\",\"name\":\"SQL Server Consultancy and SQL Server Training\",\"description\":\"where SQL and Quality join...\",\"publisher\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\",\"name\":\"Sequallity Limited\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg\",\"contentUrl\":\"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg\",\"width\":800,\"height\":229,\"caption\":\"Sequallity Limited\"},\"image\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/\",\"https:\/\/twitter.com\/sequallity\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f\",\"name\":\"John Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g\",\"caption\":\"John Parker\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to use between in SQL Server plus also Between and Like Examples","description":"Simple demo examples of how to use Between in SQL Server T-SQL. Between is a great keyword for reducing text, find out how.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/","og_locale":"en_GB","og_type":"article","og_title":"How to use Between in SQL Server Demo Examples","og_description":"Simple demo examples of how to use Between in SQL Server T-SQL. Between is a great keyword for reducing text, find out how.","og_url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/","og_site_name":"SQL Server Consultancy and SQL Server Training","article_publisher":"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/","article_published_time":"2020-04-20T08:06:00+00:00","article_modified_time":"2020-05-06T10:34:12+00:00","og_image":[{"url":"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2020\/04\/image-1.png"}],"author":"John Parker","twitter_card":"summary_large_image","twitter_creator":"@sequallity","twitter_site":"@sequallity","twitter_misc":{"Written by":"John Parker","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/#article","isPartOf":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/"},"author":{"name":"John Parker","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f"},"headline":"How to use Between in SQL Server Demo Examples","datePublished":"2020-04-20T08:06:00+00:00","dateModified":"2020-05-06T10:34:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/"},"wordCount":466,"commentCount":0,"publisher":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization"},"keywords":["Between","Like","Wildcard"],"articleSection":["Between","T-SQL"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/","name":"How to use between in SQL Server plus also Between and Like Examples","isPartOf":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website"},"datePublished":"2020-04-20T08:06:00+00:00","dateModified":"2020-05-06T10:34:12+00:00","description":"Simple demo examples of how to use Between in SQL Server T-SQL. Between is a great keyword for reducing text, find out how.","breadcrumb":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/how-to-use-between-in-sql-server-demo-examples\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/"},{"@type":"ListItem","position":2,"name":"T-SQL","item":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/t-sql\/"},{"@type":"ListItem","position":3,"name":"How to use Between in SQL Server Demo Examples"}]},{"@type":"WebSite","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/","name":"SQL Server Consultancy and SQL Server Training","description":"where SQL and Quality join...","publisher":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization","name":"Sequallity Limited","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/","url":"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg","contentUrl":"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg","width":800,"height":229,"caption":"Sequallity Limited"},"image":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/","https:\/\/twitter.com\/sequallity"]},{"@type":"Person","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f","name":"John Parker","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g","caption":"John Parker"}}]}},"_links":{"self":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/833","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/comments?post=833"}],"version-history":[{"count":15,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/833\/revisions"}],"predecessor-version":[{"id":874,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/833\/revisions\/874"}],"wp:attachment":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/media?parent=833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/categories?post=833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/tags?post=833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}