you can use simple syntax for adding a column in the table. for this the schema need to be modified i.e. alteration of table is required.
check out the syntax.
ALTER TABLE table_name
ADD column_name datatype
Other way to modify the table is to open it in SSMS in design mode.
check out the syntax.
ALTER TABLE table_name
ADD column_name datatype
Other way to modify the table is to open it in SSMS in design mode.
Simple yet informative. Looking forward to more of such posts.
ReplyDeleteI have a suggestion: Please upload some training videos for T-SQL, SSRS, SSIS