Skip to content

Instantly share code, notes, and snippets.

View jedidja's full-sized avatar

Jedidja jedidja

View GitHub Profile
@jedidja
jedidja / sproc_dependencies.sql
Last active July 4, 2024 09:20
Get a list of tables and views referenced by sproc in SQL Server
(Generated by Claude 3.5 Sonnet)
-- Notes:
-- It won't catch tables referenced in dynamic SQL.
-- It may not catch deeply nested dependencies (e.g., views referencing other views).
-- It doesn't distinguish between read and write operations.
CREATE OR ALTER PROCEDURE sp_GetTableNames
@ProcedureName NVARCHAR(128)
AS

Keybase proof

I hereby claim:

  • I am jedidja on github.
  • I am jedidja (https://keybase.io/jedidja) on keybase.
  • I have a public key whose fingerprint is 0021 0801 E5A8 3548 7F43 126D 8EA2 2CEA B5D5 6578

To claim this, I am signing this object:

@jedidja
jedidja / about_scoring_project.rb
Created November 16, 2010 19:16
Ruby Koans - Scoring Project
require File.expand_path(File.dirname(__FILE__) + '/edgecase')
# Greed is a dice game where you roll up to five dice to accumulate
# points. The following "score" function will be used calculate the
# score of a single roll of the dice.
#
# A greed roll is scored as follows:
#
# * A set of three ones is 1000 points
#