MySQL

function to subtract 200 days from date

I need to write the filter condition in cognos as follows: YRMOSDOS between (&YRMOSDOS - 200) AND (&YRMOSDOS) where YRMOSDOS is in date form. How do I achieve it? The database is in db2. Decimal function does not work. Please help. Thanks a lot.

Removing spaces between two words in SQL

Hi, I have a table called employee and column called Name. The column Name contains (firstname lastname)i.e. firstname 'space' lastname. I want to retrieve just the firstname from the column Name for ALL the employees. I have tried using the function "substring" but since the firstname can be...

- DB2 - RPG

My question has two parts: 1- Is there any way to create DB2 at a PC similar to what is exist at IBM I-Series AS/400? 2- Is there any RPG Compiler that I can install and run it and PC?

Importing Data in SQL Server 2000. "Integrity violation error" in RowID column

Hi All, I have a table called Employees(RowID,EmpNo, Lastname, Firstname). Here RowID is autogenerated by the system. It is the primary key and DOES NOT allow NULL values. I CANNOT change the table structure. I am trying to import data from a text file through the Import Data Wizard in...

sqlserver 2000 stored procedures

Hi , i have the unfortunate task of time to integrate microsoft sql server 2000 stored procedures to mysql so that our software will work. Can anybody tell me if this can be done, if so how easy is it and how do i go about it? Thanks for your help andy

Accessing Linked Server in SQL Server 2000 (Urgent)

I have a server named say 'SRVMAIN'. Using Enterprise Manager I added a linked server 'LNKDSRVR1' (existing server). I m able to access any database in 'LNKDSRVR1' by writing a query in query analyzer of 'SRVMAIN' as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as...

Free online practice exercises on SQL/Oracle.

I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? preferably advanced level queries. Thanks, Kruti

SQL Server equivalent of Oracle's desc tablename command

Thank you all for the response to my previous query. What is the T-SQL equivalent of Oracle's desc command? I mean, what is the command in T-SQL to see the structure of a particular table? And what do we do in T-SQL if we want to see list of all the tables in a particular database?

Difference between SQL and T-SQL(Microsoft SQL Server 2000)

What is the difference between SQL and T-SQL(used by Microsoft SQL Server 2000)?

Oracle In Linux

How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

MySQL CrossTab Query

MySQL does not have a crosstab query. Does anyone have some code that will return a datastructure on a crosstab query?

Install MySQL as Non-Root User

Have you been able to install MySQL as a non-root user, if so what steps did you follow.