SQL
-
update command for interchanging to field values ex. f_name L_name -------------------------- a b c d by mistake f_name went to l_name and vise varsa:)
Hi, Why don't u try with cursors...... e.g DECLARE authors CURSOR FOR SELECT au_id, f_name, l_name FROM authors OPEN authors FETCH NEXT FROM authors INTO @au_id, @au_fname, @au_lname WHILE @@FETCH_STATUS = 0 BEGIN Update author_master SET f_name = @au_lname, l_name = @au_fname WHERE au_id = @au_id FETCH NEXT FROM authors_cursor INTO @au_id, @au_fname, @au_lname END CLOSE authors DEALLOCATE authors GO I hope this will help u.... Regards, Ritesh
-
update command for interchanging to field values ex. f_name L_name -------------------------- a b c d by mistake f_name went to l_name and vise varsa:)
-
update command for interchanging to field values ex. f_name L_name -------------------------- a b c d by mistake f_name went to l_name and vise varsa:)
Simply run the update command. Below is a sample. CREATE TABLE dbo.ctm ( id numeric(18,0) IDENTITY, col1 varchar(20) NULL, col2 varchar(20) NULL ) go INSERT INTO dbo.ctm ( col1, col2 ) VALUES ( 'aa', 'bb' ) INSERT INTO dbo.ctm ( col1, col2 ) VALUES ( 'cc', 'dd' ) SELECT T.id, T.col1, T.col2 FROM dbo.ctm T update ctm set col1 = col2, col2 = col1 SELECT T.id, T.col1, T.col2 FROM dbo.ctm T