Results 1 to 2 of 2

Thread: updating a select query

  1. 08-19-2003, 05:55 AM #1
    samkud
    samkud is offline Registered User
    Join Date
    Aug 2003
    Posts
    8

    updating a select query

    Can I update a select query using sql server 2000? What I mean is, I want to use a query instead of table or a view.

    eg update (select * from tablename) set field='value'

    something of this sort. I tried doing some r&d but it didn't work. I want it as single query. If some one knows it please let me know. It is very urgent.

    Regards,

    Samir.
    Last edited by samkud; 08-19-2003 at 05:58 AM.
    Reply With Quote Reply With Quote
  2. 08-19-2003, 06:43 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    I dont think so. But why do you want to do that?
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    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