Skip to content

Instantly share code, notes, and snippets.

/SQLDinamikSorgu.sql Secret

Created September 18, 2016 09:45
Show Gist options
  • Save anonymous/a13568b18310ae526b3e0507f5d7ffee to your computer and use it in GitHub Desktop.
Save anonymous/a13568b18310ae526b3e0507f5d7ffee to your computer and use it in GitHub Desktop.
Download ZIP
SQL Dinamik Sorgu
Raw
SQLDinamikSorgu.sql
-- SQL Dinamik Sorgu
create proc BizimProcedure @tablo1Adi varchar(64),@tablo2Adi varchar(64),@ilkTablodakiKolon varchar(64),@ikinciTablodakiKolon varchar(64)
as
DECLARE @sorgu varchar(max) = ''
set @sorgu = 'select * from ' + @tablo1Adi + ' t1 join ' + @tablo2Adi + ' t2 on t1.' + @ilkTablodakiKolon + ' = t2.' + @ikinciTablodakiKolon
exec (@sorgu)
BizimProcedure 'Analiz20160914','Analiz20160917','MatchDate','MatchDate'
-- http://ercanbozkurt.blogspot.com
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment