Click here to Skip to main content
15,499,825 members
Articles / Database Development / SQL Server

Tagged as

Stats

8.5K views
2 bookmarked

INSERT with SELECT vs INSERT with VALUES

Rate me:
Please Sign up or sign in to vote.
4.92/5 (6 votes)
30 Nov 2010CPOL
You might want to do some further testing... It seems if you perform the following, the values are actually the same:SET NOCOUNT ONDECLARE @TMP TABLE( EmpName VARCHAR(50), Age INT)PRINT CONVERT(VARCHAR, GETDATE(), 121)INSERT INTO @TMP(EmpName, Age)SELECT 'Ravi Kiran',...

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect
United States United States
Since I've begun my profession as a software developer, I've learned one important fact - change is inevitable. Requirements change, code changes, and life changes.

So..If you're not moving forward, you're moving backwards.

Comments and Discussions