> For the complete documentation index, see [llms.txt](https://docs.layraweb.com.tr/merhaba/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.layraweb.com.tr/merhaba/sql-tarafi/calismalar-ve-notlar/veritabani-arasi-sorgulama.md).

# Veritabanı Arası Sorgulama

```sql
SELECT  obj.Name as SPName,
                              --modu.definition as SPDefinition,
        obj.create_date as CreationDate,
        obj.modify_date as LastUpdateDate,
                              obj.type 
FROM    sys.sql_modules modu
        INNER JOIN sys.objects obj ON modu.object_id = obj.object_id
        AND modu.definition LIKE '%Örnek Yazı.%'
Order By obj.Name

Like yerine kullanılabilecek hızlı full text sorgusu : 
CONTAINS(KOLONADI,'"ARANAN İÇERİK"')

```