table hosed: equivalent

Showing posts with label equivalent. Show all posts

Friday, March 30, 2012

Is there a SQL Server equivalent of the Oracle 'decode' function?

I am trying to redeploy an Oracle system using a SQL server database, but am
getting a SQL error saying that 'decode' is not a vaild SQL command.
Is there a SQL Server equivalent of the Oracle function 'decode'?
IIRC, the equivalent is the CASE construct. Check it out in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"elaine" <elaine@.discussions.microsoft.com> wrote in message
news:AA50F50A-EB1A-463E-BC93-0E6073108A75@.microsoft.com...
I am trying to redeploy an Oracle system using a SQL server database, but am
getting a SQL error saying that 'decode' is not a vaild SQL command.
Is there a SQL Server equivalent of the Oracle function 'decode'?
|||Use CASE function
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OZ0eFHPvEHA.592@.TK2MSFTNGP15.phx.gbl...
> IIRC, the equivalent is the CASE construct. Check it out in the BOL.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "elaine" <elaine@.discussions.microsoft.com> wrote in message
> news:AA50F50A-EB1A-463E-BC93-0E6073108A75@.microsoft.com...
> I am trying to redeploy an Oracle system using a SQL server database, but
> am
> getting a SQL error saying that 'decode' is not a vaild SQL command.
> Is there a SQL Server equivalent of the Oracle function 'decode'?
>

Is there a SQL Server equivalent of the Oracle 'decode' function?

I am trying to redeploy an Oracle system using a SQL server database, but am
getting a SQL error saying that 'decode' is not a vaild SQL command.
Is there a SQL Server equivalent of the Oracle function 'decode'?IIRC, the equivalent is the CASE construct. Check it out in the BOL.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"elaine" <elaine@.discussions.microsoft.com> wrote in message
news:AA50F50A-EB1A-463E-BC93-0E6073108A75@.microsoft.com...
I am trying to redeploy an Oracle system using a SQL server database, but am
getting a SQL error saying that 'decode' is not a vaild SQL command.
Is there a SQL Server equivalent of the Oracle function 'decode'?|||Use CASE function
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OZ0eFHPvEHA.592@.TK2MSFTNGP15.phx.gbl...
> IIRC, the equivalent is the CASE construct. Check it out in the BOL.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "elaine" <elaine@.discussions.microsoft.com> wrote in message
> news:AA50F50A-EB1A-463E-BC93-0E6073108A75@.microsoft.com...
> I am trying to redeploy an Oracle system using a SQL server database, but
> am
> getting a SQL error saying that 'decode' is not a vaild SQL command.
> Is there a SQL Server equivalent of the Oracle function 'decode'?
>

Is there a SQL Server equivalent of the Oracle 'decode' function?

I am trying to redeploy an Oracle system using a SQL server database, but am
getting a SQL error saying that 'decode' is not a vaild SQL command.
Is there a SQL Server equivalent of the Oracle function 'decode'?IIRC, the equivalent is the CASE construct. Check it out in the BOL.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"elaine" <elaine@.discussions.microsoft.com> wrote in message
news:AA50F50A-EB1A-463E-BC93-0E6073108A75@.microsoft.com...
I am trying to redeploy an Oracle system using a SQL server database, but am
getting a SQL error saying that 'decode' is not a vaild SQL command.
Is there a SQL Server equivalent of the Oracle function 'decode'?|||Use CASE function
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OZ0eFHPvEHA.592@.TK2MSFTNGP15.phx.gbl...
> IIRC, the equivalent is the CASE construct. Check it out in the BOL.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "elaine" <elaine@.discussions.microsoft.com> wrote in message
> news:AA50F50A-EB1A-463E-BC93-0E6073108A75@.microsoft.com...
> I am trying to redeploy an Oracle system using a SQL server database, but
> am
> getting a SQL error saying that 'decode' is not a vaild SQL command.
> Is there a SQL Server equivalent of the Oracle function 'decode'?
>sql

Is there a SQL Server equivalent for Oracle synonyms?

I have a SQL Server database which has one user (UserA) which owns some tables. I've added an additional user (UserB) to the database such that it has access to the tables owned by UserA. What is happening is that when I log on as UserB I have to fully qualify table names and fields in my SQL statements when I deal with tables owned by UserA. Is there a way make the tables accessible without specifying the owner? In Oracle you could create a public synonym for the table eg. <table_name>. Wherever that synonym is referenced the DBMS would know thats its refering to UserA.<table_name>. Is such functionality available in SQL Server? Thanks.I found out that if the tables belong to 'dbo' they can be accessed without the fully qualified names.|||Specifying schema owner is a good practice. It releaves the optimizer to do it EVERY time you choose to be lazy about it.

Wednesday, March 28, 2012

Is there a MSSQL Equivalent to mysql_num_rows()?

Hi there,
I am trying to find an equivalent to the MySQL function mysql_num_rows() that returns the number of rows returned in a result set.

I only found COUNT, but that doesnt work...

I am working on a web authentication system. The User enters UN and PW, which is then checked with the DB.

<?PHP
//connect to the mssql server
xxx
//select the database to use
xxx
// query
$query = "SELECT * from $table WHERE username='$username' AND pwd='$pwd'";
$result=@.mssql_query ($query);

$bla=COUNT($result);
echo $bla; // just to see if it works
if ($bla=1)
{
echo ("welcome $username");
}
elseif ($bla!=1)
{
echo ("auth required");
}

?>

$bla always returns 1... regardless of the UN and PW have been entered and whether they match an entry in the DB

Any thoughts?

cheers.Daft... mssql_num_rows()
the obvious is slapping my face.

shame...

just ignore...|||The 1 signifies that the query is executed, it is not the count of the resultset. If you are really looking at a good abstraction layer for database access in PHP, check
http://php.weblogs.com/ADODB
It is very easy to use.|||I'd do it like this:

$query = "if exists(SELECT * from $table WHERE username='$username' AND pwd='$pwd') select RetVal=1 else select RetVal=0"

Monday, March 26, 2012

Is there a equivalent tool to Oracle HTML DB for SQL Server

Oracle have released a free download to enable non-developers without
application development experience to quickly build professional web
enabled applications.
The tool oracle as released for download at this URL:
http://www.oracle.com/technology/products/database/application_express/index.html
is there a similar tool for SQL Server from Microsoft. Apparently,
Oracle features even case studies where customers have rapidly built
even planning and budgetting applications with the Oracle HTML DB.
I know a much primitive tool to Oracle HTML DB was available a while
ago for SQL Server called web matrix but now that as disappeared. I am
keen to see a similar tool for SQL Server to rapidly build web
applications.
Thanks
KarenHi,
I used before CodeCharge (www.yessoftware.com) and now Adenin Solutions
(www.adenin.com).
Regards, Marco
KarenM schreef:
> Oracle have released a free download to enable non-developers without
> application development experience to quickly build professional web
> enabled applications.
> The tool oracle as released for download at this URL:
> http://www.oracle.com/technology/products/database/application_express/index.html
>
> is there a similar tool for SQL Server from Microsoft. Apparently,
> Oracle features even case studies where customers have rapidly built
> even planning and budgetting applications with the Oracle HTML DB.
> I know a much primitive tool to Oracle HTML DB was available a while
> ago for SQL Server called web matrix but now that as disappeared. I am
> keen to see a similar tool for SQL Server to rapidly build web
> applications.
> Thanks
> Karen|||Thanks for the pointers I have already looked at the Visual web express
but still it needs coding. If you look at the Oracle Express I got a
evaluation userid and uploaded some of my spreadsheet databases I
maintain my catalog of DVDs, Music CDs and books into the Oracle
database without one line of coding and now I can securely sign on to
this web site and maintain all my information not only that it as all
fancy reporting components built in like gauge, charts,etc all from a
web browser user interface. All this does not need even one line of
coding. I tried it myself.
The development tools themselves are all web based. Oracle is pitching
it at companies to get rid of Access and Excel databases and store data
in a central & secure location with the Oracle Application Express. I
want to do the same with SQL Server provide tools that empower the end
users to setup their own applications all based on the web. This will
make it attractive for users maintaining Access databases and
spreadsheets causing all kinds of chaos to move into a centralised
managed environment but still have all the flexibility they wanted.
Cheers
Karen|||Hi,
I know Oracle is pushing Portals and use it as one frontend for all
your business needs.
But if you are using Word, Excel you want one platform where you can
store all your information structured and non structured. With WebDav
this nis very easy just save your word doc and it is automatic in the
folder in your portal. Can this be more easy no upload just works as
you used before and look at the great Application Builder. It is even
easier than Access to make solution and automatic webbased, incl.
reporting!
Demo:
http://demo.dynamicintranet.com/adenin/diHome.asp
Register for your free trial:
http://demo.dynamicintranet.com/adenin/diHome.asp
Regards, Marco
www.gmsbv.nl - your information worker company !
KarenM schreef:
> Thanks for the pointers I have already looked at the Visual web express
> but still it needs coding. If you look at the Oracle Express I got a
> evaluation userid and uploaded some of my spreadsheet databases I
> maintain my catalog of DVDs, Music CDs and books into the Oracle
> database without one line of coding and now I can securely sign on to
> this web site and maintain all my information not only that it as all
> fancy reporting components built in like gauge, charts,etc all from a
> web browser user interface. All this does not need even one line of
> coding. I tried it myself.
> The development tools themselves are all web based. Oracle is pitching
> it at companies to get rid of Access and Excel databases and store data
> in a central & secure location with the Oracle Application Express. I
> want to do the same with SQL Server provide tools that empower the end
> users to setup their own applications all based on the web. This will
> make it attractive for users maintaining Access databases and
> spreadsheets causing all kinds of chaos to move into a centralised
> managed environment but still have all the flexibility they wanted.
> Cheers
> Karen|||Marco
Today IT managers are trying to reduce the number of vendors Microsoft,
Oracle
and IBM are the shortlist of the software vendors. We want a solution
for
SQL from Microsoft besides we do not want to use Access and Excel to
store data
if it is structured data it must reside in SQL and have a good web
based
tool to build data capture and reporting on it which end users can do
it. I
would say Microsoft must even extend this to Analysis Services to be
able to
store data into Analysis Services and do reporting of analysis Services
all from a web frontend. To me it does not sound rocket science Oracle
have
already built the web application express which end users or business
analysts
can customise and deploy a enterprise wide solution.
What I am referring to in the Oracle Application Express is a great
simple
and very effective web enablement solution for the relational database
it almost
does the same thing what Access provides a simple mechanim to capture
and report
on data except unlike Access it does not have scalability, security &
deployment
issues. With companies running SQL Server extensively I was wondering
if there is
a similar tool like Oracle application express for SQL Server the
Oracle app express
as everything to build small or large transaction/data capture systems
and report
on the data and secure the application and still leave the data on a
secure
backend systems than having spreadsheets and access databases all over
the place.
Appears so far I have not heard that such a similar tool exists for SQL
Server
perhaps we will wait until Microsoft builds a similar SQL Server Web
Application
Express or something like that :)-
Thanks
Karen
Marco wrote:
> Hi,
> I know Oracle is pushing Portals and use it as one frontend for all
> your business needs.
> But if you are using Word, Excel you want one platform where you can
> store all your information structured and non structured. With WebDav
> this nis very easy just save your word doc and it is automatic in the
> folder in your portal. Can this be more easy no upload just works as
> you used before and look at the great Application Builder. It is even
> easier than Access to make solution and automatic webbased, incl.
> reporting!
> Demo:
> http://demo.dynamicintranet.com/adenin/diHome.asp
> Register for your free trial:
> http://demo.dynamicintranet.com/adenin/diHome.asp
> Regards, Marco
> www.gmsbv.nl - your information worker company !
> KarenM schreef:
> > Thanks for the pointers I have already looked at the Visual web express
> > but still it needs coding. If you look at the Oracle Express I got a
> > evaluation userid and uploaded some of my spreadsheet databases I
> > maintain my catalog of DVDs, Music CDs and books into the Oracle
> > database without one line of coding and now I can securely sign on to
> > this web site and maintain all my information not only that it as all
> > fancy reporting components built in like gauge, charts,etc all from a
> > web browser user interface. All this does not need even one line of
> > coding. I tried it myself.
> >
> > The development tools themselves are all web based. Oracle is pitching
> > it at companies to get rid of Access and Excel databases and store data
> > in a central & secure location with the Oracle Application Express. I
> > want to do the same with SQL Server provide tools that empower the end
> > users to setup their own applications all based on the web. This will
> > make it attractive for users maintaining Access databases and
> > spreadsheets causing all kinds of chaos to move into a centralised
> > managed environment but still have all the flexibility they wanted.
> >
> > Cheers
> > Karensql

Friday, March 30, 2012

Is there a SQL Server equivalent of the Oracle 'decode' function?

Is there a SQL Server equivalent of the Oracle 'decode' function?

Is there a SQL Server equivalent of the Oracle 'decode' function?

Is there a SQL Server equivalent for Oracle synonyms?

Wednesday, March 28, 2012

Is there a MSSQL Equivalent to mysql_num_rows()?

Monday, March 26, 2012

Is there a equivalent tool to Oracle HTML DB for SQL Server

Is there a equivalent tool to Oracle HTML DB for SQL Server

Is there a equivalent tool to Oracle HTML DB for SQL Server

Is there a equivalent tool to Oracle HTML DB for SQL Server

table hosed

Blog Archive

About Me