Super solution but can't be replicated in other databases like oracle.
Identity is a near equivalent to rowid concept in Oracle but its a dynamic value i.e not a sequence generator . Hence may be Only possible in sql server.
If you change the start value of the identity seed (I'm pretty sure this can be done) and truncate the table the hard coded 1 would fail mind you it is a silly request in the first place and I suspect the OP does not even know what you are talking about.
Never underestimate the power of human stupidity
Not sure it is the right forum...
I'm using VisualStudio 2010 and trying to use schema compare tool to deploy changes from my db project to my database (SQL server 2008).
when trying to deploy the changes I made in my db project I get anexception with the following message:
"Cannot create index. Object 'v_TQ_IFCR_DATA_COVERAGE' was created with the following SET options off: 'ANSI_NULLS, QUOTED_IDENTIFIER'."
If I will go the the index properties,I see that AnsiNulls
and QuatedIdentifiers are set to project default.
When changing those settings to ON I manage to deploy all updates without any exception.
How can I change project default settings?
I have more then 200 different objects(tables,stored procedures,functions,indexes etc.) and I don't want to change the settings of each object.
In my schema compare the options if "Ignore AnsiNulls" and
"Ignore QuatedIdentifiers" where checked,so updated AnsiNulls and QuatedIdentifiers settings was not marked as needs to be updated during the schema compare.
Also,I've set AnsiNulls and QuatedIdentifiers default settings
to true in database.sqlsettings file.
How I can use case statement in where clause…..
Below query raised syntax error.
Select * from Mytable where ((EffectiveDate <= @ MyeffectiveDate AND
CASE WHEN BillingTerminationDate = NULL THEN
(terminationDate is null or BillingTerminationDate > =@ MyeffectiveDate)
ELSE BillingTerminationDate > =@ MyeffectiveDate)
WHAT EXACLY I WANT
If(BillingTerminationDate is null) then where clause should used ” (terminationDate is null or BillingTerminationDate > =@ MyeffectiveDate)” statement.
Other wise used BillingTerminationDate > =@ MyeffectiveDate statement.
Waiting for your need full reply.
Thanks in advance.