Search results for query: *

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

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?

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...

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?

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

I have an application that uses MSDE 2000. The user needs to be able to move the database to another computer to take home and work on it and then later put it back to the original computer. Both computers have their own MSDE 2000 running. What are the steps to move/copy the database from one...

is there a away to stop the SQL SERVER as a batch process (under scheduled task) and to restart it.

I have a client-server application that uses MS SQL Server Desktop Engine named instance. Now I want to use a third party to host my SQL Server DB over the internet. How do I configure my client machine to access this remote SQL Server DB through internet?

i need to update the date portion (of datetime column) equal to date portion (of datetime column) of another column in the same table. How can i do that using SQL?

how do i convert string to a date? what is the sql function and its arguments?

I need to restore db to a server other than the one from which the backup file was made. both the server have identical db, users, security etc. The only different thing. I would like to get the data from the other server DB to this server DB. PLEASE HELP So here is what I did: ALTER DATABASE...

How do I truncate the transaction log file to reduce its size...it has become too big!

what is the SQL function to convert column value to upper or lower case? select upper(name) from table should return names in upper case??

how do you restrict select resultset to return only one row?