I'm just getting started. I've written some SQL code in MS SQLserver 2000's Query manager. There you type out the code and then hit the 'execute the query' button.
I want to type code into Oracl...
http://www.experts-exchange.com/Database/Oracle/Q_20266632.html
Zones:
OracleDate Answered: 02/16/2002 Grade: A Views: 0
I have two tables with same design
these are the columns
tab1
tab2
id,numof,inttime
I want to pull a report something like this
with data from both the tables
where inttime in tab1 = getd...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20662532.html
Hello,
I have a table with
two columns
one is date_time and other the value
Tabl
Date value
3/14/200412:00:15 75.601962742626981
3/14/200412:00:30 75
3/14/200412:00:45 65
3/1...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20920001.html
I use DTS package to import data from Excel to SQL table.
How can I flag some thing each time a Excel file is imported using DTS .... need to track / check in the table the duplicate records in ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23409035.html
We are having ongoing issues with the performance of one of our applications in relation to a particular function. We found that the stored procedure SP_CONSULTANT_LISTOSREQTS was taking a conside...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23431977.html
Hi
I have a stored procedure that returns many rows as its output. I want to use this SP to populate a second table to record them at a point in time. In this second table I want a unique refer...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23443999.html
I am interested in Using SQL 2000 with a PHP Interface. What are the advantages and disadvantages to this philosophy?
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_20191434.htm...
Zones:
PHPDate Answered: 02/15/2004 Grade: A Views: 0
I have an issue with one of my VB programs. It runs fine on my NT4.0 SQL7.0 machine but doesn't on the Win2000/SQL2000.
Here is the code .... last line shows the error. Suggestion? Wonder if i ...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_20346743.html
Zones:
VB DBDate Answered: 08/31/2002 Grade: A Views: 0
What exists :
A person submits a registration form and an immediate autoresponder is sent as an email to him acknowledging that he has signed up successfull. His username and password is include...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20435547.html
Zones:
DatabasesDate Answered: 12/30/2003 Grade: B Views: 0
Hello,
I hope a SQL Server expert can help me. I've used MS SQL6.5 (as a DBA) and 7 (for web development).
I have an interview tomorrow (and need to know about SQL2000 as well as 7)- can some...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20579972.html