{"id":353,"date":"2007-12-07T10:32:10","date_gmt":"2007-12-07T09:32:10","guid":{"rendered":"http:\/\/soci.hu\/blog\/index.php\/2007\/12\/07\/sql-server-2008-ujdonsagok-1-tabla-tipusu-parameterek\/"},"modified":"2007-12-07T10:32:10","modified_gmt":"2007-12-07T09:32:10","slug":"sql-server-2008-ujdonsagok-1-tabla-tipusu-parameterek","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2007\/12\/07\/sql-server-2008-ujdonsagok-1-tabla-tipusu-parameterek\/","title":{"rendered":"SQL Server 2008 \u00fajdons\u00e1gok 1. &#8211; T\u00e1bla t\u00edpus\u00fa param\u00e9terek"},"content":{"rendered":"<p>A k\u00f6vetkez\u0151 n\u00e9h\u00e1ny h\u00f3napban minden nap r\u00e1sz\u00e1nok kev\u00e9s id\u0151t, hogy az SQL Server 2008-ba belem\u00e9lyedjek, k\u00f6zben igyekszem dokument\u00e1lni a blogomban az \u00fajdons\u00e1gokat. A cikkekben semmilyen tematika vagy sorrend nem lesz, egyszer\u0171en csak magozok az el\u00e9m ker\u00fcl\u0151 \u00fajdons\u00e1gokb\u00f3l.<\/p>\n<p>Az els\u0151 \u00faj f\u00edcs\u00f6r a t\u00e1bla t\u00edpus\u00fa param\u00e9ter\u00e1tad\u00e1s. Ez finom dolog lesz, nem kell stringekbe serializ\u00e1lni a param\u00e9tereket, nem kell xmlt haszn\u00e1lni, hanem egyszer\u0171en \u00e1t lehet passzintani egy t\u00e1bla t\u00edpus\u00fa v\u00e1ltoz\u00f3t a h\u00edvott elj\u00e1r\u00e1snak.<\/p>\n<p>Ehhez a CREATE TYPE ker\u00fclt felokos\u00edt\u00e1sra, ami m\u00e1r nem csak aliasokat tud (SQL Server 7), vagy CLR t\u00edpusokat (SQL Server 2000), hanem t\u00e1bla t\u00edpusokat is (SQL Server 2008). Pl.<\/p>\n<p>CREATE TYPE LocationTableType AS TABLE<br \/>\n(<br \/>\n  LocationName VARCHAR(50),<br \/>\n  CostRate INT<br \/>\n)<\/p>\n<p>Azt\u00e1n param\u00e9terk\u00e9nt \u00edgy lehet haszn\u00e1lni mondjuk spben:<\/p>\n<p>CREATE PROC Ize<br \/>\n(<br \/>\n    @par LocationTableType<br \/>\n)<\/p>\n<p>Komplett p\u00e9lda <a href=\"http:\/\/sqljunkies.com\/WebLog\/peter_debetta\/archive\/2007\/12\/06\/98170.aspx\">itt l\u00e1that\u00f3<\/a>.<\/p>\n<p>Bel\u00fcl mint egy sima t\u00e1bl\u00e1t lehet joinolni, stb.<\/p>\n<p>Mi\u00e9rt is j\u00f3 a BOL szerint:<\/p>\n<p>Do not acquire locks for the initial population of data from a client.<br \/>\nDo not cause a statement to recompile.<br \/>\nProvide a simple programming model.<br \/>\nEnable you to include complex business logic in a single routine.<br \/>\nReduce round trips to the server.<br \/>\nCan have a table structure of different cardinality.<br \/>\nAre strongly typed.<br \/>\nEnable the client to specify sort order and unique keys.<\/p>\n<p>Az els\u0151 pont mindj\u00e1rt k\u00edv\u00e1ncsiv\u00e1 tett, hogy lehet ADO.NET-b\u0151l felt\u00f6lteni a t\u00e1bla param\u00e9tert. Zseni\u00e1lisan egyszer\u0171en, sima <a href=\"http:\/\/mtaulty.com\/CommunityServer\/blogs\/mike_taultys_blog\/archive\/2007\/10\/24\/9888.aspx\">DataTable-t kell felt\u00f6lteni<\/a>, \u00e9s m\u00e1r mehet is be a szervernek. \u00c1llat.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A k\u00f6vetkez\u0151 n\u00e9h\u00e1ny h\u00f3napban minden nap r\u00e1sz\u00e1nok kev\u00e9s id\u0151t, hogy az SQL Server 2008-ba belem\u00e9lyedjek, k\u00f6zben igyekszem dokument\u00e1lni a blogomban az \u00fajdons\u00e1gokat&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,6,4,30,58],"tags":[],"class_list":["post-353","post","type-post","status-publish","format-standard","hentry","category-adonet","category-adatbazisok","category-szakmai-elet","category-sql-server","category-sql-server-2008"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=353"}],"version-history":[{"count":0,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/353\/revisions"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}