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)
Implementing OAuth validation in a Web API
I mplementing OAuth validation in a Web API Implementing OAuth validation in a Web API using C# typically involves several key steps to sec...
-
ViewBag, ViewData, TempData and View State in MVC ASP.NET MVC offers us three options ViewData, ViewBag and TempData for passing data from...
-
// 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