Genereal Qusestions

I understan that a mobile databse can not have all the functionaliy like a normal Sql server. Identity and more functions are not included. Is this something that will be i the next versions ?

Have also seen people building classes called SqlCeHelper. Were funtions like @.@. identiy is supported. Is there anyway to build these ? How do they work ?

Thank you for answering my stupid questions

Have a nice evening ! Cheers !

Latso,

I'm not sure i understood your question very well.

@.@.IDENTITY is very much supported in SSEv in select queries. If you can tell me what you are looking for specifically, i could be able to help you better.

Thanks

Pragya

generate SQL Script

Hello,
Is possible to generate SQL script which included all schemas and data as
well...
I use "Generate SQL Script" can only generate table schema, store proc,..
but no data inside..
but i believe that it should have a method bcoz some partner will send these
script to me to import db/table
any ideas... Thanks in advanced.http://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"beachboy" <stanley@.javacatz.com> wrote in message news:%23IW$5HthGHA.1864@.TK2MSFTNGP02.phx.gbl...
> Hello,
> Is possible to generate SQL script which included all schemas and data as
> well...
> I use "Generate SQL Script" can only generate table schema, store proc,..
> but no data inside..
> but i believe that it should have a method bcoz some partner will send these
> script to me to import db/table
> any ideas... Thanks in advanced.
>|||Thank you for your reply.
Is must to use third-party application? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ?
news:%23jRpxJthGHA.3756@.TK2MSFTNGP02.phx.gbl ?...
> http://www.karaszi.com/SQLServer/info_generate_script.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "beachboy" <stanley@.javacatz.com> wrote in message
news:%23IW$5HthGHA.1864@.TK2MSFTNGP02.phx.gbl...
> > Hello,
> >
> > Is possible to generate SQL script which included all schemas and data
as
> > well...
> >
> > I use "Generate SQL Script" can only generate table schema, store
proc,..
> > but no data inside..
> > but i believe that it should have a method bcoz some partner will send
these
> > script to me to import db/table
> >
> > any ideas... Thanks in advanced.
> >
> >|||> Is must to use third-party application?
Yes, there's no built-in support for generating ddl and data.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"beachboy" <stanley@.javacatz.com> wrote in message news:%233u%23LOthGHA.4504@.TK2MSFTNGP03.phx.gbl...
> Thank you for your reply.
> Is must to use third-party application? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ?
> news:%23jRpxJthGHA.3756@.TK2MSFTNGP02.phx.gbl ?...
>> http://www.karaszi.com/SQLServer/info_generate_script.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "beachboy" <stanley@.javacatz.com> wrote in message
> news:%23IW$5HthGHA.1864@.TK2MSFTNGP02.phx.gbl...
>> > Hello,
>> >
>> > Is possible to generate SQL script which included all schemas and data
> as
>> > well...
>> >
>> > I use "Generate SQL Script" can only generate table schema, store
> proc,..
>> > but no data inside..
>> > but i believe that it should have a method bcoz some partner will send
> these
>> > script to me to import db/table
>> >
>> > any ideas... Thanks in advanced.
>> >
>> >
>

generate SQL Script

Hello,
Is possible to generate SQL script which included all schemas and data as
well...
I use "Generate SQL Script" can only generate table schema, store proc,..
but no data inside..
but i believe that it should have a method bcoz some partner will send these
script to me to import db/table
any ideas... Thanks in advanced.http://www.karaszi.com/SQLServer/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"beachboy" <stanley@.javacatz.com> wrote in message news:%23IW$5HthGHA.1864@.TK2MSFTNGP02.phx.
gbl...
> Hello,
> Is possible to generate SQL script which included all schemas and data as
> well...
> I use "Generate SQL Script" can only generate table schema, store proc,..
> but no data inside..
> but i believe that it should have a method bcoz some partner will send the
se
> script to me to import db/table
> any ideas... Thanks in advanced.
>|||Thank you for your reply.
Is must to use third-party application? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ?
news:%23jRpxJthGHA.3756@.TK2MSFTNGP02.phx.gbl ?...
> http://www.karaszi.com/SQLServer/in...rate_script.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "beachboy" <stanley@.javacatz.com> wrote in message
news:%23IW$5HthGHA.1864@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
as[vbcol=seagreen]
proc,..[vbcol=seagreen]
these[vbcol=seagreen]|||> Is must to use third-party application?
Yes, there's no built-in support for generating ddl and data.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"beachboy" <stanley@.javacatz.com> wrote in message news:%233u%23LOthGHA.4504@.TK2MSFTNGP03.ph
x.gbl...
> Thank you for your reply.
> Is must to use third-party application? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ?
> news:%23jRpxJthGHA.3756@.TK2MSFTNGP02.phx.gbl ?...
> news:%23IW$5HthGHA.1864@.TK2MSFTNGP02.phx.gbl...
> as
> proc,..
> these
>

Generate Scripts without the Collate statement

using SQL 2K
Just wondering if it is possible to generate scripts without a COLLATE
statement included from EM (I don't see how) or a tool which will allow me t
o
do it.
Currently I simply manually remove all Collate statements after the script
file is created.
KevinI believe there is a script options setting that you can use from EM to do
some global tailoring of your results.
You can set the Formatting Option "Only script 7.0 compatible features"
which will eliminate collation, but it will also drop UDFs and other SQL
2000 features.
RLF
"kevin" <kevin@.discussions.microsoft.com> wrote in message
news:4AFB6BC9-3FC1-41FD-B07E-BB43DD6285C6@.microsoft.com...
> using SQL 2K
> Just wondering if it is possible to generate scripts without a COLLATE
> statement included from EM (I don't see how) or a tool which will allow me
> to
> do it.
> Currently I simply manually remove all Collate statements after the script
> file is created.
> Kevin|||Rusell,
Since I am only interested in in Tables, that actually does the trick.
Thanks.
kevin.
"Russell Fields" wrote:

> I believe there is a script options setting that you can use from EM to do
> some global tailoring of your results.
> You can set the Formatting Option "Only script 7.0 compatible features"
> which will eliminate collation, but it will also drop UDFs and other SQL
> 2000 features.
> RLF
> "kevin" <kevin@.discussions.microsoft.com> wrote in message
> news:4AFB6BC9-3FC1-41FD-B07E-BB43DD6285C6@.microsoft.com...
>
>|||On Thu, 9 Mar 2006 07:30:31 -0800, kevin wrote:

>using SQL 2K
>Just wondering if it is possible to generate scripts without a COLLATE
>statement included from EM (I don't see how) or a tool which will allow me
to
>do it.
Hi Kevin,
You can't control this from EM, but you can control it if you use Query
Analyser and the Object Explorer (hit F8 while in QA) to script.
In QA, click Tools / Options / Script. Then check or unchekc the option
"Do not script the collation if source is an instance of SQL Server
version 7.0 or later".
Hugo Kornelis, SQL Server MVP|||Hugo,
After all these years, I never noticed that. Thanks
Kevin
"Hugo Kornelis" wrote:

> On Thu, 9 Mar 2006 07:30:31 -0800, kevin wrote:
>
> Hi Kevin,
> You can't control this from EM, but you can control it if you use Query
> Analyser and the Object Explorer (hit F8 while in QA) to script.
> In QA, click Tools / Options / Script. Then check or unchekc the option
> "Do not script the collation if source is an instance of SQL Server
> version 7.0 or later".
> --
> Hugo Kornelis, SQL Server MVP
>

Generalisation schema Help(GIF Schema included)

I have a CASE(law firm type) table which uses a "case number" as a PK.
Each case can have zero-many "case plans" of three different types of
case plans, namely: (civil, tax, criminal).

I have created 3 different tables for each respective "case plan" type as their
details differ quite significantly. I have created an Audit table which holds
information about updates and inserts made to these tables.

My problem is referencing a specific "case plan" in the Audit table
as the CasePlanID in the Tax,Criminal,Civil tables could be the same, and
the only uniqueness to those tables is the table name (ie: Tax,Criminal,Civil).

I have thought of placing a "CONSTANT" column in each table with the type of the
Case plan as the value, but this introduces a lot of redundancy.
I have also thought of having an audit table for each respective case plan table
but this doesnt seem like good practice.

Perhaps a Generalisation class between Case and caseplans would help.

I also have to report across the case plans too.

Any help would be much appreciated ;-)What's interesting is that you have modelled them like they're inherited (as in OOP). What is the difference between the case plan types? Different columns? Are you likely to add another case plan type at some point in time?

Edit : forgive me i'm being a goon. You clearly state that their details differ quite significantly. What are those details? Can they be normalised?|||It would seem like your case plan type can be seperated into a seperate table as your case will ALWAYS have a plan type. So you can normalise those into another table:

CREATE TABLE CasePlanTypes(
PlanTypeID INT NOT NULL,
PlanName VARCHAR(255)
)|||There will only be 3 case plan types and no more.
The types differ quite a lot. there ARE about 10 columns of similarity between all 3, however, Civil and Criminal have about 20 additional columns and between civil and criminal, about 12 of those 20 are similar in data type, but semantically different. Example:
Tax: {Gross_amount_taxed_for_quarter, Net_Amount_taxed_for_Quarter}
Civil:{Gross_Amount_Reclaimed_for_quarter,Net_amou nt_reclaimed_for_quarter}