Jump to content

syedhameed

Members
 View Profile  See their activity

  • Posts

    8

  • Joined

  • Last visited

 Content Type 

Everything posted by syedhameed

  1. syedhameed

    = Uuer Input

    syedhameed replied to user4fun's topic in SQL

    Question is not clear to me though.....in Asp, Asp.netSELECT LastName,FirstName FROM Persons Where LastName = ' " & request("InfoReq") &"'
  2. syedhameed
    You have to change database collation to chinese character. Alternatively search chinese character collation name thru goolge for DB engine(Oracle or SQL) using.....
  3. syedhameed
    It is possibel....UPDATE ibf_dnames_change SET dname_previous = casewhen dname_previous = 'WizarD' then 'WizarD1'when dname_previous = 'coyl' then 'zxcvbnm'end
  4. syedhameed
    Add your window auth. name to that database which you are trying to access as a user. May that user restricted access to that database...
  5. syedhameed
    Hi, You can try this it may help u out...update table_name set col_3= (select sum(col_2) from table_name as a where a.col_1 = table_name.col1)
  6. syedhameed

    Authentication mode

    syedhameed replied to cyrus_'s topic in SQL

    Hi, You can change this authentication mode from SQL enterprise manager ..Tool>Sql server configuration properties > Security...Then you can change this security option....
  7. syedhameed
    Hello, SELECT *FROM mytableWHERE Trim(Left(postcode, 4)) = (" &mypostcodes& ")
  8. syedhameed
    UPDATE A SET A.FIELDNAME = "NEW VALUE" B.FIELDNAME = "NEW VALUE" FROM TABLE1 A, TABLE B WHERE A.ID = B.ID
×
×
  • Create New...