Consult everybody:
C # programming, SQLSERVER2014 and various SQLSERVER2008 add and delete, database connection, etc.,
Question 1: statements are exactly the same? If change from 2008 to 2014, c # program does not need to change?

Question 2: I used the 2014 version, it has a management studio, very convenient, may establish database, table, etc., 2008 also have such a function?

CodePudding user response:

Question 1: backward compatibility, 2008 litres to 2014 can not change the code
Question 2: yes,,,

CodePudding user response:

Thanks to 1 floor, in addition to ask, what I use is VS2015, this operation SQLSERVER2008 is there a problem? There is a problem on version will match? Like someone said that this is not on the phenomenon,
I'm not sure, whether VS2015 essentially a version is required? Thank you very much!

CodePudding user response:

Basically there is no problem,

But also not to say that 100%,
There are some new features, such as alwayson connection string is different, however, there is no problem you don't deeply,

CodePudding user response:

Have not used 2014, only 2012, function should be about the same

CodePudding user response:

Program 2008, others use VS2015 open, no, in SQL2014 well,

CodePudding user response:

reference 5 floor sam10000 reply:

program 2008, others use VS2015 open, no, in SQL2014 well,

SQL, there may be 2008 can directly call in 3 seconds, in 2014 and above versions with more than 10 minutes,,,