{"id":2005,"date":"2019-08-09T10:31:22","date_gmt":"2019-08-09T10:31:22","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=2005"},"modified":"2020-05-02T08:31:29","modified_gmt":"2020-05-02T08:31:29","slug":"microsoft-modify-data","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/","title":{"rendered":"Modify Data"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\"><strong>Transact-SQL statements<\/strong><\/h3>\n\n\n\n<p>It summarizes the categories of statements for use with Transact-SQL (T-SQL). You can find all of the statements listed in the left-hand navigation.<\/p>\n\n\n\n<p><strong>Backup and restore<\/strong><br> The backup and restore statements provide ways to create backups and restore from backups. For more information, see the Backup and restore overview.<\/p>\n\n\n\n<p><strong>Data Definition Language<\/strong><br> Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>ALTER<\/li><li>Collations<\/li><li>CREATE<\/li><li>DROP<\/li><li>DISABLE TRIGGER<\/li><li>ENABLE TRIGGER<\/li><li>RENAME<\/li><li>UPDATE STATISTICS<\/li><\/ul>\n\n\n\n<p><strong>Data Manipulation Language<\/strong><br>Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>BULK INSERT<\/li><li> DELETE<\/li><li> INSERT<\/li><li> UPDATE<\/li><li> MERGE<\/li><li> TRUNCATE TABLE<\/li><\/ul>\n\n\n\n<p><strong>Permissions statements<\/strong><br>Permissions statements determine which users and logins can access data and perform operations. For more information about authentication and access, see the Security center.<\/p>\n\n\n\n<p><strong>Service Broker statements<\/strong><br> Service Broker is a feature that provides native support for messaging and queuing applications. For more information, see Service Broker.<\/p>\n\n\n\n<p><strong>Session settings<\/strong><br>SET statements determine how the current session handles run time settings. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>OUTPUT Clause (Transact-SQL)<\/strong><\/h3>\n\n\n\n<p>Returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or MERGE statement. These results can be returned to the processing application for use in such things as confirmation messages, archiving, and other such application requirements. The results can also be inserted into a table or table variable. Additionally, you can capture the results of an OUTPUT clause in a nested INSERT, UPDATE, DELETE, or MERGE statement, and insert those results into a target table or view.<\/p>\n\n\n\n<p>Note<\/p>\n\n\n\n<p>An UPDATE, INSERT, or DELETE statement that has an OUTPUT clause will return rows to the client even if the statement encounters errors and is rolled back. The result should not be used if any error occurs when you run the statement.<\/p>\n\n\n\n<p>Used in:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>DELETE<\/li><li>INSERT<\/li><li>UPDATE<\/li><li>MERGE<\/li><\/ul>\n\n\n\n<p><strong>Syntax<\/strong><\/p>\n\n\n\n<p>&lt;OUTPUT_Clause&gt; : :=  <br> {  <br>     [ OUTPUT  INTO { @table_variable | output_table } [ ( column_list ) ] ]  <br>     [ OUTPUT  ]  <br> }  <br>  ::=  <br> {  | scalar_expression } [ [AS] column_alias_identifier ]  <br>     [ ,\u2026n ]  <\/p>\n\n\n\n<p> ::=  <br>\n{ DELETED | INSERTED | from_table_name } . { * | column_name }  <br>\n    | $action  <\/p>\n\n\n\n<p><strong>Arguments<\/strong><\/p>\n\n\n\n<p>@table_variable<br> Specifies a table variable that the returned rows are inserted into instead of being returned to the caller. @table_variable must be declared before the INSERT, UPDATE, DELETE, or MERGE statement.<\/p>\n\n\n\n<p>If column_list is not specified, the table variable must have the same number of columns as the OUTPUT result set. The exceptions are identity and computed columns, which must be skipped. If column_list is specified, any omitted columns must either allow null values or have default values assigned to them.<\/p>\n\n\n\n<p>For more information about table variables, see table (Transact-SQL).<\/p>\n\n\n\n<p><em>output_table<\/em><br> Specifies a table that the returned rows are inserted into instead of being returned to the caller. output_table may be a temporary table.<\/p>\n\n\n\n<p>If column_list is not specified, the table must have the same number of columns as the OUTPUT result set. The exceptions are identity and computed columns. These must be skipped. If column_list is specified, any omitted columns must either allow null values or have default values assigned to them.<\/p>\n\n\n\n<p>output_table cannot:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Have enabled triggers defined on it.<\/li><li>Participate on either side of a FOREIGN KEY constraint.<\/li><li>Have CHECK constraints or enabled rules.<\/li><\/ul>\n\n\n\n<p><em>column_list<\/em><br>Is an optional list of column names on the target table of the INTO clause. It is analogous to the column list allowed in the&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/insert-transact-sql?view=sql-server-2017\">INSERT<\/a>statement.<\/p>\n\n\n\n<p><em>scalar_expression<\/em><br>Is any combination of symbols and operators that evaluates to a single value. Aggregate functions are not permitted in&nbsp;<em>scalar_expression<\/em>.<\/p>\n\n\n\n<p>Any reference to columns in the table being modified must be qualified with the INSERTED or DELETED prefix.<\/p>\n\n\n\n<p><em>column_alias_identifier<\/em><br>Is an alternative name used to reference the column name.<\/p>\n\n\n\n<p><strong>DELETED<\/strong><br>Is a column prefix that specifies the value deleted by the update or delete operation. Columns prefixed with DELETED reflect the value before the UPDATE, DELETE, or MERGE statement is completed.<\/p>\n\n\n\n<p>DELETED cannot be used with the OUTPUT clause in the INSERT statement.<\/p>\n\n\n\n<p><strong>INSERTED<\/strong><br>Is a column prefix that specifies the value added by the insert or update operation. Columns prefixed with INSERTED reflect the value after the UPDATE, INSERT, or MERGE statement is completed but before triggers are executed.<\/p>\n\n\n\n<p>INSERTED cannot be used with the OUTPUT clause in the DELETE statement.<\/p>\n\n\n\n<p><em>from_table_name<\/em><br>Is a column prefix that specifies a table included in the FROM clause of a DELETE, UPDATE, or MERGE statement that is used to specify the rows to update or delete.<\/p>\n\n\n\n<p>If the table being modified is also specified in the FROM clause, any reference to columns in that table must be qualified with the INSERTED or DELETED prefix.<\/p>\n\n\n\n<p>*<br>Specifies that all columns affected by the delete, insert, or update action will be returned in the order in which they exist in the table.<\/p>\n\n\n\n<p>For example,&nbsp;<code>OUTPUT DELETED.*<\/code>&nbsp;in the following DELETE statement returns all columns deleted from the&nbsp;<code>ShoppingCartItem<\/code>&nbsp;table:Copy<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE Sales.ShoppingCartItem  \n    OUTPUT DELETED.*;  \n<\/code><\/pre>\n\n\n\n<p><em>column_name<\/em><br>Is an explicit column reference. Any reference to the table being modified must be correctly qualified by either the INSERTED or the DELETED prefix as appropriate, for example: INSERTED**.**<em>column_name<\/em>.<\/p>\n\n\n\n<p>$action<br>Is available only for the MERGE statement. Specifies a column of type&nbsp;<strong>nvarchar(10)<\/strong>&nbsp;in the OUTPUT clause in a MERGE statement that returns one of three values for each row: &#8216;INSERT&#8217;, &#8216;UPDATE&#8217;, or &#8216;DELETE&#8217;, according to the action that was performed on that row.<\/p>\n\n\n\n<p><strong>Remarks<\/strong><\/p>\n\n\n\n<p>The OUTPUT &lt;dml_select_list&gt; clause and the OUTPUT &lt;dml_select_list&gt; INTO {&nbsp;<strong>@<\/strong><em>table_variable<\/em>&nbsp;|&nbsp;<em>output_table<\/em>&nbsp;} clause can be defined in a single INSERT, UPDATE, DELETE, or MERGE statement.<\/p>\n\n\n\n<p><strong>&nbsp;Note: <\/strong>Unless specified otherwise, references to the OUTPUT clause refer to both the OUTPUT clause and the OUTPUT INTO clause.<\/p>\n\n\n\n<p>The OUTPUT clause may be useful to retrieve the value of identity or computed columns after an INSERT or UPDATE operation.<\/p>\n\n\n\n<p>When a computed column is included in the &lt;dml_select_list&gt;, the corresponding column in the output table or table variable is not a computed column. The values in the new column are the values that were computed at the time the statement was executed.<\/p>\n\n\n\n<p>There is no guarantee that the order in which the changes are applied to the table and the order in which the rows are inserted into the output table or table variable will correspond.<\/p>\n\n\n\n<p>If parameters or variables are modified as part of an UPDATE statement, the OUTPUT clause always returns the value of the parameter or variable as it was before the statement executed instead of the modified value.<\/p>\n\n\n\n<p>You can use OUTPUT with an UPDATE or DELETE statement positioned on a cursor that uses WHERE CURRENT OF syntax.<\/p>\n\n\n\n<p>The OUTPUT clause is not supported in the following statements:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>DML statements that reference local partitioned views, distributed partitioned views, or remote tables.<\/li><li>INSERT statements that contain an EXECUTE statement.<\/li><li>Full-text predicates are not allowed in the OUTPUT clause when the database compatibility level is set to 100.<\/li><li>The OUTPUT INTO clause cannot be used to insert into a view, or rowset function.<\/li><li>A user-defined function cannot be created if it contains an OUTPUT INTO clause that has a table as its target.<\/li><\/ul>\n\n\n\n<p>To prevent nondeterministic behavior, the OUTPUT clause cannot contain the following references:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Subqueries or user-defined functions that perform user or system data access, or are assumed to perform such access. User-defined functions are assumed to perform data access if they are not schema-bound.<\/li><li>A column from a view or inline table-valued function when that column is defined by one of the following methods:<ul><li>A subquery.<\/li><li>A user-defined function that performs user or system data access, or is assumed to perform such access.<\/li><li>A computed column that contains a user-defined function that performs user or system data access in its definition.<\/li><\/ul>When SQL Server detects such a column in the OUTPUT clause, error 4186 is raised.<\/li><\/ul>\n\n\n\n<p><strong>Inserting Data Returned From an OUTPUT Clause Into a Table<\/strong><\/p>\n\n\n\n<p>When you are capturing the results of an OUTPUT clause in a nested INSERT, UPDATE, DELETE, or MERGE statement and inserting those results into a target table, keep the following information in mind:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>The whole operation is atomic. Either both the INSERT statement and the nested DML statement that contains the OUTPUT clause execute, or the whole statement fails.<\/li><li>The following restrictions apply to the target of the outer INSERT statement:<ul><li>The target cannot be a remote table, view, or common table expression.<\/li><li>The target cannot have a FOREIGN KEY constraint, or be referenced by a FOREIGN KEY constraint.<\/li><li>Triggers cannot be defined on the target.<\/li><li>The target cannot participate in merge replication or updatable subscriptions for transactional replication.<\/li><\/ul><\/li><li>The following restrictions apply to the nested DML statement:<ul><li>The target cannot be a remote table or partitioned view.<\/li><li>The source itself cannot contain a &lt;dml_table_source&gt; clause.<\/li><\/ul><\/li><li>The OUTPUT INTO clause is not supported in INSERT statements that contain a &lt;dml_table_source&gt; clause.<\/li><li>@@ROWCOUNT returns the rows inserted only by the outer INSERT statement.<\/li><li>@@IDENTITY, SCOPE_IDENTITY, and IDENT_CURRENT return identity values generated only by the nested DML statement, and not those generated by the outer INSERT statement.<\/li><li>Query notifications treat the statement as a single entity, and the type of any message that is created will be the type of the nested DML, even if the significant change is from the outer INSERT statement itself.<\/li><li>In the &lt;dml_table_source&gt; clause, the SELECT and WHERE clauses cannot include subqueries, aggregate functions, ranking functions, full-text predicates, user-defined functions that perform data access, or the TEXTPTR function.<\/li><\/ul>\n\n\n\n<p><strong>Parallelism<\/strong><\/p>\n\n\n\n<p>An OUTPUT clause that returns results to the client will always use a serial plan.<\/p>\n\n\n\n<p>In the context of a database set to compatibility level 130 or higher, if an INSERT&#8230;SELECT operation uses a WITH (TABLOCK) hint for the SELECT statement and also uses OUTPUT&#8230;INTO to insert into a temporary or user table, then the target table for the INSERT&#8230;SELECT will be eligible for parallelism depending on the subtree cost. The target table referenced in the OUTPUT INTO clause will not be eligible for parallelism.<\/p>\n\n\n\n<p><strong>Triggers<\/strong><\/p>\n\n\n\n<p>Columns returned from OUTPUT reflect the data as it is after the INSERT, UPDATE, or DELETE statement has completed but before triggers are executed.<\/p>\n\n\n\n<p>For INSTEAD OF triggers, the returned results are generated as if the INSERT, UPDATE, or DELETE had actually occurred, even if no modifications take place as the result of the trigger operation. If a statement that includes an OUTPUT clause is used inside the body of a trigger, table aliases must be used to reference the trigger inserted and deleted tables to avoid duplicating column references with the INSERTED and DELETED tables associated with OUTPUT.<\/p>\n\n\n\n<p>If the OUTPUT clause is specified without also specifying the INTO keyword, the target of the DML operation cannot have any enabled trigger defined on it for the given DML action. For example, if the OUTPUT clause is defined in an UPDATE statement, the target table cannot have any enabled UPDATE triggers.<\/p>\n\n\n\n<p>If the sp_configure option disallow results from triggers is set, an OUTPUT clause without an INTO clause causes the statement to fail when it is invoked from within a trigger.<\/p>\n\n\n\n<p><strong>Data Types<\/strong><\/p>\n\n\n\n<p>The OUTPUT clause supports the large object data types:&nbsp;<strong>nvarchar(max)<\/strong>,&nbsp;<strong>varchar(max)<\/strong>,&nbsp;<strong>varbinary(max)<\/strong>,&nbsp;<strong>text<\/strong>,&nbsp;<strong>ntext<\/strong>,&nbsp;<strong>image<\/strong>, and&nbsp;<strong>xml<\/strong>. When you use the .WRITE clause in the UPDATE statement to modify an&nbsp;<strong>nvarchar(max)<\/strong>,&nbsp;<strong>varchar(max)<\/strong>, or&nbsp;<strong>varbinary(max)<\/strong>column, the full before and after images of the values are returned if they are referenced. The TEXTPTR( ) function cannot appear as part of an expression on a&nbsp;<strong>text<\/strong>,&nbsp;<strong>ntext<\/strong>, or&nbsp;<strong>image<\/strong>&nbsp;column in the OUTPUT clause.<\/p>\n\n\n\n<p><strong>Queues<\/strong><\/p>\n\n\n\n<p>You can use OUTPUT in applications that use tables as queues, or to hold intermediate result sets. That is, the application is constantly adding or removing rows from the table. The following example uses the OUTPUT clause in a DELETE statement to return the deleted row to the calling application.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Transact-SQL statements It summarizes the categories of statements for use with Transact-SQL (T-SQL). You can find all of the statements listed in the left-hand navigation. Backup and restore The backup and restore statements provide ways to create backups and restore from backups. For more information, see the Backup and restore overview. Data Definition Language Data&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1931,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[360,358,357],"class_list":["post-2005","page","type-page","status-publish","hentry","tag-exam-70-761","tag-microsoft-70-761","tag-microsoft-exam"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft Exam (70-761) Modify Data - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Get ready to boost your learning by preparing for practice test on Modify Data, Become Certified Microsoft 70-761 Exam Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Exam (70-761) Modify Data - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Get ready to boost your learning by preparing for practice test on Modify Data, Become Certified Microsoft 70-761 Exam Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-02T08:31:29+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/\",\"name\":\"Microsoft Exam (70-761) Modify Data - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2019-08-09T10:31:22+00:00\",\"dateModified\":\"2020-05-02T08:31:29+00:00\",\"description\":\"Get ready to boost your learning by preparing for practice test on Modify Data, Become Certified Microsoft 70-761 Exam Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 70-761: Querying Data with Transact-SQL\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Modify Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Exam (70-761) Modify Data - Testprep Training Tutorials","description":"Get ready to boost your learning by preparing for practice test on Modify Data, Become Certified Microsoft 70-761 Exam Now!","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:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Exam (70-761) Modify Data - Testprep Training Tutorials","og_description":"Get ready to boost your learning by preparing for practice test on Modify Data, Become Certified Microsoft 70-761 Exam Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-05-02T08:31:29+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/","name":"Microsoft Exam (70-761) Modify Data - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2019-08-09T10:31:22+00:00","dateModified":"2020-05-02T08:31:29+00:00","description":"Get ready to boost your learning by preparing for practice test on Modify Data, Become Certified Microsoft 70-761 Exam Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/microsoft-modify-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 70-761: Querying Data with Transact-SQL","item":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-761-querying-data-with-transact-sql\/"},{"@type":"ListItem","position":3,"name":"Modify Data"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/2005","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=2005"}],"version-history":[{"count":3,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/2005\/revisions"}],"predecessor-version":[{"id":5339,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/2005\/revisions\/5339"}],"up":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/1931"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=2005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=2005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=2005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}