retrieve data from SQL Server 2005

[u0107]

Hello all,

To someone familiar with Microsoft SQL Server 2005, this should be a simple matter - could someone help?

I am looking for a very simple script which will read from a table named say Tactic_table which has fields named TT_35, TT_36, TT_37 and TT_38.

I want to display on a webpage the values in TT_36, TT_37 and TT_38 based on the value contained in TT_35.

TT_35 is a 10 character nvarchar. If the last 2 characters are "00" then I want to display TT_36, TT_37 and TT_38.

Thanks in advance

Uttam

[FaMe FacToR]

You will need to create a ODBC DNS for SQL to connect to a Web page. You can use Visual Studio to create a visual interface for a web-page by creating a custom activeX control.I'm not sure what excatly to do, but this will work, i did some similar stuff when i was in college...

[Praetor]

SQL Server supports restoring data on the following levels :

• The database (a complete database restore)
  
  • The whole database is restored and recovered, and the database is offline for the duration of the restore and recovery operations
  .
• The data file (a file restore)
  
  • A data file or a set of files is restored and recovered. During a file restore, the filegroups that contain the files are automatically offline for the duration of the restore. Any attempt to access an offline filegroup causes an error.

Note : You cannot back up or restore individual tables.

• The data page (a page restore)
  
  • Under the full recovery model or bulk-logged recovery model, you can restore individual databases. Page restores can be performed on any database, regardless of the number of filegroups.

Note : In SQL Server 2008, you can restore a database backup that was created by using SQL Server 2000, SQL Server 2005, or SQL Server 2008. However, backups of master, model and msdb that were created by using SQL Server 2000 or SQL Server 2005 cannot be restored by SQL Server 2008. Also, SQL Server 2008 backups cannot be restored by any earlier version of SQL Server.

SQL Server backup and restore work across all supported operating systems, whether they are 64-bit or 32-bit systems.