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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sybdba

  1. sybdba

    Last Character of A Field

    If your table is having char data type, then it may not return what you are expecting. Probably, you need to convert your data type to varchar and then use right function to get desired result. Following sql statement may help.... select right(convert(varchar(17),col_name),1) from...
  2. sybdba

    Table fragmentation

    There is a table sysdistrib which store the tabid & date for the statistics updated tables. Following query may be useful on user database. select a.tabname, b.constructed from systables a, sysdistrib b where a.tabid=b.tabid group by 1,2 -OR- run simple sql statment without group by clause...
  3. sybdba

    SQL delete using multiple "where" columns

    Hi ralc, try this... delete from t1 where f1 in ( select f1 from t2 where t1.f1=t2.f1 and t1.f2=t2.f2 ) I hope that this will useful. Regards, Rajdeep
  4. sybdba

    SQLSTATE (sqlmessage????)

    Hi, Most of the error messages gets recorded into log files. I am not sure about your error but you can try to look into it. The error log files looks like SERVERNAME.log. You can see this file into install directory. I hope that this will give some sort help for locating error. Rajdeep
See more

Part and Inventory Search

Back
Top