Blog

SQL Insert

SQL

SQL Insert

Query to insert data into table. Here in this table, since EmployeeId is identity column, thus we don’t need to include this in the select command as it will get auto incremented.

				
					INSERT INTO EMPLOYEE 
		  (FirstName, 
		   LastName, 
		   Age)
	VALUES 
		  ('Steve',
		   'Jobs',
			44)
				
			

Now, after running the select statement, we will get the above inserted data in the table as follows

SQL select

Please comment and share if you like this post and tell us about how we can enhance our posts. Thanks.

Subhajit