Search results for query: *

I have these files: AnotherHello.class AnotherHello.html AnotherHello.java Applet Code: import java.applet.Applet; import java.awt.*; public class AnotherHello extends Applet { public void paint ( Graphics gr ) { setBackground( Color.lightGray ); gr.drawString("Hello&quot...

I need help in generating random numbers using JAVA. I need to generate at least three sets of numbers (not duplicated). The set range should be between integers 1 to 55. I need some code to start with as I'm new in this Java programming arena. The output is simply using System.out.print...

Table Properties - Odors OdorID Int OdorNum Int Odor nvarchar(50) Here's my Cursor: DECLARE OdorCursor Cursor FOR SELECT * FROM Odors; DECLARE @TheCursor Cursor; SET @TheCursor=OdorCursor; OPEN @TheCursor; DECLARE @OdorID Int; DECLARE @OdorNum Int; DECLARE @Odor nvarchar(50); FETCH...

I need help in developing an updatable cursor that updates and deletes rows from a table/s. I only like to deal with Oil.OilName and Cautions.Description. I have the tables below: OIL table: OilID int OilName nvarchar(50) LatinName nvarchar(50) PlantTypeID int PlantPartID int CAUTIONS table...

I would like to display each oil (the oilID and oilName) and the property (propertyID and propertyName) with the highest propertyID associated with it. I want the results by the oilID. The highest propertyID or number means it's more associated with an oil compared to a property with a lower...

I need help on how to provide an INSERT statement to activate a trigger given the tables below: MYOILS Table OilID - PK, int OilName - nvarchar LatinName - nvarchar, allow nulls PlantTypeID - int, allow nulls PlantPartID - int, allow nulls Sample - char, allow nulls Description - varchar, allow...

Can you please give me some tips to... create an SQL script that implements three functions: MonthsUntil, DaysUntil, and HoursUntil. wherein I can input date value then the functions will return the number of months until the date, days until the date, or hours until the date as appropriate.

It's my first time to create sprocs. I need a mentor. Please help! If you have read the book 'Beginning MS SQL Server 2000 Programming by Riordon', then you must know about the Aromatherapy database. My question is... How can I write a sproc that would allow me to add a caution for an oil...