Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 01-07-2009
Member
 
Join Date: Jul 2009
Posts: 1
retrieve data from SQL Server 2005

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
Reply With Quote
  #2  
Old 01-07-2009
Member
 
Join Date: Jan 2009
Posts: 710
Re: retrieve data from SQL Server 2005

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...
Reply With Quote
  #3  
Old 01-07-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: retrieve data from SQL Server 2005

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.

Quote:
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.

Quote:
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "retrieve data from SQL Server 2005"
Thread Thread Starter Forum Replies Last Post
Way to retrieve the data from WD external hdd Sujit15 Hardware Peripherals 4 24-03-2009 06:05 PM
How to access and retrieve data from HDD ? Caden Hardware Peripherals 3 21-02-2009 06:22 PM
EasyPHP : retrieve data Yaropolk Software Development 2 22-11-2008 03:44 PM
Upgrade fails: SQL Server Express 2005 to SQL Server 2005 Steve BB Small Business Server 3 11-06-2008 07:37 PM
Installing SQL Report Server 2005 on Server 2008 Marcos Benites Windows Server Help 1 25-04-2008 05:54 PM


All times are GMT +5.5. The time now is 04:30 AM.