Why Select is DML statement in SQL?
DML - Data Manipulation Language
The purely read-only SELECT query statement is classed with the 'SQL-data' statements
The SELECT ... INTO form is considered to be DML because it manipulates (i.e. modifies) data.
SELECT Column1, Column2
INTO DestinationTable
FROM SourceTable
Copy Coumn1,Column2 From SourceTable to DestinationTable.
So Select is dml statement
Other DML Statement are
Insert, Update and Delete
Dotnet, DotnetCore, Azure, C#,VB.net, Sql Server, WCF, MVC ,Linq, Javascript and Jquery
Subscribe to:
Post Comments (Atom)
Consistency level in Azure cosmos db
Consistency level in Azure cosmos db Azure Cosmos DB offers five well-defined consistency levels to provide developers with the flexibility...
-
ViewBag, ViewData, TempData and View State in MVC ASP.NET MVC offers us three options ViewData, ViewBag and TempData for passing data from...
-
· Azure Service Fabric is Microsoft’s Platform-as-a-Service (PaaS) and is used to build and deploy microservices-based cloud applicat...
-
// Export Datatable to Excel in C# Windows application using System; using System.Data; using System.IO; using System.Windows.Forms; ...
cant clearify this
ReplyDeletenoice
ReplyDelete