WHILE <condition>\nBEGIN\n -- SQL statements to execute repeatedly\nEND<\/code><\/pre>\nExample Usage<\/h4>\n
Let’s consider a scenario where we need to insert multiple records into a table for testing purposes:<\/p>\n
-- Declare and initialize a counter variable\nDECLARE @Counter INT = 1;\n\n-- Loop to insert 10 test records\nWHILE @Counter <= 10\nBEGIN\n INSERT INTO Employees (Name, Position)\n VALUES ('Employee ' + CAST(@Counter AS VARCHAR(2)), 'Test Position');\n\n -- Increment the counter\n SET @Counter = @Counter + 1;\nEND<\/code><\/pre>\nExplanation:<\/strong><\/p>\n\n- We declare a variable
@Counter<\/code> and initialize it to 1<\/code>.<\/li>\n- The
WHILE<\/code> loop checks if @Counter<\/code> is less than or equal to 10<\/code>.<\/li>\n- Inside the loop, we insert a new record into the
Employees<\/code> table.<\/li>\n- We then increment
@Counter<\/code> by 1<\/code>.<\/li>\n- The loop continues until
@Counter<\/code> exceeds 10<\/code>.<\/li>\n<\/ul>\nWhy Use Loops?<\/h4>\n\n- Automating Repetitive Tasks:<\/strong> Loops are ideal for performing repetitive operations without manually writing multiple statements.<\/li>\n
- Dynamic Data Processing:<\/strong> They allow for dynamic manipulation of data sets, such as processing records until a condition is met.<\/li>\n
- Complex Calculations:<\/strong> Loops can handle complex calculations that require iterative logic.<\/li>\n<\/ul>\n
Important Considerations<\/h4>\n\n- Termination Condition:<\/strong> Always ensure your loop has a proper termination condition to avoid infinite loops.<\/li>\n
- Performance Impact:<\/strong> Excessive use of loops can lead to performance degradation. Whenever possible, leverage set-based operations for better efficiency.<\/li>\n<\/ul>\n
The CASE<\/code> Expression in T-SQL<\/h3>\nOverview<\/h4>\n
The CASE<\/code> expression is a versatile tool for implementing conditional logic within your SQL statements, especially in SELECT<\/code>, UPDATE<\/code>, and ORDER BY<\/code> clauses. It evaluates a list of conditions and returns one of multiple possible result expressions.<\/p>\nBasic Syntax<\/h4>\n
There are two forms of the CASE<\/code> expression:<\/p>\n\n- Simple CASE Expression:<\/strong><\/li>\n<\/ol>\n
CASE input_expression\n WHEN when_expression THEN result_expression\n [ ...n ]\n [ ELSE else_result_expression ]\nEND<\/code><\/pre>\n\n- Searched CASE Expression:<\/strong><\/li>\n<\/ol>\n
CASE\n WHEN boolean_expression THEN result_expression\n [ ...n ]\n [ ELSE else_result_expression ]\nEND<\/code><\/pre>\nExample Usage<\/h4>\n
Scenario:<\/strong> We want to categorize employees based on their years of service.<\/p>\nUsing a Searched CASE Expression:<\/strong><\/p>\nSELECT\n Name,\n YearsOfService,\n CASE\n WHEN YearsOfService >= 10 THEN 'Veteran'\n WHEN YearsOfService >= 5 THEN 'Experienced'\n WHEN YearsOfService >= 1 THEN 'Intermediate'\n ELSE 'Newcomer'\n END AS ServiceLevel\nFROM Employees;<\/code><\/pre>\nExplanation:<\/strong><\/p>\n\n- The
CASE<\/code> expression evaluates the YearsOfService<\/code> for each employee.<\/li>\n- Depending on the value, it assigns a
ServiceLevel<\/code> category.<\/li>\n- The
ELSE<\/code> clause handles any cases not covered by the WHEN<\/code> conditions.<\/li>\n<\/ul>\nWhy Use CASE<\/code> Expressions?<\/h4>\n\n- Conditional Data Transformation:<\/strong> Modify output data without changing the underlying data.<\/li>\n
- Dynamic Sorting and Grouping:<\/strong> Use conditions to sort or group data in queries.<\/li>\n
- Simplify Complex Queries:<\/strong> Reduce the need for multiple queries or joins by handling logic within a single query.<\/li>\n<\/ul>\n
Advanced Usage<\/h4>\n
Nested CASE<\/code> Expressions:<\/strong><\/p>\nYou can nest CASE<\/code> expressions for more complex logic:<\/p>\nSELECT\n Name,\n CASE\n WHEN Department = 'Sales' THEN\n CASE\n WHEN SalesAmount >= 100000 THEN 'Top Performer'\n ELSE 'Regular Performer'\n END\n ELSE 'Non-Sales'\n END AS PerformanceCategory\nFROM Employees;<\/code><\/pre>\nUsing CASE<\/code> in ORDER BY<\/code>:<\/strong><\/p>\nSELECT Name, HireDate\nFROM Employees\nORDER BY\n CASE WHEN HireDate IS NULL THEN 1 ELSE 0 END,\n HireDate;<\/code><\/pre>\nThis sorts the results by pushing all NULL<\/code> HireDate<\/code> values to the bottom.<\/p>\nCombining Loops and Conditional Logic<\/h3>\nPractical Example<\/h4>\n
Suppose we want to update employee records in batches and categorize them based on some complex criteria:<\/p>\n
-- Declare variables\nDECLARE @BatchSize INT = 100;\nDECLARE @MinEmployeeID INT = 1;\nDECLARE @MaxEmployeeID INT = (SELECT MAX(EmployeeID) FROM Employees);\nDECLARE @CurrentEmployeeID INT = @MinEmployeeID;\n\nWHILE @CurrentEmployeeID <= @MaxEmployeeID\nBEGIN\n -- Update a batch of records\n UPDATE Employees\n SET Category = CASE\n WHEN Salary >= 100000 THEN 'Executive'\n WHEN Salary >= 70000 THEN 'Senior Staff'\n ELSE 'Staff'\n END\n WHERE EmployeeID BETWEEN @CurrentEmployeeID AND (@CurrentEmployeeID + @BatchSize - 1);\n\n -- Increment to the next batch\n SET @CurrentEmployeeID = @CurrentEmployeeID + @BatchSize;\nEND<\/code><\/pre>\nExplanation:<\/strong><\/p>\n\n- We process employees in batches of 100 to manage transaction sizes.<\/li>\n
- Within each batch, we use a
CASE<\/code> expression to categorize employees based on their salary.<\/li>\n- This approach is efficient for large data sets and maintains control over resource utilization.<\/li>\n<\/ul>\n
Best Practices<\/h3>\n\n- Optimize Loops:<\/strong> Limit the use of loops for operations that cannot be achieved with set-based queries. Loops are less efficient than set-based operations in SQL Server.<\/li>\n
- Use
CASE<\/code> Wisely:<\/strong> While CASE<\/code> expressions are powerful, ensure that the conditions are not overly complex, which could impact query performance.<\/li>\n- Error Handling:<\/strong> Incorporate error handling mechanisms like
TRY...CATCH<\/code> blocks (which we’ll cover in a future post) to gracefully handle exceptions within loops.<\/li>\n<\/ul>\nConclusion<\/h3>\n
In this installment, we’ve expanded our T-SQL toolkit with the WHILE<\/code> loop and CASE<\/code> expressions, two constructs that significantly enhance the ability to perform iterative and conditional operations within SQL Server. Understanding when and how to use these tools allows you to write more dynamic and efficient scripts, tailor queries to specific needs, and handle complex data manipulation tasks directly within the database.<\/p>\nStay tuned for the next post in our series, where we’ll explore error handling with TRY...CATCH<\/code> blocks and discuss transaction management in T-SQL. These concepts are crucial for building robust and reliable SQL scripts that can handle real-world database operations gracefully.<\/p>\n","protected":false},"excerpt":{"rendered":"Welcome back to our series on programming constructs in T-SQL! In Part 1 of this series, we explored the fundamentals of variables and conditional IF statements, laying the groundwork for dynamic and efficient SQL scripting. In this second installment, we’ll delve deeper into T-SQL by examining two more powerful constructs: Loops (specifically the WHILE loop) and CASE Expressions. Understanding these constructs will enable you to handle repetitive tasks and implement conditional logic directly within your SQL queries, further enhancing the flexibility and capability of your scripts.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[91,84,78,21],"tags":[347,349,345,348,131,350,344,346],"class_list":["post-849","post","type-post","status-publish","format-standard","hentry","category-query-optimization","category-sql-developer","category-tsql","category-tutorial","tag-case-expressions","tag-sql-control-flow","tag-sql-programming","tag-sql-scripting","tag-sql-server","tag-sql-tutorial","tag-t-sql","tag-t-sql-loops"],"yoast_head":"\n
Exploring Programming Constructs in T-SQL \u2013 Part 2: Loops and CASE Expressions - SQL Table Talk<\/title>\n<meta name=\"description\" content=\"Welcome back to our series on programming constructs in T-SQL! In Part 1 of this series, we explored the fundamentals of variables and conditional IF statements, laying the groundwork for dynamic and efficient SQL scripting. In this second installment, we'll delve deeper into T-SQL by examining two more powerful constructs: Loops (specifically the WHILE loop) and CASE Expressions. Understanding these constructs will enable you to handle repetitive tasks and implement conditional logic directly within your SQL queries, further enhancing the flexibility and capability of your scripts.\" \/>\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.sqltabletalk.com\/?p=849\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exploring Programming Constructs in T-SQL \u2013 Part 2: Loops and CASE Expressions - SQL Table Talk\" \/>\n<meta property=\"og:description\" content=\"Welcome back to our series on programming constructs in T-SQL! In Part 1 of this series, we explored the fundamentals of variables and conditional IF statements, laying the groundwork for dynamic and efficient SQL scripting. In this second installment, we'll delve deeper into T-SQL by examining two more powerful constructs: Loops (specifically the WHILE loop) and CASE Expressions. Understanding these constructs will enable you to handle repetitive tasks and implement conditional logic directly within your SQL queries, further enhancing the flexibility and capability of your scripts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqltabletalk.com\/?p=849\" \/>\n<meta property=\"og:site_name\" content=\"SQL Table Talk\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-01T13:00:00+00:00\" \/>\n<meta name=\"author\" content=\"Stephen Planck\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stephen Planck\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=849#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=849\"},\"author\":{\"name\":\"Stephen Planck\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"headline\":\"Exploring Programming Constructs in T-SQL \u2013 Part 2: Loops and CASE Expressions\",\"datePublished\":\"2024-11-01T13:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=849\"},\"wordCount\":677,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"keywords\":[\"CASE Expressions\",\"SQL Control Flow\",\"SQL Programming\",\"SQL Scripting\",\"SQL Server\",\"SQL Tutorial\",\"T-SQL\",\"T-SQL Loops\"],\"articleSection\":[\"Query Optimization\",\"SQL Developer\",\"TSQL\",\"Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=849#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=849\",\"url\":\"https:\/\/www.sqltabletalk.com\/?p=849\",\"name\":\"Exploring Programming Constructs in T-SQL \u2013 Part 2: Loops and CASE Expressions - SQL Table Talk\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\"},\"datePublished\":\"2024-11-01T13:00:00+00:00\",\"description\":\"Welcome back to our series on programming constructs in T-SQL! In Part 1 of this series, we explored the fundamentals of variables and conditional IF statements, laying the groundwork for dynamic and efficient SQL scripting. In this second installment, we'll delve deeper into T-SQL by examining two more powerful constructs: Loops (specifically the WHILE loop) and CASE Expressions. Understanding these constructs will enable you to handle repetitive tasks and implement conditional logic directly within your SQL queries, further enhancing the flexibility and capability of your scripts.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=849#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=849\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=849#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqltabletalk.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exploring Programming Constructs in T-SQL \u2013 Part 2: Loops and CASE Expressions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\",\"url\":\"https:\/\/www.sqltabletalk.com\/\",\"name\":\"SQL Table Talk\",\"description\":\"Breaking Down SQL Server, One Post at a Time.\",\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqltabletalk.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\",\"name\":\"Stephen Planck\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"caption\":\"Stephen Planck\"},\"logo\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/dexterwiki.com\",\"https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI\",\"https:\/\/www.youtube.com\/linuxmate\"],\"url\":\"https:\/\/www.sqltabletalk.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exploring Programming Constructs in T-SQL \u2013 Part 2: Loops and CASE Expressions - SQL Table Talk","description":"Welcome back to our series on programming constructs in T-SQL! In Part 1 of this series, we explored the fundamentals of variables and conditional IF statements, laying the groundwork for dynamic and efficient SQL scripting. In this second installment, we'll delve deeper into T-SQL by examining two more powerful constructs: Loops (specifically the WHILE loop) and CASE Expressions. Understanding these constructs will enable you to handle repetitive tasks and implement conditional logic directly within your SQL queries, further enhancing the flexibility and capability of your scripts.","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.sqltabletalk.com\/?p=849","og_locale":"en_US","og_type":"article","og_title":"Exploring Programming Constructs in T-SQL \u2013 Part 2: Loops and CASE Expressions - SQL Table Talk","og_description":"Welcome back to our series on programming constructs in T-SQL! In Part 1 of this series, we explored the fundamentals of variables and conditional IF statements, laying the groundwork for dynamic and efficient SQL scripting. In this second installment, we'll delve deeper into T-SQL by examining two more powerful constructs: Loops (specifically the WHILE loop) and CASE Expressions. Understanding these constructs will enable you to handle repetitive tasks and implement conditional logic directly within your SQL queries, further enhancing the flexibility and capability of your scripts.","og_url":"https:\/\/www.sqltabletalk.com\/?p=849","og_site_name":"SQL Table Talk","article_published_time":"2024-11-01T13:00:00+00:00","author":"Stephen Planck","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stephen Planck","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqltabletalk.com\/?p=849#article","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/?p=849"},"author":{"name":"Stephen Planck","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"headline":"Exploring Programming Constructs in T-SQL \u2013 Part 2: Loops and CASE Expressions","datePublished":"2024-11-01T13:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqltabletalk.com\/?p=849"},"wordCount":677,"commentCount":0,"publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"keywords":["CASE Expressions","SQL Control Flow","SQL Programming","SQL Scripting","SQL Server","SQL Tutorial","T-SQL","T-SQL Loops"],"articleSection":["Query Optimization","SQL Developer","TSQL","Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqltabletalk.com\/?p=849#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqltabletalk.com\/?p=849","url":"https:\/\/www.sqltabletalk.com\/?p=849","name":"Exploring Programming Constructs in T-SQL \u2013 Part 2: Loops and CASE Expressions - SQL Table Talk","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/#website"},"datePublished":"2024-11-01T13:00:00+00:00","description":"Welcome back to our series on programming constructs in T-SQL! In Part 1 of this series, we explored the fundamentals of variables and conditional IF statements, laying the groundwork for dynamic and efficient SQL scripting. In this second installment, we'll delve deeper into T-SQL by examining two more powerful constructs: Loops (specifically the WHILE loop) and CASE Expressions. Understanding these constructs will enable you to handle repetitive tasks and implement conditional logic directly within your SQL queries, further enhancing the flexibility and capability of your scripts.","breadcrumb":{"@id":"https:\/\/www.sqltabletalk.com\/?p=849#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqltabletalk.com\/?p=849"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqltabletalk.com\/?p=849#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqltabletalk.com\/"},{"@type":"ListItem","position":2,"name":"Exploring Programming Constructs in T-SQL \u2013 Part 2: Loops and CASE Expressions"}]},{"@type":"WebSite","@id":"https:\/\/www.sqltabletalk.com\/#website","url":"https:\/\/www.sqltabletalk.com\/","name":"SQL Table Talk","description":"Breaking Down SQL Server, One Post at a Time.","publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqltabletalk.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0","name":"Stephen Planck","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","caption":"Stephen Planck"},"logo":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/dexterwiki.com","https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI","https:\/\/www.youtube.com\/linuxmate"],"url":"https:\/\/www.sqltabletalk.com\/?author=1"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/849","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=849"}],"version-history":[{"count":3,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/849\/revisions"}],"predecessor-version":[{"id":852,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/849\/revisions\/852"}],"wp:attachment":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}