Results 1 to 3 of 3

Thread: Are there any SQL Gurus here?

  1. Jun 11th, 2004, 01:54 PM #1
    SeanGrebey
    SeanGrebey is offline

    Thread Starter
    Frenzied Member
    Join Date
    Mar 2004
    Location
    Orlando, FL
    Posts
    1,618

    Are there any SQL Gurus here?

    I'm writing a Window's Service that does alot of updating SQL Server via ADO.NET, and I need to figure out the best way to increment a number field by 1 for all records.
    Sean

    Some days when I think about the next 30 years or so of my life I am going to spend writing code, I happily contemplate stepping off a curb in front of a fast moving bus.
    Reply With Quote Reply With Quote
  2. Jun 11th, 2004, 02:37 PM #2
    Negative0
    Negative0 is offline
    PowerPoster 2.0 Negative0's Avatar
    Join Date
    Jun 2000
    Location
    Southeastern MI
    Posts
    4,367
    VB Code:
    1. UPDATE Table1 Set intNumber=intNumber+1
    Negative 0

    Blog | RegEx | Encrypting UN/PW in Web.Config | Enabling ASP.Net on IIS 6 | Port Numbers | Creating GUIDs | Start->Run | Modifying the default class



    Reply With Quote Reply With Quote
  3. Jun 11th, 2004, 02:44 PM #3
    SeanGrebey
    SeanGrebey is offline

    Thread Starter
    Frenzied Member
    Join Date
    Mar 2004
    Location
    Orlando, FL
    Posts
    1,618
    Sweet, it's that easy? I thought it kind of might be but I wasn't sure and couldn't find an example. Thanks.
    Sean

    Some days when I think about the next 30 years or so of my life I am going to spend writing code, I happily contemplate stepping off a curb in front of a fast moving bus.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width