T-SQL: Change column type

by Joe Hunter 18. May 2011 19:36

ALTER TABLE MAIN
ALTER COLUMN [natFileID] NVARCHAR(30) NULL

T-SQL: Add column to a table with default valueUseful feature to add column to a table with a default value: Normal 0 false false false ...Using T-SQL to get comma separated list of all columns in a tableDECLARE @listOfColumns VARCHAR(MAX) SET @listOfColumns = ( SELECT TOP 1 STUFF( (SELECT ', ...Jet SQL Data TypesTable of the 13 primary data types in JET SQL: http://office.microsoft.com/en-us/access-help/sql-da...