clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591614 fiddles created (45711 in the last week).

CREATE TABLE foo ( a int ); INSERT INTO foo VALUES (1),(2),(3);
3 rows affected
 hidden batch(es)


ALTER TABLE foo ADD b varchar; UPDATE foo SET b = CAST( a AS varchar ); ALTER TABLE foo DROP COLUMN a;
Msg 207 Level 16 State 1 Line 2 Invalid column name 'b'.
 hidden batch(es)


SELECT * FROM foo;
a
1
2
3
 hidden batch(es)