Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
convert text containg ( '.' ' -' )
I have two parts tables and am attempting to set a value in table A where the parts# match. The part#'s can contain either a "." or a "-". When I try to create an update query, I get the following error,"The expression that you entered has an invalid data value"...- reden55
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Space crunch - need to move data folder
Hello, Whoever set up my database (SQL 7) put it on a small partition (c:\ 4gig - ~300mb left) while having a 13 gig d:\ drive available. I need to move the data directory, how do I accomplish this? I'm not in a 7x24 business environment, so I can shut it down after business hours. Thank...- reden55
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Rollback an Update statement
Hello, I have two questions that are related 1.) How does SQL7 manage "rollbacks" 2.) What SQL code do I use to "rollback" a sql transaction that goes awry? In my test environment, I have run the following script to test moving contacts from companies that will be deleted...- reden55
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
