Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tinkuK

    Accepting NULL values

    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 :-)
  2. tinkuK

    Creating a new table

    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 :-)
  3. tinkuK

    Leading wildcard used with LIKE causing table scan / timeout

    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 :-)
  4. tinkuK

    Assigning variable to a tablename in a St Proc

    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...
  5. tinkuK

    Index on temp table

    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...
  6. tinkuK

    Debugging tips

    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...
  7. tinkuK

    Creating Views

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

Part and Inventory Search

Back
Top