{"id":27588,"date":"2023-08-03T06:38:00","date_gmt":"2023-08-03T04:38:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=27588"},"modified":"2023-10-20T17:24:16","modified_gmt":"2023-10-20T15:24:16","slug":"insertar-con-procedimiento-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/","title":{"rendered":"\u00bfC\u00f3mo insertar datos con un procedimiento almacenado de SQL Server?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\" id=\"h-como-utilizar-variables-t-sql-para-insertar-datos-utilizando-un-procedimiento-almacenado-de-sql-server\"><strong><em>\u00bfC\u00f3mo utilizar variables T-SQL para insertar datos utilizando un procedimiento almacenado de SQL Server?<\/em><\/strong><\/h4>\n\n\n\n<p>Tutorial sobre c\u00f3mo insertar datos con un procedimiento almacenado de SQL Server utilizando variables T-SQL. Y tambi\u00e9n c\u00f3mo mostrar u ocultar el n\u00famero de filas insertadas por el procedimiento. Este ejemplo de un procedimiento T-SQL inserta filas en una tabla de clientes. Este es un tutorial de 3 pasos para aprender c\u00f3mo insertar filas desde un procedimiento almacenado con variables.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#1-crear-la-tabla-de-ventas-para-usarla-en-el-procedimiento\" >1. Crear la tabla de ventas para usarla en el procedimiento<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#2-crear-el-procedimiento-almacenado-de-sql-server-para-insertar-datos\" >2. Crear el procedimiento almacenado de SQL Server para insertar datos<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#3-opcion-para-ocultar-el-numero-de-filas-insertadas\" >3. Opci\u00f3n para ocultar el n\u00famero de filas insertadas<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-crear-la-tabla-de-ventas-para-usarla-en-el-procedimiento\"><\/span>1. Crear la tabla de ventas para usarla en el procedimiento<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Primero, verifique que la tabla de clientes de ejemplo no exista. Si la tabla existe, entonces b\u00f3rrela con el comando DROP TABLE. Luego cree la tabla de clientes para insertar las filas del ejemplo.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Test if the table CUSTOMERS already exists\n-- And delete it if necessary\nIF EXISTS(\n   SELECT 1 FROM sys.objects\n   WHERE  object_id = object_id(N'[dbo].[CUSTOMERS]')\n      AND type in (N'U')\n)\nDROP TABLE [dbo].[CUSTOMERS]\nGO\n-- Create the CUSTOMERS table with the column NAME declared as UNIQUE\n-- The UNIQUE keyword defines the column with a unique value\n-- Inserting two customers with the same name is therefore impossible\nCREATE TABLE [dbo].[CUSTOMERS] (\n   [CLIENTID] int IDENTITY(1,1),\n   [NAME] nvarchar(20) UNIQUE,\n   [CITY] nvarchar(20)\n)\nGO\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-crear-el-procedimiento-almacenado-de-sql-server-para-insertar-datos\"><\/span>2. Crear el procedimiento almacenado de SQL Server para insertar datos<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Primero verifique si el <a href=\"https:\/\/www.pcmag.com\/encyclopedia\/term\/stored-procedure\" target=\"_blank\" rel=\"noreferrer noopener\">procedimiento almacenado<\/a> ya existe en la base de datos y b\u00f3rrelo si es necesario. En segundo lugar, cree el procedimiento almacenado uspInsertClient para insertar dos campos pasados como par\u00e1metros, el nombre y la ciudad, en la tabla de clientes.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">IF EXISTS( \n  SELECT 1 FROM sys.objects \n  WHERE object_id = object_id(N'uspInsertCustomer')\n  AND type in (N'P') )\nDROP PROCEDURE uspInsertCustomer;\nGO\nCREATE PROCEDURE dbo.uspInsertCustomer\n  @Name nvarchar(20),\n  @City nvarchar(20)\nAS\nBEGIN\n  INSERT INTO dbo.Customers (Name, City) \n  VALUES (@Name, @City);\nEND;\nGO\n<\/pre>\n\n\n\n<p>Ejecute el procedimiento tres veces para insertar nuevos clientes en la tabla.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Deactivate the option to hide the number of insertions\nSET NOCOUNT OFF;\n-- Insert three new customers\nEXECUTE dbo.uspInsertCustomer @Name = 'MAMMADOU', @City = 'Toulouse';\nEXECUTE dbo.uspInsertCustomer @Name = 'KARIM', @City = 'Nantes';\nEXECUTE dbo.uspInsertCustomer @Name = 'ISAAC', @City = 'Versailles';\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"440\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sql-server-insert-data-from-sql-server-stored-procedure.jpg\" alt=\"Insert data from a SQL Server stored procedure with SSMS\" class=\"wp-image-18579\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sql-server-insert-data-from-sql-server-stored-procedure.jpg 720w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sql-server-insert-data-from-sql-server-stored-procedure-300x183.jpg 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\"><em>Insertar datos desde un procedimiento almacenado de SQL Server con SSMS<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Este ejemplo de una consulta de inserci\u00f3n en el procedimiento almacenado de SQL Server se utiliza para insertar filas en una tabla. El c\u00f3digo verifica la existencia del procedimiento de antemano para evitar errores en la creaci\u00f3n. El c\u00f3digo facilita la llamada al procedimiento creado con los par\u00e1metros. Y as\u00ed estandarizar la inserci\u00f3n de datos en esta tabla.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-opcion-para-ocultar-el-numero-de-filas-insertadas\"><\/span>3. Opci\u00f3n para ocultar el n\u00famero de filas insertadas<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Cuando inserta datos desde un procedimiento de SQL Server, por defecto, el sistema muestra el n\u00famero de filas insertadas. El comando SET NOCOUNT ON le dice a SQL Server que no muestre el n\u00famero de filas afectadas. En nuestro caso, insertado por la consulta SQL INSERT. As\u00ed, si la opci\u00f3n est\u00e1 habilitada, no se muestra el n\u00famero de filas, como en el ejemplo de abajo. Esta opci\u00f3n de visualizaci\u00f3n permite evitar contaminar archivos o tablas de registro durante la ejecuci\u00f3n de procedimientos almacenados complejos.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Deactivate the option to hide the number of insertions\nSET NOCOUNT ON;\n-- Insert three clients with the option enabled\nEXECUTE dbo.uspInsertCustomer @Name = 'ISACH', @City = 'Lille';\nEXECUTE dbo.uspInsertCustomer @Name = 'AHMED', @City = 'Bordeaux';\nEXECUTE dbo.uspInsertCustomer @Name = 'YANIS', @City = 'Marseille';\n<\/pre>\n\n\n\n<p>Finalmente, verifique el resultado de la consulta y lea los datos con una consulta SELECT en la tabla de clientes. Observe que los tres clientes est\u00e1n presentes dos veces cada uno en la tabla. Esto corresponde a las seis ejecuciones del comando SQL. Es decir, tres veces con la opci\u00f3n de visualizaci\u00f3n de conteo de filas encendida y tres veces con la opci\u00f3n de visualizaci\u00f3n apagada.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT *\nFROM dbo.Customers;\n<\/pre>\n\n\n\n<p>Este tutorial de desarrollo T-SQL explica c\u00f3mo insertar datos desde un procedimiento almacenado de SQL Server. Finalmente, aqu\u00ed hay un tutorial sobre <a href=\"https:\/\/expert-only.com\/en\/t-sql\/return-values-sql-server-stored-procedure\/\">c\u00f3mo crear un procedimiento almacenado de SQL que devuelve valores<\/a> con la opci\u00f3n OUTPUT.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Conclusi\u00f3n sobre la inserci\u00f3n de datos utilizando procedimientos almacenados de SQL Server<\/h3>\n\n\n\n<p>Este tutorial T-SQL explica c\u00f3mo crear una tabla de ventas y c\u00f3mo insertar datos con un procedimiento almacenado de SQL Server, utilizando variables. El tutorial tambi\u00e9n ense\u00f1a c\u00f3mo controlar la visualizaci\u00f3n del n\u00famero de filas insertadas utilizando el comando SET NOCOUNT. Siguiendo estos pasos, es posible estandarizar efectivamente la inserci\u00f3n de datos y gestionar la visualizaci\u00f3n de los conteos de filas para procedimientos almacenados m\u00e1s complejos.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriales-de-sql-y-ti wp-block-embed-tutoriales-de-sql-y-ti\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"hUQwM49fMF\"><a href=\"https:\/\/expert-only.com\/en\/t-sql\/return-values-sql-server-stored-procedure\/\">Return values with SQL Server stored procedure<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00abReturn values with SQL Server stored procedure\u00bb \u2014 Tutoriales de SQL y TI\" src=\"https:\/\/expert-only.com\/en\/t-sql\/return-values-sql-server-stored-procedure\/embed\/#?secret=CaZwZHypnn#?secret=hUQwM49fMF\" data-secret=\"hUQwM49fMF\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\u00bfC\u00f3mo utilizar variables T-SQL para insertar datos utilizando un procedimiento almacenado de SQL Server? Tutorial sobre c\u00f3mo insertar datos con un procedimiento almacenado de SQL Server utilizando variables T-SQL. Y tambi\u00e9n c\u00f3mo mostrar u ocultar el n\u00famero de filas <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/\" title=\"\u00bfC\u00f3mo insertar datos con un procedimiento almacenado de SQL Server?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10716,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[455],"tags":[],"class_list":{"0":"post-27588","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Insertar datos con un procedimiento almacenado de SQL Server<\/title>\n<meta name=\"description\" content=\"C\u00f3digo de ejemplo para insertar datos con un procedimiento almacenado de SQL Server utilizando variables T-SQL y una consulta INSERT INTO.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfC\u00f3mo insertar datos con un procedimiento almacenado de SQL Server?\" \/>\n<meta property=\"og:description\" content=\"C\u00f3digo de ejemplo para insertar datos con un procedimiento almacenado de SQL Server utilizando variables T-SQL y una consulta INSERT INTO.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriales de SQL y TI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-03T04:38:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-20T15:24:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"\u00bfC\u00f3mo insertar datos con un procedimiento almacenado de SQL Server?\",\"datePublished\":\"2023-08-03T04:38:00+00:00\",\"dateModified\":\"2023-10-20T15:24:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/\"},\"wordCount\":584,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/\",\"name\":\"Insertar datos con un procedimiento almacenado de SQL Server\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg\",\"datePublished\":\"2023-08-03T04:38:00+00:00\",\"dateModified\":\"2023-10-20T15:24:16+00:00\",\"description\":\"C\u00f3digo de ejemplo para insertar datos con un procedimiento almacenado de SQL Server utilizando variables T-SQL y una consulta INSERT INTO.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"es\",\"item\":\"https:\/\/expert-only.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfC\u00f3mo insertar datos con un procedimiento almacenado de SQL Server?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/es\/#website\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"name\":\"Tutoriales de SQL y TI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/es\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Insertar datos con un procedimiento almacenado de SQL Server","description":"C\u00f3digo de ejemplo para insertar datos con un procedimiento almacenado de SQL Server utilizando variables T-SQL y una consulta INSERT INTO.","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:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfC\u00f3mo insertar datos con un procedimiento almacenado de SQL Server?","og_description":"C\u00f3digo de ejemplo para insertar datos con un procedimiento almacenado de SQL Server utilizando variables T-SQL y una consulta INSERT INTO.","og_url":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/","og_site_name":"Tutoriales de SQL y TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-08-03T04:38:00+00:00","article_modified_time":"2023-10-20T15:24:16+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Escrito por":"Expert-Only","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"\u00bfC\u00f3mo insertar datos con un procedimiento almacenado de SQL Server?","datePublished":"2023-08-03T04:38:00+00:00","dateModified":"2023-10-20T15:24:16+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/"},"wordCount":584,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/","url":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/","name":"Insertar datos con un procedimiento almacenado de SQL Server","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg","datePublished":"2023-08-03T04:38:00+00:00","dateModified":"2023-10-20T15:24:16+00:00","description":"C\u00f3digo de ejemplo para insertar datos con un procedimiento almacenado de SQL Server utilizando variables T-SQL y una consulta INSERT INTO.","breadcrumb":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/es\/t-sql\/insertar-con-procedimiento-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"es","item":"https:\/\/expert-only.com\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfC\u00f3mo insertar datos con un procedimiento almacenado de SQL Server?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/es\/#website","url":"https:\/\/expert-only.com\/es\/","name":"Tutoriales de SQL y TI","description":"","publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/es\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/27588","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/comments?post=27588"}],"version-history":[{"count":2,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/27588\/revisions"}],"predecessor-version":[{"id":27591,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/27588\/revisions\/27591"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media\/10716"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media?parent=27588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/categories?post=27588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/tags?post=27588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}