Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Good reference for SQL to use with SQL Server 2008 [closed]

I had been working on Oracle long time back and has exposure to SQL. Now I need to brush up my SQL skills for a project on SQL Server 2008. Could you please recommend a good resource (online/book)?

like image 399
softwarematter Avatar asked Mar 05 '12 02:03

softwarematter


People also ask

When did SQL 2008 end of life?

SQL Server 2008 and 2008 R2 End of Life SQL Server 2008 and SQL Server 2008 R2 reached their end of support on July 9, 2019, while Windows Server 2008 and Windows Server 2008 R2 reached their deadline together with Windows 7 on January 14, 2020.

Can you restore a SQL 2008 database to SQL 2019?

SQL Server 2019 is not supported on Windows Server 2008 R2, which is in any case heavily out-of-date and insecure. If you wanted to go with a direct upgrade path for your existing server, you must: First upgrade the operating system to Windows Server 2012 R2.

Is SQL Server 2008 R2 compatible with Windows Server 2019?

The only option one should follow if they are using SQL Server 2008/R2, is to upgrade it to the latest version of the SQL Server. SQL Server 2019 allows you to directly upgrade from SQL Server 2008/R2 and keep the database compatibility to the earlier version.


1 Answers

The "books online" help isn't too bad for SQL2008 i.e. usually several examples, shows the syntax clearly. You can download it separately.

like image 178
Peter Wishart Avatar answered Oct 05 '22 18:10

Peter Wishart