Inserting Multiple values in SQL

Posted by Self-Innovator under Sql Server category on 2/9/2013 | Points: 40 | Views : 1869

Post Code |

Search Codes |

Code Home

Inserting multiple records on a single statement

INSERT INTO TBL_REGISTRATIONS(NAME,EMAIL)
SELECT 'MOHAMMED','mohammed.mhd@gmail.com'
UNION ALL
SELECT 'AHMED','ahmed21@yahoo.com'
UNION ALL
SELECT 'JOHN','john.mathew@facebook.com'

Alert Moderator

Bookmark It

Comments or Responses

Latest Code Snipptes

Uber Clone - Taxi Booking App
writing Custom pagination html code in python and django
Code snippet for setInterval
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
More ...