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 John Tel 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: *

  • Users: 3270
  • Content: Threads
  • Order by date
  1. 3270

    Tranasaction on sql server 2000

    Hi got a problem with some transactions i hope someone kan show me a workaround If got the following sql code begin transaction A DO SOMETHING begin transaction b insert test values ("AAAA") -- Please keep commit transaction b DO SOMETHING MORE rollback transaction a Is there a way...
  2. 3270

    Diffrent performance on diffrent connections

    Hi Im trying to measure the performance on some changes im going to make. So i created a script which calls some stored procedures, in a while loop. When run the script from the query analyzer, a round trip in the while loop takes about 3,5 seconds. I then make 3 other connections, and start...
  3. 3270

    Remove blanks from a string

    Hi whats the easy way to remove blanks from the at string? If i got a string like this 'xxx yyy z zz' and i want it to look like this 'xxxyyyzzz' is there then a simple solution? example thats doesnt work: declare @String varchar(20) select @string = 'xxx yyy z zz' select @string =...
  4. 3270

    Diffrence between sql 6.5 and sql 2000

    Hi I got a bit of problem. Im converting from and old sql 6.5 server to a new sql 2000 server(in 6.5 mode, and withansi defaults off) Ill try to illustrate the problem with the following select create table #test ( test int ) go truncate table #test insert into #test values (1) insert into...

Part and Inventory Search

Back
Top