Hi , I have been using ms sql 2000 database for generating reports up till now . but now as per a new requirement , i have to obtain data for generating the report from sql express & not ms sql 2000 , and that too in offline mode . i do not know how the structure of data is there in sql express . 1)do we have data stored in tables? or do we use xml ? 2)do we write similar queries as we write in ms sql ?? 3) and lastly what is this offline stuff ? Can any one please throw some light on comparison between sql 2000 and sql express in these three points. Thanks in advance
>I do not know how the structure of data is there in sql express . 1)dowe have data stored in tables? or do we use xml ?
Data is stored in tables as in SQL2000 or SQL2005 - the limitation is on the size of the database. You can also use XML when in
2)do we write similarqueries as we write in ms sql ?
Just the same!
3) and lastly what is this offlinestuff ?
Offline refers to getting data from a ource other than SQL Server (which includes SQL 2005 Express)
No comments:
Post a Comment