Update whole table fast
Right Click --> Edit top 200 Rows
Select the sides and delete
Copy new data from Excel or other source
Select the Side with * and insert
Check if data is correct with
SELECT * FROM <table_name>
To execute procedures use:
exec <PROCEDURE_NAME> 'PARAM1' 'PARAM2';
To select database table with timestamps use:
Begin
    declare @now datetime2 = sysdatetime();
    print 'Exported all data from TABLENAME table at system time=' + convert(char(20), @now, 121)
    select * from TABLENAME
End
Last updated