clike

hello
in mysql exist the operator clike that there is similar of like but there isn't key-sensitive. In oracle there is a similar operator?
And there is an operator similar of the function iif of access?

Thak you ElisaOriginally posted by trilly
hello
in mysql exist the operator clike that there is similar of like but there isn't key-sensitive. In oracle there is a similar operator?

And there is an operator similar of the function iif of access?

Thak you Elisa
Do you mean case-sensitive? No, in Oracle you would have to use UPPER or LOWER to force case, e.g.

WHERE UPPER(name) LIKE 'SMITH%'

What does IIF do? I'd guess it is probably something like Oracle's DECODE:

SELECT DECODE(status,1,'new',2,'old','unknown') FROM mytable;

This means:
Check value of mytable.status;
If it is 1 then return 'new'
If it is 2 then return 'old'
For any other values return 'unknown'

(Note: DECODE is not limited to 3 return values as in my example)

Client Side Sequential Guid Generation

Is it possible to generate a Guid on the client side similar to
NEWSEQUENTIALGUID()?
I need a solution to PK generation that benefits from Guid so i can create
an object graph on the client side without the performance problems of
standard Guids.
Master-Detail data will be inserted into a Dataset and posted to the
database in one transaction to save round trips in a web service
application.here is from an old post:
http://groups.google.co.uk/groups/s...ql+oj+dllimport
-oj
"Anthony" <aa@.noreply.com> wrote in message
news:%233QzigLeGHA.3888@.TK2MSFTNGP04.phx.gbl...
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>|||Hi Anthony
If you want to identify the individual client then you a GUID would not give
you that information, therefore you would probably end up storing that as a
separate column which is part of a composite key. For SQL Server the other
column could be an Identity which would give you incrementing numbers and if
you needed these to be contiguous then they could be ranked. The other
alternative would be to maintain a counter for each client that you incremen
t.
John
"Anthony" wrote:

> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>
>|||It depends on the application. If it's a .net app, then it's very easy to
generate the guid by using the Guid.NewGuid() method. (It sounds like it
from the use of DataSet, which is a .net class.)
There should be a way from other languages to generate a guid.
"Anthony" <aa@.noreply.com> wrote in message
news:%233QzigLeGHA.3888@.TK2MSFTNGP04.phx.gbl...
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>|||Sorry, I mean I NEWSEQUENTIALGUID() was introduced to counter the
performance problems of the standard Guid. BUt I would like my Id
generated within my .NET app.
Anthony wrote:
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.

Client Side Sequential Guid Generation

Is it possible to generate a Guid on the client side similar to
NEWSEQUENTIALGUID()?
I need a solution to PK generation that benefits from Guid so i can create
an object graph on the client side without the performance problems of
standard Guids.
Master-Detail data will be inserted into a Dataset and posted to the
database in one transaction to save round trips in a web service
application.here is from an old post:
http://groups.google.co.uk/groups/search?hl=en&q=sql+oj+dllimport
-oj
"Anthony" <aa@.noreply.com> wrote in message
news:%233QzigLeGHA.3888@.TK2MSFTNGP04.phx.gbl...
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>|||Hi Anthony
If you want to identify the individual client then you a GUID would not give
you that information, therefore you would probably end up storing that as a
separate column which is part of a composite key. For SQL Server the other
column could be an Identity which would give you incrementing numbers and if
you needed these to be contiguous then they could be ranked. The other
alternative would be to maintain a counter for each client that you increment.
John
"Anthony" wrote:
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>
>|||It depends on the application. If it's a .net app, then it's very easy to
generate the guid by using the Guid.NewGuid() method. (It sounds like it
from the use of DataSet, which is a .net class.)
There should be a way from other languages to generate a guid.
"Anthony" <aa@.noreply.com> wrote in message
news:%233QzigLeGHA.3888@.TK2MSFTNGP04.phx.gbl...
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>|||Sorry, I mean I NEWSEQUENTIALGUID() was introduced to counter the
performance problems of the standard Guid. BUt I would like my Id
generated within my .NET app.
Anthony wrote:
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.