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) ?
Latest Answer: In pre sybase 15 all database options will take effect after a use database and checkpoint command is run.For Sybase 15 the option take effect immediately since all sp_dboption commands have an automatic checkpoint. ...
Latest Answer: 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 ...
Latest Answer: shami,Can u elaborate more, in terms of 2 tables A and B if we do a right outer join, how can we use coalesce ...
Latest Answer: 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*. ...
Latest Answer: There are only two options to clear the log1) Kill the tran which is filling up the log2) Extend the transaction log to complete the transaction.don't use 'dump with truncate_only' if you have tran dump job setup. I would also stop and restart ...
Latest Answer: The numeric and decimal typesare identical in all respects but one: Only numeric types with a scale of 0can be used for the IDENTITY column. ...
Latest Answer: usage: dataserver
valid options are:
-a caps_file - path to CAPs directive file
-b [size_spec] - master device size specifier
-c config_file - config file for server
-D [size_spec] - default database size specifier
-d master_dev - master device ...
Latest Answer: Partition is a old technology helps to access data faster (not actually faster) in almost all the databases. Sybase ASE 15.0 opens up a new possiblity of this. Sybase ASE contains semantic Partioning which is not available in Oracle latest version called ...
Why can a user create 249 non clustered indexes over a given table as against only one clustered index over a table?
View page << Previous 1 2 [3] 4 5 6 7 Next >>
Go Top
