Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
algosdoc
Starting Member
1 Post |
 Posted - 2012-07-05 : 17:40:38
|
| Neophyte at SQL: Have a database that is growing geometrically in size due to the fact the way our program is set up inputting the data. The new cells (new date of service) has all the new data plus does not overwrite the old data, all of which is now saved in the new cell. This creates a large amount of redundant data. Question: Can I go into edit SQL and simply delete the unwanted datacells? Is there a program that can help me do this? Will doing this screw up access to the undeleted cells? ThanksDavid Adams |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-07-05 : 20:04:42
|
| You can "edit" data via the SQL client tools. I use SQL Server Management Studio. It does have a GUI for edits, however it is best to write your commands. For deletes, you would use the DELETE command.I'm not sure what you mean by a cell though. If it's like a cell in Excel, then you would be updating a row and not deleting it. Whether or not it'll screw up things, I have no idea. That's something you would need to discuss with the person who wrote the application.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
SQL Server 2005 Editing