SQL SERVER||A Small SQL Project with 4 Tasks

1. creating new column alter table emp add location varchar(20) 2. update the new column update emp set location=Substring(job_details,charindex('-',job_details)+1,len(job_details)) 3. rename the column name Exec sp_rename 4. to update old column update emp set designation=substring(designation,1,charindex('-',designation))