Can I use truncate command with a where clause? I need to remove specific rows from several tables.
How can I delete specific data from the entire database?
SELECT DimEmployee.[FirstName], DimEmployee.[LastName], [SalesOrderNumber], [ShipDateKey] FROM DimEmployee JOIN [FactResellerSales] ON DimEmployee.[EmployeeKey] = [FactResellerSales].[ProductKey] WHERE DimEmployee.[FirstName] like 'kevin%' <--have to truncate this specific name from entire DB
Is there any other method to remove a specific data from entire DB?
In my database there are 172 tables. I wanted to delete a specific name and its corresponding columns from the entire database. The name is spread across entire database, hence I want to remove it in a single shot instead of going to each table and deleting it individually.