Asp.net,C#.net,Sql Srver problems and solutions Blog

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/overview.htm#LNPLS001 pivot example http://www.kodyaz.com/articles/t-sql-pivot-tables-in-sql-server-tutorial-with-examples.aspx

http://www.simple-talk.com/sql/database-administration/working-with-the-bcp-command-line-utility/ Export: bcp testdb.dbo.TBL_BOOKINGS out C:\sqlbackup\test8.txt -S ipadress/servername -U sa -P password -n Import: bcp testdb.dbo.TBL_BOOKINGS in C:\sqlbackup\test8.txt -S ipadress/servername -U sa -P password -n

Fix this issue by doing like this. 1. Under ‘Accessories’ from ‘All Programs’, right-click the Command Prompt shortcut and select ‘Run as Administrator’. Accept the UAC warning when prompted. 2. From the command prompt change to the directory that holds the SSMSEE installation .MSI file. 3. Enter the command .\SQLServer2005_SSMSEE_x64.msi if you’re running Vista x64 /windows7(64-bit) or .\SQLServer2005_SSMSEE.msi if you’re running Vista x86 (32-bit) 4. Press enter and complete the installation as normal.