Trying to share some code ideas


Author: Michael_M Page 1 of 6

Temporal Tables

Where we are going, we need to keep track of the history in the tables.

How to set up and use Temporal Tables in Microsoft SQL Microsoft SQL has native support for keeping track of Insert / Update / Delete from system versioned tables. The following explains how to set up and use temporal tables in Microsoft SQL.

Foreign Key List

Query to show foreign keys for specified table and or column

Search Value in Multiple Columns

Where is it? WHERE IS IT? WHERE????

Sometimes you need to search for a value in the table, but you have no idea where it is. The query will use a cursor allowing you to search through multiple tables and multiple columns to find the value.

Date Format List

Stop searching the web for date formats, query the database

Michael M.

Simple query to show you all the date time formats in the database.

Code for View

Show the DDL Code for a View

Check Login Security

Show the user’s login security

Dashboard – Service Line

Dashboard – Service Line

Dashboard showing summary statistics by Hospital’s different Service Lines. Showing statistics about number of patients, number of encounters, surgical volume, and case mix.

Dashboard – Survey

Dashboard – Survey

Dashboard tracking students responses to organizational learning sessions. Students would rate the course, instructor, self-evaluations, and provide free-form comments.

Dashboard – Spiritual Health

Dashboard – Spiritual Health

Dashboard tracking the contacts between spiritual advisors and patients. Spiritual advisors can be for a specific religious denomination or non-denominational. The dashboard was used to ensure the hospital was in compliance with anti-discrimination laws.

Dashboard – Research Studies

Dashboard – Research Studies

Tracking research studies at the hospital by type of study and number of participants in the study.

Page 1 of 6

Powered by WordPress & Theme by Anders Norén