{"id":12299,"date":"2019-05-16T22:01:21","date_gmt":"2019-05-16T22:01:21","guid":{"rendered":"https:\/\/dbtut.com\/?p=12299"},"modified":"2019-05-16T22:01:22","modified_gmt":"2019-05-16T22:01:22","slug":"user-defined-table-type-and-table-valued-parameter-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/","title":{"rendered":"User Defined Table Type and Table Valued Parameter in SQL Server"},"content":{"rendered":"<p>With User Defined Table Type, we can store the structure of a table. We can use the User Defined Table Typies by defining the table-valued parameter in the Stored Procuder or Functions. We can use these structures instead of specifying the temporay table in the Stored Procedure or Function.<\/p>\n<p>Below you can see the sample usage. You can find explanations in the scripts.<\/p>\n<h3>Create User Defined Table Type<\/h3>\n<pre class=\"lang:default decode:true\">USE AdventureWorks2008R2;\nGO\nCREATE TYPE LocationTableType AS TABLE \n( LocationName VARCHAR(50)\n, CostRate INT );\nGO\n<\/pre>\n<h3>Using User Defined Table Type in a Stored Procedure by using table-valued parameter<\/h3>\n<p>Table valued parameter in this example is @TVP<\/p>\n<pre class=\"lang:default decode:true\">CREATE PROCEDURE usp_InsertProductionLocation\n    @TVP LocationTableType READONLY\n    AS \n    SET NOCOUNT ON\n    INSERT INTO [AdventureWorks2008R2].[Production].[Location]\n           ([Name]\n           ,[CostRate]\n           ,[Availability]\n           ,[ModifiedDate])\n        SELECT *, 0, GETDATE()\n        FROM  @TVP;\n        GO<\/pre>\n<h3>Define a variable of the type of table type that we created<\/h3>\n<pre class=\"lang:default decode:true\">DECLARE @LocationTVP \nAS LocationTableType;\n<\/pre>\n<h3>Insert data to this variable<\/h3>\n<pre class=\"lang:default decode:true \">INSERT INTO @LocationTVP (LocationName, CostRate)\n    SELECT [Name], 0.00\n    FROM \n    [AdventureWorks2008R2].[Person].[StateProvince];<\/pre>\n<h3>Execute the stored procedure by passing this variable as a parameter<\/h3>\n<pre class=\"lang:default decode:true \">EXEC usp_InsertProductionLocation @LocationTVP;\nGO<\/pre>\n\n<p style=\"margin: 0in; font-family: Calibri; font-size: 9.0pt; color: #595959;\">Source &lt;<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bb510489(v=sql.105).aspx\">https:\/\/msdn.microsoft.com\/en-us\/library\/bb510489(v=sql.105).aspx<\/a>&gt;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12299\" class=\"pvc_stats all  \" data-element-id=\"12299\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>With User Defined Table Type, we can store the structure of a table. We can use the User Defined Table Typies by defining the table-valued parameter in the Stored Procuder or Functions. We can use these structures instead of specifying the temporay table in the Stored Procedure or Function. Below you can see the sample &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12299\" class=\"pvc_stats all  \" data-element-id=\"12299\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":12303,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[4386,4384,4390,4382,4380,4389,4392,4377,4388,4387,4385,4381,4383,4391,4379],"class_list":["post-12299","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-can-we-pass-datatable-to-a-stored-procedure","tag-can-we-pass-table-as-a-parameter-to-stored-procedure-in-sql-server","tag-how-to-select-user-defined-table-type-in-sql-server","tag-how-to-use-table-valued-parameter","tag-how-to-use-user-defined-table-type","tag-insert-data-into-user-defined-table-type-in-sql-server","tag-table-valued-parameter","tag-user-defined-table-type","tag-user-defined-table-type-in-sql-server","tag-using-table-valued-parameters-in-sql-server","tag-what-is-table-data-type-in-sql-server","tag-what-is-table-valued-parameter","tag-what-is-table-valued-parameters-in-sql-server","tag-what-is-the-use-of-user-defined-table-type-in-sql-server","tag-what-is-user-defined-table-type"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>User Defined Table Type and Table Valued Parameter in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"User Defined Table Type and Table Valued Parameter in SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"User Defined Table Type and Table Valued Parameter in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"User Defined Table Type and Table Valued Parameter in SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-16T22:01:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-16T22:01:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-53.png\" \/>\n\t<meta property=\"og:image:width\" content=\"586\" \/>\n\t<meta property=\"og:image:height\" content=\"361\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"User Defined Table Type and Table Valued Parameter in SQL Server\",\"datePublished\":\"2019-05-16T22:01:21+00:00\",\"dateModified\":\"2019-05-16T22:01:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/\"},\"wordCount\":144,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-53.png\",\"keywords\":[\"Can we pass DataTable to a stored procedure?\",\"Can we pass table as a parameter to stored procedure in SQL Server?\",\"how to select user defined table type in sql server\",\"How To Use Table Valued Parameter\",\"How To Use User Defined Table Type\",\"insert data into user defined table type in sql server\",\"Table Valued Parameter\",\"User Defined Table Type\",\"user defined table type in sql server\",\"Using Table-Valued Parameters in SQL Server\",\"What is table data type in SQL Server?\",\"What is Table Valued Parameter\",\"What is table valued parameters in SQL Server?\",\"what is the use of user defined table type in sql server\",\"What is User Defined Table Type\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/\",\"name\":\"User Defined Table Type and Table Valued Parameter in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-53.png\",\"datePublished\":\"2019-05-16T22:01:21+00:00\",\"dateModified\":\"2019-05-16T22:01:22+00:00\",\"description\":\"User Defined Table Type and Table Valued Parameter in SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-53.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-53.png\",\"width\":586,\"height\":361},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"User Defined Table Type and Table Valued Parameter in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"User Defined Table Type and Table Valued Parameter in SQL Server - Database Tutorials","description":"User Defined Table Type and Table Valued Parameter in SQL Server","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"User Defined Table Type and Table Valued Parameter in SQL Server - Database Tutorials","og_description":"User Defined Table Type and Table Valued Parameter in SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-05-16T22:01:21+00:00","article_modified_time":"2019-05-16T22:01:22+00:00","og_image":[{"width":586,"height":361,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-53.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"User Defined Table Type and Table Valued Parameter in SQL Server","datePublished":"2019-05-16T22:01:21+00:00","dateModified":"2019-05-16T22:01:22+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/"},"wordCount":144,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-53.png","keywords":["Can we pass DataTable to a stored procedure?","Can we pass table as a parameter to stored procedure in SQL Server?","how to select user defined table type in sql server","How To Use Table Valued Parameter","How To Use User Defined Table Type","insert data into user defined table type in sql server","Table Valued Parameter","User Defined Table Type","user defined table type in sql server","Using Table-Valued Parameters in SQL Server","What is table data type in SQL Server?","What is Table Valued Parameter","What is table valued parameters in SQL Server?","what is the use of user defined table type in sql server","What is User Defined Table Type"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/","name":"User Defined Table Type and Table Valued Parameter in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-53.png","datePublished":"2019-05-16T22:01:21+00:00","dateModified":"2019-05-16T22:01:22+00:00","description":"User Defined Table Type and Table Valued Parameter in SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-53.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-53.png","width":586,"height":361},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/user-defined-table-type-and-table-valued-parameter-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"User Defined Table Type and Table Valued Parameter in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=12299"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12299\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12303"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}