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 |
|
JPOULOS
Starting Member
1 Post |
 Posted - 2009-06-17 : 17:45:47
|
| Hello,I am new to SQL and am trying to figure out how to execute the following commands in SQL: 1. Deleting all Blank Rows in a selected table 2. Deleting all Blank Columns in a selected table 3. Perform these commands for multiple tablesHere's the background. I'm getting about 12 tables in Access that need to be cleaned up. Some of the tables can be combined, and I've written a simple code to combine these. I need to perform the above-mentioned commands on the 'combined' tables and the others that weren't combined.Any ideas how to perform this in SQL?Thanks in advance!KCCASEY POULOS |
|
|
malaytech2008
Yak Posting Veteran
95 Posts |
Posted - 2009-06-18 : 06:01:43
|
| why do creata table in that way?Malay |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-18 : 06:23:08
|
quote:
I've written a simple code to combine these (tables)
Is not clear - is it a view?You cannot start a delete statement to delete rows in more than one table.quote:
Deleting all Blank Columns in a selected table
Is not clear.What is the meaning of this? DROP Columns?quote:
about 12 tables in Access
Maybe this is a topic for Access forum?GreetingsWebfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Deleting Columns & Rows for Multiple Tables