Summary: Quick general question... We have the trial version of SQL 2005 installed and now have the full version ready to be installed. I have read that i just...
Summary: I am still researching the procedure for upgrading my trial version of SQL 2005 to the retail version. If anyone has a good article on the procedure ...
Summary: Hi, I have a quick question regarding unions in SQL 2005 (using express edition for development at the moment). I am setting up somewhat of a stock ma...
Summary: I am not a sql db manager by any means but I've been asked to reset the sa password for a sql 2005 server. My concern is ...will changing this passwor...
Summary: You would be much better off installing SQL Server express from microsoft's web site. It is nearly identical to SQL Server, it just has a limited num...
Summary: Hi people, I have a question about SQL 2005 stored procedures. I have a stored procedure that determins the current price of a stock item and I want t...
Summary: Hello Forgive my poor SQL knowledge. Im looking after an SQL 2005 machine which i inherited. I typically just need to maintain it, however, Im after g...
Summary: I have a sql database that I need to monitor with nagios but it will not work with sql 2005. I was wondering if a sql query that can watch the databas...
Summary: Pl/SQL program in Ora 10g. I need to obtain a list of all the files in the Unix directory /data. Then I will take that list and use it in a DBIMPORT ...
Summary: I have a table which stores a date value. From this value I want to do a select statement which adds 28 days to the value in my table. I understand ...
Summary: I am updating two fields in a sql server DB from a VB6 application. field2 updates fine but field1 is not updating at all. I tried the query in anal...
Summary: I want to attach a database to SQL 2005, but i am restricted as to where the database backup file can be in. I would like it to be in my documents/.....
Summary: I figured this out myself. For reference, the problem was that i had installed sharepoint 2003 on a machine running sql 2005 and it wouldnt go throug...
Summary: Hi, We have just installed visual studio 2008 which includes sql server compact edition 3.5. We want to export an sql server 2000 based database to ne...
Summary: OK i first want to apoligze for posting a message a couple of months ago about the same issue. It's just that i have no idea what i am doing but i wan...
Summary: After installation of SQL Server 2005 Developer Edition, only have Configuration Tools available, I have XP SP3, and I have SQL Server 2000 already in...
Summary: Greetings Maina, I am not a very experienced programmer but I would like to try to help in some way. If you have SQL Server 2008 and Visual Studio 200...
Summary: Can someone tell me why the following is not working? $query = file_get_contents("import_data.sql"); echo ($query); $result=mysql_query($query); ...
Summary: I'm not real good with SQL, but I think the solution would be to join the two tables (inner or outer?) such that every record in tableA would have it'...
Summary: Hi, I am currently working in mainframe.I like to learn SQL.can anyone suggest the best way to get excel in SQL and ORACLE. how the SQL differ from O...
Summary: oh yeah i did the where clause for file xxxx just tryna get one row working first. i'll try this once i have database access again thanks mdow. one th...
Summary: Hi, I'm designin sort of asset manager software and i'm already stuck with some SQL-querys... :) Tables don't have all the fields yet, because it's ju...
Summary: I'm rusty with my SQL, but couldn't you do this?INSERT INTO A(primary_key, Name) SELECT sequence.NEXTVAL, name FROM SELECT DISTINCT name FROM B; ...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
