Useful .net Code Examples

101 Useful .net Code Examples
I found them Useful!!
http://msdn2.microsoft.com/en-us/vstudio/aa718334.aspx
some of them needs AdventureWorks Database installed and configured on your machine with SQL Server 2005 Express
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=5705
if you can’t install the Database with the AdventureWorksDB.Msi on above page,
try AdventureWorksDBScript.msi. It’s the Database Script and you need to run it to create the Database.
Make sure @data_path is set perfectly. It should be the path of the directory where you have install the script files in the MSI installer.
I had to change it as follows
SET @data_path = 'C:\Program Files\Microsoft SQL Server\100\tools\Samples\AdventureWorks OLTP\';
Or it wasn’t doing the BULK Inserts because it wasn’t finding the path of .CSV files that also gets installed by the MSI.
Happy Learning!!