Hi,
Plz give me answer for following questiions
1. Which step we will follow to imporve the performance of any stored procedure?
(which component should we check?)
2. Which step we wil...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I am trying to write an extended store procedure that returns its data via an output parameter, similar to what one can do with regular stored procedures.
However, I've had no luck with ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Any input will be greatly appreciated.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Could you tell me how to make my backup files not overwrite each other? Right now I have a job setup to run a backup everyday at 12am, but when I arrive in the morning there is just one file in t...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am using Sybase 12.5.4 on Windows 2003 Server. Are xp_write_file and xp_read_file Extended stored procedures available on 12.5.4.
I tried to use these in stored procedure, it gave me followi...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am about to inherit a huge database that has been having issues with the length of time/impact of running a full dbcc.
Is there somewhere I could find a script that would chop the dbcc's d...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
i 've files of old database work with a program on "DOS"
I don't know what database engine it work with
The extension is ".FD" , ".VW" and ".SLP"
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi
I am having a doubt with the reset of Identity Column in a table.
In SQL, DBCC CHECKIDENT query can be used to reset the Identity field to zero, while deleting the table.
Can anyone t...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi ,
I have Sybase ASA 9 backup file. I didnt' have installed Sybase. From where we have to get the Sybase ASA 9 Software?.
But I heared that there is a free developer version available o...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I am Bala from ankai Data solutions,chennai.
Looking for SYBASE DBA for week end training classes.
If You are interested,please call me at 9443921545.
Thanks & Regards,
Bala.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Suppose the conversion from MS Access to SQL Server was done in SQL Server
Version 2000 and after that some modification of database properties done in
SQL Server 2005 Express. Is it possible t...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have to use a stored procedure in one of my sql statement
e.g.
UPDATE tbTable
SET fdField1 = myProc ( fdField2, fdField3)
WHERE
fdField4=someval
its giving error as sybase allows onl...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
For 5 days, our database is corrupt, and i have to analyse the databse log because my boss want another look than our dba.
i have spent the week end to prepare another database to run on it ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
i have table table1 in which i am entering this id as varchar
Genralize view
KUJO.YEAR.MONTH.AUTOINCREAMENT NOS FROM LAST ONE
for example KUJO.05.08.01
WHERE 05 = YR
08 = MONTH
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
Can anybody tell me equivalent command in Sybase for the following command in Oracle ?
Select replace(...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
Where can i download Sybase or a newer release database.
Appreciate your reply in this regard.
Thanks...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Dear All,
What is the SQL syntax to get the first row of a query in Sybase ASE? Something likes in SQL Server 2000 :
SELECT TOP 1 Name
FROM User
Thanks....
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I am new to sybase but know Oracle.I want to install sybase client on a UNIX machine.Plz give me directions on how to invoke the sybase installer.
If any body has any papers on how to in...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
