samblag

 Profile Answers by samblag Questions by samblag

• Aug 4th, 2010

Look and learnSelect exp(Sum(log())) from

samala_naresh

 Profile Answers by samala_naresh Questions by samala_naresh

• Aug 7th, 2008

Declare @var intselect @var = 1update set @var = @var*< colname >select @var

Answer Question  Select Best Answer

What are the default size of master database in sybase ?

ravi.marennavar

 Profile Answers by ravi.marennavar Questions by 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

 Profile Answers by Satsun Questions by Satsun

• Apr 24th, 2009

The default size of a master database in sybase is 6MB for a 2K page size Adaptive server.

Answer Question  Select Best Answer

How to avoid Data changes while retrieving data?

vinay bhatt

• Sep 8th, 2015

Use pulllock datatype

Satyashth Anand

• Jun 17th, 2014

Use holdlock option

Answer Question  Select Best Answer

What is the maximum nesting level of Stored Procedure and Triggers in Sybase?

neo.sql

 Profile Answers by neo.sql Questions by neo.sql

• Sep 10th, 2011

The default option for maximum nesting level is 16 however this is a server configurable value and can be lesser than this also. To check the current maximum nesting level for stored procedures and tr...

Tejas More

 Profile Answers by Tejas More Questions by Tejas More

• Jul 7th, 2011

Max nesting level is 16

Answer Question  Select Best Answer

ssukralia

 Profile Answers by ssukralia Questions by ssukralia

• Dec 3rd, 2007

Shutdown with wait - wait from other processes to be completed and then shutdown happens.if "shutdown with nowait" - is used then SQL Server immediately shutdown and back to OS promptHope this will help

Shubh

• Oct 23rd, 2007

Ctrl+D works as well...

Answer Question  Select Best Answer

efficasy

 Profile Answers by efficasy Questions by efficasy

• Mar 8th, 2009

Set rowcount 1Select col_name from table_name order by col_name desc

gcvpgeek

 Profile Answers by gcvpgeek Questions by gcvpgeek

• Mar 4th, 2009

Use the below queryselect * from table1 minus select * from table1 where rownum < (select count(1) from table1)

Answer Question  Select Best Answer

How will you take database backup when there is no space in file system?

ericpro

• Nov 21st, 2014

You can also try using remote backup so you can dump to another server with available space. of course you have to configure the interfaces between the servers to allow this.

luisgranados

 Profile Answers by luisgranados Questions by luisgranados

• May 20th, 2011

I would dump the database to a removable storage device.

Answer Question  Select Best Answer

chrisjej

 Profile Answers by chrisjej Questions by chrisjej

• Jun 23rd, 2010

select count(*) does not need to fetch all column data - which you can see whenever the showplan chooses to perform the query using an index.I doubt there is a difference - and when I just tried to be...

gcvpgeek

 Profile Answers by gcvpgeek Questions by gcvpgeek

• Jun 23rd, 2009

Count(1) is faster than count(*)

Answer Question  Select Best Answer

nishusingh84

 Profile Answers by nishusingh84 Questions by 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%"

nbeeram

 Profile Answers by nbeeram Questions by nbeeram

• Apr 16th, 2009

By joining the system tables - syscolumns and sysobjects on the id column

Answer Question  Select Best Answer

GANAPATHI MASILAMANI

• Jul 3rd, 2016

No. You cant, add column will be added in the end

SANTOSH TRIPATHI

• Apr 28th, 2014

No you cannot , take the backup of your data redesign the table as per your need restore the data using default values or making the column NULL that you have added

Answer Question  Select Best Answer

Ravindra Seelam

• Dec 21st, 2016

AutoSys is an automated job control system for scheduling, monitoring, and reporting. These jobs can reside on any AutoSys-configured machine that is attached to a network. Converting cron to JIL (UN...

Vikas K Gupta

• May 24th, 2014

Autosys is a job scheduling, monitoring as well as reporting tool. We can schedule jobs in autosys using jil code based on time and event, We can also monitor those jobs. The advantage of using Autos...

Answer Question  Select Best Answer

krishna kanth

 Profile Answers by krishna kanth Questions by krishna kanth

• Apr 14th, 2011

Set rowcount 1delete from mytable where (select count(*) from Mytable group by col1 having count(*)>1)>1while(@@rowcount0) delete from mytable  where (select count(*) from Mytable group by col1 having count(*)>1)>1set rowcount 0go 

gcvpgeek

 Profile Answers by gcvpgeek Questions by gcvpgeek

• Mar 3rd, 2009

We can do remove the duplicate records using the below single queryDelete from table1 where rowid not in (select max(rowid) from table1 group by dup_col)

Answer Question  Select Best Answer

suresh1_saxena

 Profile Answers by suresh1_saxena Questions by suresh1_saxena

• Aug 6th, 2010

The query for this question can be written by using the outer join.select?* from employee a,department b where a.emp_id*=b.emp_id

kevinkpatel99

 Profile Answers by kevinkpatel99 Questions by kevinkpatel99

• Feb 21st, 2010

ANSI Syntax:SELECT Emp.ENAME, Dept.ENAMEFROM Employee Emp left join Department DeptON Emp.DEPTNO = Dept.DEPTNOTransact-SQL Syntax:SELECT Emp.ENAME, Dept.ENAMEFROM Employee Emp, Department DeptWHERE Em...

Answer Question  Select Best Answer

gcvpgeek

 Profile Answers by gcvpgeek Questions by gcvpgeek

• Mar 4th, 2009

The query isselect max(sal) from emp where? sal < (select max(sal) from emp where rownum

silambazhagan

 Profile Answers by silambazhagan Questions by 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 ...

Answer Question  Select Best Answer