Using sql express for generating the report !!
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
|