Query to show foreign keys for specified table and or column
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.
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.
Show the DDL Code for a View
Show the user’s login security
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
SELECT sys.dm_exec_connections.session_id AS SPID , sys.dm_exec_connections.connect_time AS Connect_Time , DB_NAME(dbid) AS DatabaseName , loginame AS LoginName , sys.dm_exec_connections.auth_scheme as Auth_Scheme , sys.dm_exec_connections.net_transport AS Net_Transport , sys.dm_exec_connections.protocol_type as Protocol_Type , sys.dm_exec_connections.client_net_address as Client_Net_Address , sys.dm_exec_connections.local_net_address as Local_Net_Address , sys.dm_exec_connections.local_tcp_port as Local_TCP_Port FROM sys.sysprocesses Right Outer JOIN sys.dm_exec_connections ON sys.sysprocesses.spid=sys.dm_exec_connections.session_id Order By Auth_Scheme, Net_Transport ; |
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 tracking students responses to organizational learning sessions. Students would rate the course, instructor, self-evaluations, and provide free-form comments.
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
Tracking research studies at the hospital by type of study and number of participants in the study.
Dashboard – Covid
Tracking the Covid variant by incidents, lineage, location and patent demographics