-
How to multiply all values of a single column.
samala_naresh
- Aug 7th, 2008
Declare @var intselect @var = 1update set @var = @var*< colname >select @var
-
How can you change to get the decimal separator as comma instead of the decimal point (.)?
protech
- Jul 15th, 2010
declare @mod_string varchar(20)select @mod_string = str_replace("1234.567",".",",")select @mod_string
debadritab
- Jun 24th, 2008
declare @source varchar(30)
select @source = "10.236.155.17"
while charindex(".",@source) > 0
begin
select @source = stuff(@source,charindex(".",@source),1,",")
end
select @source -
Which one is faster count(*) or count(1) ?
-
What is the major differences between Oracle & Sybase
chrisjej
- Jun 23rd, 2010
I would point out that the above answers are point in time - and any answer should mention the versions involved. Sybase is a company - not a database server, by the way. The question should be asking...
tuliothx
- Jul 5th, 2008
Let me clarify that while Sybase does not have "Object Tables" it can hold BLOBS in columns in tables. These can be of datatype TEXT or IMAGE.Sybase has the concept of Temporary tables in the form of ...
-
How is Workspace used in Sybase?
anubhashjain
- Jun 18th, 2010
Workspaces are special tables in dbccdb that store intermediate results of the dbcc checkstorage operation. Workspaces differ from worktables in that they: -- Are preallocated contiguously ...
-
Master Database Size
What are the default size of master database in sybase ?
ravi.marennavar
- May 21st, 2010
It depends on your logical page size of serverif logical page size is 2K-master db will be of 13mbif 4k - 26mbif 8k - 52mb
Satsun
- Apr 24th, 2009
The default size of a master database in sybase is 6MB for a 2K page size Adaptive server.
-
Replication Exception Log
What is exception log in replication?
Rep_dba
- Apr 1st, 2010
Skipped transactions and orphaned transactions in replication server are logged into Exceptions log. Exception log is set of three RSSD tables rs_exceptshdr, rs_exceptscmd, rs_systext. You can run rs_helpexception to see the exceptions.
-
Replication Thread
How will you handle when an replication thread goes down?
Rep_dba
- Apr 1st, 2010
Check Replication server error log to see why the thread is down. Fix the error and resume the thread. If it is DSI thread that is down, run following command in Rep server.resume connection to data_server.database
-
A column name is given to you. You have to find out which table has that column. Database has 230 tables. For example: empid (column name) For this how do you find out which table has the column (empid) ?
nishusingh84
- Oct 8th, 2009
SELECT DISTINCT o.name FROM sysobjects o,syscolumns cWHERE o.id=c.id ANDc.name='empid' --- or you can go for c.name LIKE "%empid%"
-
What is a deferred update in sybase?
nagaraju_p
- Sep 9th, 2009
Deferred update is donewhen the updated row does not fit in the same pagewhen the updated row needs to change information on the index pagewhen there is a subquery in the table joinwhen the update happens to the primary key which is being referenced by other foriegn keys.
JamesMike
- May 5th, 2007
Deferred updates are carried out by adaptive server. Generally in deferred updates the affected rows are analyzed and further updations needed on these rows are carried out by the adaptive server. In ...
-
How to find out the maximum sales of an item for each sales man.The table consists sales_man, item, sales columns, each sales man will have the different sales values for different items.here I have to find out for every sales man, which item he sold maximum
nagaraju_p
- Sep 9th, 2009
Select a.sales_person, a.item, a.TotalQuantityFROM (select b.sales_person,b.item,SUM(b.InvAmount ) as TotalQuantity from sales_data bGroup by b.sales_person,b.item)as aGROUP BY a.sales_personHAVING a.TotalQuantity = MAX(a.TotalQuantity )
swadheengupta
- Sep 8th, 2008
Assuming that both the items are required to be shown if two or more items are sold of same quantity. The query is :-select sales_man,item,sales from table where (sales_man,sales) in? (select sales_man,max(sales) from table group by sales_man);
-
Why can a user create 249 non clustered indexes over a given table as against only one clustered index over a table?
rachitkhanna1981
- Sep 1st, 2009
When 1 clustered index is being formed on a table then the values when entered into the table have to be in the same form or there would be an error message whereas nothing of this sort is being used in non clustered index therefore more then 1 could be created.
harish_varghese
- Jun 11th, 2007
With a clustered index, Adaptive Server sorts rows on an ongoing basis so that their physical order is the same as their logical (indexed) order. Since we can maintain data in any one order only, there can be only one clustered index per table as against 249 non-clustered indexes.
-
How the blocker processes exist internally in sybase
deepaish
- Aug 16th, 2009
You can execute the stored procedure sp_who , this will give you process id which is blocking what. This is more usefull since sometimes user doesn't have restricted permission for master database.
mikeob
- Jun 17th, 2009
One can look at master.sysprocesses blocked column to look at what is blocking what.
-
Stable Device
What do you mean by Stable Device in Sybase replication?
mikeob
- Jun 17th, 2009
I think the textbook term is 'stable queue' - the place on disk where transacitons/data is stored until it reaches its destination(s). Plays the role of a ledger file in JMS/Tibco.
-
Purge Data
How will you purge data from audit database?
mikeob
- Jun 17th, 2009
To back up sysaudits_0n, set up a threshold which, when triggered, copies its contents into a permanent table and uses sp_configure to set the new active audit table to sysaudits_0(n+1). This will get...
-
Sybase Workspace
How is Workspace used in Sybase?
mikeob
- Jun 17th, 2009
I think it needs clarification. The only 'workspace' that comes to my mind here is a *.ws file from Sybase Power Designer. In that case a workspace serves as a container for physical, logical ERDs and reports, etc.
-
How to check the long running transaction ?
mikeob
- Jun 17th, 2009
In addition to syslogshold one can look at master.sysprocess and the physical_io. If this is large (several hundred thousand) you are probably looking at a query doing a table scan. syslogshold tends to only store teh *longest*.
srihari
- Jul 8th, 2007
Select * from syslogshold
-
What is the difference between sybase 11.X and 12.XWhat is the advantage of UDB over sybase
mikeob
- Jun 17th, 2009
Although there are numerous differences, probably the most relevant was the introduction of data-only (pages, row level) locking for tables in 12.x. That was the biggest one that shook up the Sybase c...
-
How to select a last row in sybase
-
How to find the 2 minimum salaries in a table?
gcvpgeek
- Mar 4th, 2009
The query isselect max(sal) from emp where? sal < (select max(sal) from emp where rownum
silambazhagan
- Jan 2nd, 2009
Top function is only working in sql server, please ignore it.?if you include any clolumn with max() function it will not give proper output.guys, if you want to need minimum 2?salary from emp table ...
Sybase Interview Questions
Ans