Hi there,
I am inserting values manually as shown but I am getting error about the datetime field. Could someone point out what am I doing wrong here? thanks
insert into tableOne
(rcp...
Hi,
I'm trying to come up with the best way of simulating the same behaviour that an oracle RANK function would perform in the Sybase ASE realm....
Any ideas how this can be achieved?
...
Can anyone tell me exactly how to do load a database by using dump file (from dump database)? I just wanna know what should i do first and after loading for example checking statistic, space u...
I am currently trying to calculate the number of weekdays between 2 dates, I can do this by doing the following:
CREATE PROC working_days @date_start datetime,@date_end datetime
D...
hi,
i want to export data from a table to a flat file. I want to do this operation from my stored procedure after doing some manipulations with the table. I know there is a comman "export to...
Hi all,
I am new to Sybase. Can someone tell me how to retrieve a set of records from a select query result based on the rownum.
In Oracle I will do the same as follows to get the 5 emplo...
I want to find out what number is the nth Percentile of a group of numbers.
For example:
If I have the numbers (1,2,3,4). What number would be in the 75th percentile?
The answer is 3...
I have an application which i migrated from EA server to weblogic. it is using sybase database.
Now applicataion runs fine on Sybase ea server but throwing an error on weblogic when applicati...
I'm running Sybase 11.9.2, with raw partitions, on AIX. Is using "dbcc checkdb('dbname')" the best (I know it's not speed wise...but in reliablity) way to check the DB for integrity. What al...
Am I right that Sybase 12.5 supports varchar of > 1000 characters?
When I defined a field to be of varchar(1000), do I have to take into consideration the total length of the other fields o...
Hi
What is the isql syntax for conneting to a Database(a.c.d.f.). I want to connect to a database using its IP from my Windows machine through command prompt.
Firoze
Hi Sybase Gurus,
I am trying to write dynamic SQL to return a query value into a variable (@result).
The database server is Sybase 12.5.
The SQL statement is as below:
SELECT @sSQL =...
I want to create a substring that starts at the last instance of a character in a string. For instance, if I have a string such as: 'Johnson-Johnson-New York' then I want to get the substri...
Hi Guys
I am looking for a way to convert master..sysdatabases columns: crdate and dumptrdate into seconds since the UNIX epoch. Perferably I would like the databases to do this but failin...
How can I insert an if statement inside of a Sybase select statement. I am trying to do this from within Visual Studio. For example something like my code below.
Hi,
Here is some information about the bcp command that you might find helpful in answering this question:
usage: bcp[[database_name.]...
This seems like such an obvious question but I have yet to find a solution:
How can I install the ODBC Drivers for Adaptive Server Anywhere (version 8 or above) without having to install an...
Afternoon all I am working with a Sybase query that I need to do two things in:
1) I need to get the current date in the format of mm/dd/yyyy I have looked at convert and getDate() and I am...
Hi,
I am having difficulty with a simple SELECT statement. I am using QBE Vision on a Sybase SQL server.
The two fields of interest in myTable are 'id' (type INT) and 'StartDate' (type ...
Hi,
I work for a software company that provides membership and member data management software. When we get new clients, I take what ever data sources they have, be they simple excel docume...
I would like to code a Stored Procedure depending the on IN params that are passed to the SP
example: EXEC Abc_SP 'Param1'
Note: Param1 is optional
Inside the SP, i would like to ...
I have a Sybase SQL Anywhere database running on a linux computer
I need to know how to connect to the database from a Windows computer from a ASP.NET appplication
I have tried configuring ...
I have got a string "abs1233as44" . I want all charaters to be removed that is [a-z, A-Z]. resultant string should be "123344".
can you please help me do this? I don't want o have a stored p...
Help! I wrote a stored procedure as the following, I want to debug it, but I didn't know how to do. I have ever tried to show all the local variables of the procedure, but when I use "print...
If I have the following table:
Table
---------
ID(integer) Cost(float)
2 1.1499999999999999
and then run the following update:
update Table
set C...
