Search results for query: *

Hi everyone I was checking on this forum about PERFORMANCE and did not find any about this topic. My question is, where do Store Procedures RUN, let's say I have a SQL-SERVER running in one computer and programs in another separate, when I call or execute the STORE PROCEDURE via Query...

Hi, everyone I am trying to get an specific record by its key, if it exists, update it, otherwise add the entry to my data base (MS Access), and I would like to do this using SQL instructions like "select * from mytabe where mytable_key = txtSearchKey". Thanks again for your support...

Hi, everybody I am trying to retrieve a record from my access data base upon user's request to either update the record or add a new record, the scenario should be: the program ask for the code (key) to be retrieved, if it gets it then it shows the fields to be modified, otherwise user enter...

I have a table with several records group by another field, more than 100 records. I need to show in a SELECT only 3 or 5 records per group Like this SOURCE Number Group ------ ----- 1 1 2 1 3 1 4 1 11 2 12 2 13 2 14...

Hi, everyone Thanks for previuos help with BULK insert, it worked for most of my files, but I have this error "Bulk insert data conversion error (overflow)" with couple of my file. What should I do? Thanks again......

Hi everyone: I need to import several flat files to a Microsoft SQL tables, at this moment I am using DTS, but this is kind of slow when you multiply the process for 20 tables, so, I am in need to know how to import these files in a expedite way such with a script. Thanks.