Showing posts with label generation. Show all posts
Showing posts with label generation. Show all posts

Friday, March 23, 2012

How to use sql express in offline mode for report generation ?

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)

sql

Wednesday, March 21, 2012

How to use sql express in offline mode for report generation ?

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)

sql