# \#sql-server
**URL:** https://forum.innovativeusers.org/tag/sql-server/59.md
[Latest](https://forum.innovativeusers.org/latest.md) · [Categories](https://forum.innovativeusers.org/categories.md) · [Tags](https://forum.innovativeusers.org/tags.md)
---
## [Working with JSON Data in SQL Server](https://forum.innovativeusers.org/t/working-with-json-data-in-sql-server/2841)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\
**Replies:** 1\
**Last updated:** [February 24, 2026, 4:42pm UTC](https://forum.innovativeusers.org/t/working-with-json-data-in-sql-server/2841 "2026-02-24T16:42:32Z")
I read with interest this article in SQL Server Central about working with JSON data in SQL Server. The Polaris folks encountering JSON in logs or anyone working with JSON in OpenRefine may find this useful. Enjoy!
---
## [SQL EXISTS Use Cases and Examples](https://forum.innovativeusers.org/t/sql-exists-use-cases-and-examples/2675)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\
**Replies:** 0\
**Last updated:** [October 23, 2025, 2:02am UTC](https://forum.innovativeusers.org/t/sql-exists-use-cases-and-examples/2675 "2025-10-23T02:02:38Z")
This SQL tutorial will explain what the keyword EXISTS does and show several different use cases.
---
## [Converting and Conveying MARC Records Into and Out of Databases to Gather Specific Records](https://forum.innovativeusers.org/t/converting-and-conveying-marc-records-into-and-out-of-databases-to-gather-specific-records/2564)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\
**Replies:** 3\
**Last updated:** [July 31, 2025, 10:33pm UTC](https://forum.innovativeusers.org/t/converting-and-conveying-marc-records-into-and-out-of-databases-to-gather-specific-records/2564 "2025-07-31T22:33:33Z")
Abstract I was recently asked to find a way to gather a specific set of MARC records from a compiled MARC file based upon a list of item barcodes in an Excel spreadsheet. Seeing as how my response to most problems is “C…
---
## [Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD](https://forum.innovativeusers.org/t/date-and-time-calculations-made-easy-with-eomonth-datediff-and-dateadd/2467)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\
**Replies:** 0\
**Last updated:** [May 9, 2025, 8:14am UTC](https://forum.innovativeusers.org/t/date-and-time-calculations-made-easy-with-eomonth-datediff-and-dateadd/2467 "2025-05-09T08:14:21Z")
In this article, the author walks through three of the most useful date functions: EOMONTH, DATEDIFF, and DATEADD. See what each one does, how it works, and how you can use them in your own queries.
---
## [Understanding CROSS APPLY and OUTER APPLY in SQL Server](https://forum.innovativeusers.org/t/understanding-cross-apply-and-outer-apply-in-sql-server/2456)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\
**Replies:** 0\
**Last updated:** [April 23, 2025, 1:41am UTC](https://forum.innovativeusers.org/t/understanding-cross-apply-and-outer-apply-in-sql-server/2456 "2025-04-23T01:41:16Z")
When working with table-valued functions (TVFs) or subqueries, the CROSS APPLY and OUTER APPLY operators provide flexible ways to enhance SQL queries. While these operators might seem complex at first, understanding how…
---
## [Dynamic T-SQL Script Parameterization Using Python](https://forum.innovativeusers.org/t/dynamic-t-sql-script-parameterization-using-python/2368)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\
**Replies:** 0\
**Last updated:** [March 24, 2025, 11:00am UTC](https://forum.innovativeusers.org/t/dynamic-t-sql-script-parameterization-using-python/2368 "2025-03-24T11:00:12Z")
One thing I never quite got around to in my Intermediate SQL session at IUG 2025 was to recommend the helpful resource SQL Server Central, not only for the Polaris attendees but for anyone writing SQL. This morning’s ar…
---
## [Get a List and Schedule of SQL Server Jobs](https://forum.innovativeusers.org/t/get-a-list-and-schedule-of-sql-server-jobs/1990)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\
**Replies:** 1\
**Last updated:** [September 4, 2024, 3:06pm UTC](https://forum.innovativeusers.org/t/get-a-list-and-schedule-of-sql-server-jobs/1990 "2024-09-04T15:06:49Z")
This query pulls a list of SQL jobs set up in SQL Server along with all the information connected to them like frequency, start time, end time, intervals and so on. It’s particularly useful if you need to back up, clone,…
---
## [SQL Updates to the Polaris database](https://forum.innovativeusers.org/t/sql-updates-to-the-polaris-database/1894)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\
**Replies:** 6\
**Last updated:** [July 18, 2024, 4:33pm UTC](https://forum.innovativeusers.org/t/sql-updates-to-the-polaris-database/1894 "2024-07-18T16:33:17Z")
We are changing the name of a branch next month but keeping the same location codes for that branch. The first dozen characters of 200+ location names will have to change. Here’s the catch: We are a Sierra library and…
---
## [Search SQL Server for specific terms](https://forum.innovativeusers.org/t/search-sql-server-for-specific-terms/1581)
**Author:** [@jtenter](https://forum.innovativeusers.org/u/jtenter)\
**Replies:** 0\
**Last updated:** [November 23, 2023, 8:08pm UTC](https://forum.innovativeusers.org/t/search-sql-server-for-specific-terms/1581 "2023-11-23T20:08:12Z")
These scripts allow you to search SQL Server stored procedures, jobs and table columns to find a specific word. In particular I’ve found the stored procedure / job script useful for looking for pieces of code related to…
---
## [Failed Job Step Email Alert](https://forum.innovativeusers.org/t/failed-job-step-email-alert/1580)
**Author:** [@jtenter](https://forum.innovativeusers.org/u/jtenter)\
**Replies:** 0\
**Last updated:** [November 23, 2023, 7:55pm UTC](https://forum.innovativeusers.org/t/failed-job-step-email-alert/1580 "2023-11-23T19:55:55Z")
This script emails an alert when job steps in SQL Server fail. I’ve found it useful for keeping an eye on Polaris overnight jobs failing which may impact functionality that day, problems that have come up with our own j…