Convert SQL Server 2008 to SQL Server 2005

1.)Convert SQL Server 2008 to SQL Server 2005

http://www.hyper-v-mart.com/HowTo/Convert_SQL_Server_2008_to_SQL_Server_2005.aspx


2.)With data:


1) Right click the database in sql 2008 which you want to do with
2) Choose Task and Generate script
3) Make sure select "script all objects in the database"
4) In the Script Option, choose the item Script for SQL server version to SQL2005
and Script data to be true! Those two are the key steps!
5) Here you go to check the generated script. You should find out insert statement for inserting the data


3.)Debugging Stored Procedures in Visual Studio 2005
http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005

4.)Call Stored procedure from within another stored procedure, return values
http://www.aspfree.com/c/a/ASP.NET-Code/Call-Stored-procedure-from-within-another-stored-procedure-return-values/

5.) Differences between varchar and nvarchar in SQL Server

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1266201,00.html


6.) Calling functions in sql.
http://www.functionx.com/sqlserver/functions/create.htm