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 strongm 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. geramis

    how to create a linked table in SQL-Server 7.0 ?

    i managed to find the parameters for sp_addlinkedserver with dBase file over the net thanks for the helpful tips (:
  2. geramis

    how to create a linked table in SQL-Server 7.0 ?

    thank's a lot for your advice BUT ... i need to run queries on a remote DBase file (does SQL linked server support an appropriate service provider?) if not - how can i run a distributed query??? i wish to avoid data import. thanks .
  3. geramis

    how to create a linked table in SQL-Server 7.0 ?

    in MS-Access there is an option to create a linked table, so that the table in the local database is only a reference to a table in a foreign database. I wan't to create a table in my local database (SQL-Server 7.0), that is a read-only link to an foreign table in an outside dBase file. How...
  4. geramis

    how to preform multiple conditions select?

    it works although it is syntacticly weird { i would expect rows from tbl1 to be deleted } i think the ORCALE way is clearer, BUT.. thanks a LOT, you've helped !!!
  5. geramis

    how to preform multiple conditions select?

    the 2 SQL statements aren't equivalent: say tbl1 looks like this: fld1 | fld2 ----------- 1 | 2 3 | 4 your sql will delete the record 1,4 from tbl2 while my sql won't !!! i need to delete only matching records (in the above example (1,2) Or (3,4))
  6. geramis

    how to preform multiple conditions select?

    how do i write the following sql in sql-server 7.0?????? (it works in ORACLE) DELETE FROM tbl2 WHERE (fld1,fld2) = ANY (SELECT fld1,fld2 FROM tbl1); [*** i want to delete from tbl2 all the rows with corresponding values in tbl1 ****]
  7. geramis

    SQL Server 7.0 supported Languages

    I'm trying to get a weekday name using: DATENAME(<datapart>,<date>) function. PROBLEM: i want the result in language that is not the default language and not exists in the syslanguages table(for example:arabic,hebrew). Is there any UPDATE with more supported languages OR any way that i can...
  8. geramis

    question about external *.js file

    10'x guys, U've been helpfull
  9. geramis

    question about external *.js file

    i have a javascript file called general.js, which contains general info, for example: var link=&quot;http://serverName/mainDir&quot;; var user=&quot;myUser&quot;; QUESTION: when i link an external .js file into my HTML, for example: <html> <head> <script...
  10. geramis

    validating XSD?

    1) I've written a simple .xsd file. 2) I've writeen an HTML page - embeded inside an XML ISLAND and refered to the .xsd file 3) I've created a table to show the xml and binded all the corresponding fields (Tabular Binding) PROBLEM: NO matter what Content i PUT into the embeded XML Island, IE...
    • geramis
    • Thread
    • Replies: 1
    • Forum: XML
  11. geramis

    what is this query when written as a stored procedure?

    you can try this: UPDATE ADOPT A SET A.BrsID = (SELECT BrsID FROM tblBrsCodes B WHERE B.BrsCode = A.brsno AND B.Road = A.road )
  12. geramis

    sql query where condition

    10'x for everyone, i've solved my problem by sending @param = NULL values for parameters i want to disable from the where codition and using WHERE fldName = IsNull(@param,fldName) in the Condition
  13. geramis

    sql query where condition

    In addition to the ORIGINAL massage i posted: i'm calling a sproc (from ASP) that contains a query of the format i've indicated above and contains a condition of the type: WHERE fldName1 = @param1 AND fldName2 = @param2 ! NOTICE that the condition must be &quot;=&quot; and i was wondering if...
  14. geramis

    sql query where condition

    Is there any KeyWord that i can use in sql-server, that when writing the folloing query: SELECT fldName FROM tblName WHERE fldName = <KeyWord> the result will be all the records? if does - what is the KeyWord?

Part and Inventory Search

Back
Top