\u0130leride kullan\u0131lmak \u00fczere elinizin alt\u0131nda bulunmas\u0131nda fayda oldu\u011funu d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcm bir tablo de\u011ferli fonksiyon \u00f6rne\u011fini payla\u015fmak istiyorum; Bu fonksiyon temelde ad\u0131n\u0131 verdi\u011finiz tablonun s\u00fctun yap\u0131s\u0131n\u0131 veri tablosu olarak vermeye yar\u0131yor;
\n
\nBunu bir view olarak yapmak da m\u00fcmk\u00fcnd\u00fc fakat parametrik olmas\u0131 ve s\u0131ralama yap\u0131labilmesi gibi avantajlar\u0131 nedeniyle (Multi-Statement Table-Value) \u015feklinde kodlamak cazip geldi diyelim…<\/p>\n
SET ANSI_NULLS ON\nGO\nSET QUOTED_IDENTIFIER ON\nGO\n-- =============================================\n-- Author : <U\u011fur PARLAYAN>\n-- Create date : <2017-06-30-2158>\n-- Description : <Tablolar\u0131n s\u00fctun listesini ve bir ka\u00e7 yararl\u0131 bilgiyi i\u00e7erir>\n-- =============================================\nALTER FUNCTION dbo.fnt_sys_Kolonlar( @TabloAdi VARCHAR(50) )\nRETURNS @SONUC TABLE\n( ID INT\n, Kolon VARCHAR(50)\n, VeriTipi VARCHAR(50)\n, CharSet VARCHAR(50)\n, Bayt INT\n, Bos BIT\n, Primal BIT\n) AS BEGIN\n INSERT INTO @SONUC (ID, Kolon, Primal, VeriTipi, Bos, Bayt, CharSet)\n SELECT \n C.ORDINAL_POSITION as ID\n , C.COLUMN_NAME as Kolon\n , iif(T.CONSTRAINT_TYPE='PRIMARY KEY',1,0) as Primal\n , C.DATA_TYPE as VeriTipi\n , iif(C.IS_NULLABLE='YES', 1, 0) as Bos\n , COALESCE(C.CHARACTER_MAXIMUM_LENGTH, C.NUMERIC_PRECISION) as Bayt\n , C.CHARACTER_SET_NAME as CharSet\n FROM INFORMATION_SCHEMA.COLUMNS as C LEFT OUTER\n JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE as U ON U.TABLE_NAME = C.TABLE_NAME AND U.COLUMN_NAME = C.COLUMN_NAME LEFT OUTER\n JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS as T ON T.TABLE_NAME = C.TABLE_NAME AND T.CONSTRAINT_NAME = U.CONSTRAINT_NAME\n WHERE C.TABLE_NAME = @TabloAdi\n ORDER BY C.ORDINAL_POSITION\n ;\n RETURN\nEND\nGO<\/code><\/pre>\nKullan\u0131m\u0131 ise olduk\u00e7a basit;<\/p>\n
SELECT * FROM dbo.fnt_sys_Kolonlar('Cariler');<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u0130leride kullan\u0131lmak \u00fczere elinizin alt\u0131nda bulunmas\u0131nda fayda oldu\u011funu d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcm bir tablo de\u011ferli fonksiyon \u00f6rne\u011fini payla\u015fmak istiyorum; Bu fonksiyon temelde ad\u0131n\u0131 verdi\u011finiz tablonun s\u00fctun yap\u0131s\u0131n\u0131 veri tablosu olarak vermeye yar\u0131yor<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[7],"class_list":["post-144","post","type-post","status-publish","format-standard","hentry","category-blog","tag-sql-server"],"_links":{"self":[{"href":"http:\/\/www.potansif.com\/index.php?rest_route=\/wp\/v2\/posts\/144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.potansif.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.potansif.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.potansif.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.potansif.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=144"}],"version-history":[{"count":2,"href":"http:\/\/www.potansif.com\/index.php?rest_route=\/wp\/v2\/posts\/144\/revisions"}],"predecessor-version":[{"id":146,"href":"http:\/\/www.potansif.com\/index.php?rest_route=\/wp\/v2\/posts\/144\/revisions\/146"}],"wp:attachment":[{"href":"http:\/\/www.potansif.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.potansif.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=144"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.potansif.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}