-
Table Locks
how to lock a table in sybase? give me its text command.
samala_naresh
- Aug 7th, 2008
lock table table_name in {share | exclusive} mode [wait [no_of_seconds] | nowait]
-
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
-
What is a bind cache?
samala_naresh
- Aug 13th, 2008
When you install Adaptive Server, it has single default data cache, with a 2K memory pool, one cache partition and a single spinlock. To improve performance you can add data caches and bind databases...
