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 Mike Lewis 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. PeaceMaker

    SQL Processor usage

    Nine Ways to Optimize SQL Server 6.5 Queries What a difference an index can make! I received that reminder recently when I added an index and changed a query's runtime from 40 minutes to 12 seconds. Indexing, however, is only one tool in a DBA's performance-tuning toolkit. You can get better...
  2. PeaceMaker

    Data Import/Export

    Hi You can do import export using c or any other language,, using text files... Its very simple using BCP You can create Text files using BCP like this from SP u can use XP_CMDSHELL and bcp ajaydb..ltt_emp out c:\ltt_emp.txt -c -Usa -Psa - SmyServer same way you can import... bcp...
  3. PeaceMaker

    How do I use EXISTS with a Dynamic Table Name in a STORED PROCEDURE

    I am using this way... And 100% it works I have to take dynamic names too cos i was using BCP from SP and i need to access these simultaneously on multiuser environment So here is the CODE select @xLtt_Log = '##'+@zLaptop_Name+@zEmployee_id+'_Ltt_Log' select @xCtr = 0 select @xCtr =...
  4. PeaceMaker

    Delphi / SQL Locking Up Problems

    yes FUZZI is right. TTable is the Devil for all the Locks...:) and also try avoiding the statement Select * from myTable .... still If u want to select all the records then dont use *... put each field name one by one... I have a known prob with delphi which i have experienced.. when u have...
  5. PeaceMaker

    Delphi / SQL Locking Up Problems

    Might be helpfull for you... Delphi uses BDE for transactions with SQL Server. So BDE is the main cause for locks... BDE puts table level exclusive locks in SQL Server... so when your applications locks up then CHECK that is there any lock at the back end... The other thing is that your BDE...
  6. PeaceMaker

    How to handle Errors in a Stored Procedure in SQL Server 6.5

    I have written a stored procedure which consists of 3000 or more lines.... Now it is in transaction... i want to rollback if any of my sql statement fails during the processing.. I want to commit only when my Stored procedure is complete I am using @@Error variable to find out whether the...
  7. PeaceMaker

    Varying # of parameters sent to stored procedure

    yes, thats greate, i actually implement this in my SQL SERver 6.5 stored procedure... create procedure usp_tst ( @strpartnum varchar(10), @sn1 int = null, -- optional, defaults to null @sn2 int = null, -- optional, defaults to null -- ... and so on ) the other thing you would do is...

Part and Inventory Search

Back
Top