Search results for query: *

Hi change the script as follows CREATE TABLE EnhAudit (ProjectNo CHAR(8), CreatedDate DATETIME, FieldName CHAR(35), OldValue CHAR(35) null, NEWValue CHAR(35), CreatedBy CHAR(40)) Gopal2 :-)

Hi, Change your table creation script as follows CREATE TABLE EnhAudit (ProjectNo CHAR(8), CreatedDate DATETIME, FieldName CHAR(35), OldValue CHAR(35) null, NEWValue CHAR(35), CreatedBy CHAR(40)) Regards Gopal :-)

Hi You try with the following query SELECT name1, name2 FROM customers WHERE charindex("SALLY",name1+" "+name2)!=0 I think it will sreve your purpose Gopal :-)

Hi Yes there is a way to make it work we have dynamic SQL feature provided by sybase what you have to do is, assign the whole select statement to a string variable say @exe_str select @exe_str ="Select * From "+@TblNme Then use this command to execute the statement in @exe_str...

Hi, If there is any primary key for the temporary table, specify it. like this create table #tempTrans ( RecId integer not null primary key, SeqNo smallint not null, CustAmount numeric(18,5) null, CustQuantity numeric(18,5) null ) while using cursors it is suggested to delcare primary key...

Hi What I do to debug stored procedure is to run each individual statement/block seperate in editor and see the results for each run. Once the statement/block is executed then process on to next statement/block in the sp definetly we will find where exatly we are going out of the box with the...

Hi We have substring(expression/string,start,length) function in sybase to do the same