Multiple Value Insert In A Single Query


Hello readers, Below is the query to inset multiple values in a Table name items in a single INSERT statement.

First Create a table

CREATE TABLE items(id INT, itemname VARCHAR(30))
GO

Inserting values to items table

INSERT INTO items(id,itemname) VALUES (1, 'Pen'),(2,'Pencil'),(3,'Rubber'),(1,'Scale'),(1,'Copy'),
(3,'Box'),(2,'Compas'),(4,'Stapler'),(5,'Paper'),(6,'Ink')

GO

SELECT * FROM items


Query is simple. Not too complicated.

Just add new values after first by placing comma , and type next values.


Comments

  1. swati5 December 2011 at 01:11

    Good One.!!!!

    ReplyDelete
  2. Anonymous18 January 2012 at 04:21

    can u plz post the code for Image uploader.. which store Image Path in DB and shows directly on the form(In Image Control)
    Thanx

    ReplyDelete
  3. Anish Rana18 January 2012 at 17:25

    Topic added to blog with name File Upload under Asp.Net Tips.

    ReplyDelete

Post a Comment

Popular posts from this blog

Get Query String Values With Javascript

Image
JavaScript Code To  Retrieve Query String Values This topic shows you how you can retrieve the query string values from a URL using JavaScript. The code is simple and understandable. Below is the complete code. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Query String using Javascript</title> <script type="text/javascript" language="javascript">     function getquerystring()     {         var qsarr = new Array();                  var qs = location.search.substring(1);         var singleqs = new Array();         var str ="";         qsarr = qs.split('&');         for( i=0; i<qsarr.length; i++)         {             singleqs = qsarr[i].split('=');             str += 'Query String Name
Read more

Change Css Class of li in ul onclick

Image
Below is the simple and a short code to change or set the background color of item in menu onclick or active tab of menu (i.e. li of ul) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>List Item</title> <style type="text/css"> ul {     list-style-type:none;     float:left;     border-bottom: solid 2px Red;     padding-right:40px; } ul li {     float:left;     width:auto;     padding:8px;     display:block;     cursor:pointer; } </style> <script type="text/javascript" language="javascript">     function checklist(ctrl)     {                 var list = document.getElementById("menu").getElementsByTagName('li&#
Read more

Change Text Color with Javascript

Below is the simple and sweet code of changing text color after fraction of second automatically. Copy n Paste and run... <html> <head> <title>Text Color Change</title> <script type="text/javascript" language="javascript"> elmColor = 0;     function changeColor(elmColor)     {                    switch(elmColor)         {             case 0:             document.getElementById('colorChange').style.color = '#000000';             elmColor++;              break;                          case 1:             document.getElementById('colorChange').style.color = '#ff0000';              elmColor++;             break;                          case 2:             document.getElementById('colorChange').style.color = '#00ff00';              elmColor++;             break;                          case 3:             document.getElementById('colorChange').style
Read more