Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~5K People Reached
Favorite Tags
Member Avatar for deolalkar_pooja

Hello to all, I have following simple Applet program. import java.applet.*; import java.awt.*; public class myapp1 extends Applet { Label l1, l2, l3, l4; TextField t1; TextArea t2; Checkbox c1,c2,c3,c4,c5,c6; CheckboxGroup cg; Button b; public void init() { l1=new Label("Enter your name: ", Label.RIGHT); t1=new TextField(20); l4= new Label("Enter your …

Member Avatar for deolalkar_pooja
0
249
Member Avatar for deolalkar_pooja

Hi to all, I am having 1.75 GB of RAM on my 32-bit PC. The speed of computer is very slow for first 15-mins. What should I do to increase speed. Please suggest me, I am very new in this thing. Thanks.

Member Avatar for mayaestat
0
281
Member Avatar for deolalkar_pooja

Hi to all, I want to install SQL SERVER 2008 on my XP 32-bit OS. After clicking on "New SQL Server stand-alone installation or add features to an existing " link unser installation tab, Setup Support Rules window shows success status of all rules except "Restart Computer". It neither directly …

Member Avatar for cyberdaemon
0
258
Member Avatar for deolalkar_pooja

Hi.... I am trying to connect sql server with vb.net in Visual Studio 2008 with foll. code.... but it is having problem....what is the problem? Please tell me.... 1. I created "publication" databse. In table i took 2 columns...fname and lname and fill the records... 2. I took DataGridView onto …

Member Avatar for adam_k
0
185
Member Avatar for deolalkar_pooja

I created the following tables and inserted few values. create table books(bookid integer primary key, booktitle varchar(20), year integer, publisherid integer foreign key references publisher(publisherid), price integer, number integer) create table publisher(publisherid integer primary key, publishername varchar(20)) create table author(authorid integer primary key, authorname varchar(20)) create table bookauthor(bookid integer foreign …

Member Avatar for deolalkar_pooja
0
208
Member Avatar for deolalkar_pooja

hi to all, I created following table create table book(id integer, author varchar(20)) In this, each book may have 1 or more authors. My question is that, how can insert more value to author column like as follows. id author 1 pooja merry james 2 robert stephen Thanks & regerds, …

Member Avatar for debasisdas
0
2K
Member Avatar for deolalkar_pooja

Hi to all, I created following table and its view. [blue]create table employee(id integer, name varchar(20), age integer) create view Vemployee as select id, name from employee.[/blue] now I want to rename a view, so I wrote a query like [blue]rename view Vemployee to Pemployee[/blue] But, it shows error about …

Member Avatar for debasisdas
0
76
Member Avatar for deolalkar_pooja

Hi to all, I created the following table --------------------------------- create table publisher(name varchar(20), city varchar(20)) --------------------------------- I want to put following constraint, 'name is having unique with city taken only from 'mumbai', 'pune', 'nasik', 'panji''. I know about unique constraints with name. I searched many about constraint with city, but …

Member Avatar for debasisdas
0
96
Member Avatar for deolalkar_pooja

Hi to all, I create the following table. create table man(id integer, name varchar(20), city varchar(20), age integer) I want the age, maximum age of person. So, I ran following query, select name, max(age) from man group by name; It shows name of all person in ascending order with their …

Member Avatar for jbisono
0
86
Member Avatar for deolalkar_pooja

Hi to all, I have nothing idea about how to create relation and solve their queries. I want to relation as follows: ------------------------------------------------------------------- BookAuthor(book, author, earnings) BookReference(book, referenceBook, times) BookReview(book, reviewer, score) BookPublih(book, year, publisher, price, numbar) In these database, each book may have 1 or more authors & each …

0
73
Member Avatar for deolalkar_pooja

Hi to all, I created the following two table -------------------------------------- create table mail(mid integer primary key, name varchar(20) ) create table phone( pid integer foreign key references mail(email), phone integer) ----------------------------------------- After inserting records on both table, now i want delete perticular record from table say 'delete record of pid=12'. …

Member Avatar for Momerath
0
144
Member Avatar for deolalkar_pooja

Hi to all, I created following table ------------------------------------------------------------------- create table interiors(id integer, name varchar(20), type varchar(20) default 'baby cot', price integer) -------------------------------------------------------------------- but, when i doesn't inserted any value of 'type', by the definition of table, it should take default value. when i fetch all rows by 'select' query, it …

Member Avatar for BitBlt
0
104
Member Avatar for deolalkar_pooja

Hi to all, I created the following table --------------------------------- create table publisher(name varchar(20), city varchar(20)) --------------------------------- I want to put following constraint, 'name is having unique with city taken only from 'mumbai', 'pune', 'nasik', 'panji''. I know about unique constraints with name. I searched many about constraint with city, but …

Member Avatar for smantscheff
0
95
Member Avatar for deolalkar_pooja

Hi to all, I created following table --------------------------------------------------------------------------- create table Interiors(no integer, name varchar, type varchar, dateofstock datetime, price decimal(6,3), discount numeric(6,2)) ----------------------------------------------------------------------------- i want to solve these two queries. 1. Display the type, sum of price and average of discount by grouping type as 'baby cot'. 2. Display the …

Member Avatar for Momerath
0
111
Member Avatar for deolalkar_pooja

Hi to all, i created following table ------------------------------------- create table employee(name varchar(20), dob datetime) ------------------------------------- I want to extract names of all months from 'dob'. for that i wrote following query ------------------------------------- select datepart(month, dob) from employee -------------------------------------- it works and shows all months but in number format, i want …

Member Avatar for Momerath
0
80
Member Avatar for deolalkar_pooja

Hi to all, I created following table --------------------------------------- crate table publisher(name varchar(20), city varchar(20)) --------------------------------------- I want to run following query. [U]'list all the positions of charcter 'a' from name.'[/U] for this, i ran following query, ---------------------------------------- select patindex('%a%', name) from publisher; --------------------------------------- But, it doesn't show proper output. When …

Member Avatar for deolalkar_pooja
0
323
Member Avatar for deolalkar_pooja

Hi to all, i created following table ------------------------------------- create table employee(name varchar(20), dob datetime) ------------------------------------- I want to extract names of all months from 'dob'. for that i wrote following query ------------------------------------- select datepart(month, dob) -------------------------------------- it works and shows all months but in number format, i want to display …

Member Avatar for smantscheff
0
72
Member Avatar for deolalkar_pooja

Hi to all, i created following table in SQL. =================================== create table employee(name varchar(20), dob date) =================================== But, when i ran the query, i got the massage that 'SQL can not find data type 'date''. How should i include 'date' in to table definition.

Member Avatar for d5e5
0
118
Member Avatar for deolalkar_pooja

Hi to all, I created following table =================================================== create table man(id integer, name varchar(20), city varchar(20), age integer, dept integer) =================================================== I want name and maximum age of person residing in 'mumbai'. I wrote following query, but got the error like 'can not include name with max() fuction since it …

Member Avatar for smantscheff
0
135
Member Avatar for deolalkar_pooja

Hi to all, table name: mail email name [email]abc@gmail.com[/email] abc [email]def@rediff.com[/email] def [email]pqr@yahoo.com[/email] PQR [email]xyz@daniweb.com[/email] XYZ ======================================= QUERY: List all email and names in lower letters without any blanks. ======================================== I ran ltrim(), rtrim() and lower() function on data successfully. But fail to retrieve this data. Will you please help …

Member Avatar for debasisdas
0
106
Member Avatar for deolalkar_pooja

//Hi, //i create following table Table name : person ID AGE FNAME LNAME 1 10 Geek Greek 2 20 Seek Bells 3 30 Creek Dells 4 40 Sreek Sells[/B] // I wrote following procedure which is run successfully. Create or replace procedure proc1 as cursor person_cursor (pAge number) is select …

Member Avatar for deolalkar_pooja
0
101