Insert Query in SQL Server

This post have all the query and synatx which a biggner and experianced SQL  users need to know and use in their daily working Life.

 Top 100+ Sql Server Interview Questions

 

There are for different  kind of requriment to insert into table so all of that are here-

1- Template for all columns update -
insert into Table_name value('ABC','ART','',.....,'Value n')
--   Note data type of each column should be  match

2- Template for slelect columns  update --
insert into Table_name(col_1,col_2,,,,,,,, col_n)  value ('ABC','ART','',.....,'Value n')

3- If all rows have to be fill up
insert Into Parameter_Blood_Group values('B0100A000004', 'GEN00A000001','AB-','AB-','0','2','Approved','','2019-05-04 17:27:58.913')

4- If select rows have to be fill up
insert Into Parameter_Blood_Group(URN_No,Co_code) values('B0100A000004', 'GEN00A000001')

Servlet Code for uploading the Homework in MYSQL Programming Logic and Code with Syntax

Servlet Code for upload the Teacher data in SQL Programming Logic and Code with Syntax

Servlet Request and Response Code Part 1 Programming Logic and Code with Syntax

Home Work Update Complete Code in JAVA With Servlet Programming Logic and Code with Syntax

JAVA Code for Update of details With SQL CODE AND Responce Programming Logic and Code with Syntax

JAVA Code Direct Attendance update with Server Response and SQL Update Programming Logic and Code with Syntax

JAVA Code Attendance with Server Response and SQL Update Programming Logic and Code with Syntax

JAVA Code Academic Calendar with Server Response and SQL Update with admin delete authority Programming Logic and Code with Syntax

JAVA Code Academic Calendar with Server Response and SQL Update Programming Logic and Code with Syntax

Code for Server Response with SQL Update Programming Logic and Code with Syntax

Java Code for Request and Response for android application from MYSQL Database Programming Logic and Code with Syntax

SQL QUERY FOR TRACKING THE DETAILS OF A ITEM FROM MULTIPLE SUPPLIER- Programming Logic And Code