Viewing 15 posts - 1 through 15 (of 23 total)
quote:
2. For business intelligence, I think SQL Server is the best product so far. Oracle cannot even export a table to a...
March 16, 2003 at 10:59 pm
My two cents... SQL Server has a good scheduling options. In Oracle to schedule a job, you need to perform calculations with the sysdate variable. MSSQL gives you a...
March 11, 2003 at 5:26 am
I have done this through code. I was looking for a way of doing this through SQL. Its possible in Oracle using the DECODE Statement.
So I was wondering if it...
March 11, 2003 at 5:04 am
Debugging in SQL PLus is something that people get used to. There are a lot of third party tools available for Oracle PL / SQL debugging. One...
March 6, 2003 at 9:40 pm
Hi John,
The best site for Oracle is http://asktom.oracle.com/
Do make it a point to visit it.
Cheers!
Abhijit
March 3, 2003 at 3:46 am
[font=Verdana]
Advantages of SQL Server.
1) Low cost of maintainence (Oracle seems to be catching up)
2) Easy installation and setup
3) T-SQL is easier to learn compared to PL/SQL
4) Identity Keys are...
March 3, 2003 at 12:10 am
The system that we have inherited follows most of the worst-practices mentioned at SQLServerCentral.com
Especially so with comments. We used to have too many comments till we introducted documentation....
February 17, 2003 at 6:59 am
Hi Andy,
That was a good article.
I think most experienced SQL Developers are aware of the difference
between "logins" and "users".
However developers new to this...
February 16, 2003 at 9:50 pm
Hi Ryan and Greg,
Your solutions are appreciated.
Now I wonder what is wrong with my logic. The one I posted originally seemed to be going nowhere.
Cheers!
Abhijit
February 13, 2003 at 9:18 pm
All our code is decrypted on production servers.
February 11, 2003 at 10:16 pm
I tried Paul's solution. Seems to be working for me. I did not get the solution posted by wells. I am using SQL Server 7.0. So I...
February 11, 2003 at 9:03 pm
Thanks a lot Paul, I am still testing out that script.
OF_SP_COUNTER is a generic procedure which counts for the occurrence of a character in a particular string....
February 11, 2003 at 6:21 am
Well my friend, the reason the dates are stored the way they are stored, is L E G A C Y
I do not have an interface to insert the holidays...
February 11, 2003 at 6:05 am
Our product has been implemented across several sites. We use SQL Server.
What has come to our notice is that too much time is being spent fixing...
January 20, 2003 at 9:14 pm
Viewing 15 posts - 1 through 15 (of 23 total)