Search results for query: *

what function do i use to convert number to a string in a query?

The data files are seperate files with OSS extension. e.g. records.OSS Is there a way to extract data from them into a text file?

Thanks for your time to answer the question. I am looking to merge two database with the same data structure and tables but different data into one database. i.e. I have two databases and wish to get rid of the two and go down to one.

is there a way to extract data from these paradox files into text format?

I need to export data from files with DB extension. I was told the program was written in Delphi. Is there a way to find what program *.DB files are associated and potentially export data into text file?

isn't there any utility that would give me those passwords?

Is there a way to extract the records from a filemaker 5.5v1 Run (08/23/2001) application? The files are password protected and I dont have the password! I need to extract the data into text or csv file. Thanks for your valuable input.

I have two SQL Server DBs running. Is there a way to merge the two into one? If yes, how is concurrency handled?

I Have a cleint-server application using MSDE. The database server is installed as named instance on Windows XP machine. However, the Windows XP firewall prevents it from being accessed by client computers. Is there a workaround to be able to connect to MSDE Server without disabling the Windows...

i have two different queries that return different columns except one. I need to combine the results from two queries into one row identified by common column. e.g. query 1 returns: date charges 1/1/05 2000 query 2 returns: date cash payment check payment 1/1/05 1000...

i need to display row data as columns: Un DB it is stored as : Cash 100 Check 200 Credit Card 300 Other 400 Cash 500 Check 600 I need to display it as: Cash Check Credit Card Other 600 800 300 400...

i found this on one of the websites: how do i find what this means? sqlservr -c -s instancename in "binn" folder

I need to do this for Windows 98 installation using MSDE.

Is there a way to set the "Auto-Start service when OS starts" property to True (checked) using the Command prompt? ..similiar to net start mssql$instance_name

I am trying to create a process to schedule automatic backups. We are using MSDE 2000 so I was thinking of creating a batch file that will accept filename as argument and will be attached to windows scheduler to run at scheduled interval. Is there a better way of scheduling backup?

or a way to get a forced exclusive lock on the DB using Transact-SQL

is there a way to terminate all connections using transact-sql (before performing restore opertaion)

how do i update the time portion of date column to be null in a update statement? e.g. before 12/09/2004 23:20:06:357 after the update should be 12/09/2004 00:00:00

What if someone else uses the same database and changes data as well? This will not happen (and even if it happens they are willing to live with the data loss) I am talking a one man operation. My other question was if it is possible to take back from one and restore into another server using...

No, It is the end-user taking home the database to work with. At a given point-in time they will only be working on one server either home or office and then move the changes from one to another. Can you restore the backup from one server to another?