Insert Multiple Rows in a single statement in Sql Server 2008
In SQL Server 2008, This new feature enables the developer to insert multiple rows in a single SQL Statement.
insert into insertbulk (name,age) values ('arun',19),('prakash',23),('rajesh',22)
Dotnet, DotnetCore, Azure, C#,VB.net, Sql Server, WCF, MVC ,Linq, Javascript and React.js
Showing posts with label Insert Multiple Rows in a single statement in Sql Server 2008. Show all posts
Showing posts with label Insert Multiple Rows in a single statement in Sql Server 2008. Show all posts
Subscribe to:
Posts (Atom)
Find number of letter occurence of all letter in c#
Find number of letter occurence of all letter in c# namespace ConsoleApp1 { internal class Program { static void Main(st...
-
ViewBag, ViewData, TempData and View State in MVC ASP.NET MVC offers us three options ViewData, ViewBag and TempData for passing data from...
-
View in Sql Server 2008 Creates a virtual table whose contents (columns and rows) are defined by a query. Use this statement to create a vie...
-
// Export Datatable to Excel in C# Windows application using System; using System.Data; using System.IO; using System.Windows.Forms; ...