Tip Bank

Question: What is the data type for time? Example: 8:45 am Answer: What you really have is the tail end of a datetime data type. You can get it back

Question: I have three databases in SQL Server 6.5. All have the same structure of tables and stored procedures, but whenever I change stored procedures in one I must do

Question: Is there any way to change the ownership of files and directories with scripts or programs? Answer: You can use the SubInAcl.exe file (included in the NT 4.0 Resource

Question: Is there a way, using Visual FoxPro, to determine the maximum number of characters (not spaces) in a field? I am working with a table that has over 3

Question: I have been asked to develop a database of imagery from a company’s slide collection that needs to be incorporated into a Web site. Does SQL support binary files?

Question: I’m equally comfortable using both VB and FoxPro. Each product has its pros and cons. I think VB has a better developed IDE and debugging facilities. FoxPro, on the

Question: I need to pass large fields of text. Problem is, some of the text has single quotes in it ( ‘ ). How do I pass these text fields

Question: I am writing an application that needs to be able to shut down any NT workstation or server remotely. Do you have any ideas on how to do this

Question: My company has been using R:BASE in the past and we recently upgraded our network and installed SQL. How can I migrate my old R:BASE data into SQL? I