Comments by adilmemon

adilmemon 14-Jul-12 12:16pm View

i want take input in pl/sql block which is in sql server 2005

declare
x number;
begin
x := &enter_value;
select * from employee where sal=x;
end;

thats how i am taking input in oracle 10g

adilmemon 14-Jul-12 11:57am View

i want take input variable value from user
how can i take just like i am taking in oracle 10g pl/sql

adilmemon 13-Jul-12 15:48pm View

after declaring variable
can we take variable value from user in sql server 2005 or not
DECLARE @input int
begin
select * from employee where salary>=input
end

that is taking value for input variable

adilmemon 13-Jul-12 15:42pm View

no i want it input in pl/sql statement

adilmemon 13-Jul-12 15:32pm View

ya i want to take input from user
but in pl/sql first declare the variable
then take the input
e.g.
DECLARE @input int
begin
select * from employee where salary>=input
end
like that

adilmemon 13-Jul-12 15:20pm View

means if i have query like
select * from employee where salary>=input
input variable value should be taken from user

adilmemon 25-Oct-11 11:22am View

can anybody solve this problem

adilmemon 16-Oct-11 12:40pm View

it is not working same problem all files are uploaded except pdf

adilmemon 17-Jun-11 13:12pm View

thanx but you have tried in oragle10g or in the other version

adilmemon 14-Jun-11 13:50pm View

please someone give me answer first i need it very urgently

adilmemon 14-Jun-11 11:57am View

thanx sir
but ya it is on
i am using oracle 10g
n when i am not taking input inittialize then display it is working

and i am getting this eror when i run this

ORA-06550: line 4, column 6:
PLS-00103: Encountered the symbol "&" when expecting one of the following:

( - + case mod new not null
avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date

pipe

2. x number;
3. begin
4. x := &enter_value;
5. dbms_output.put_line(x*2);
6. end;

adilmemon 13-May-11 6:11am View

but when i format in mm/dd/yyyy i got same error

adilmemon 13-May-11 6:09am View

how to convert say me
n i want time as 0:00
as i need to work with date only when i retrive

adilmemon 13-May-11 6:07am View

sorry sir but i wrote in caps the important thing

adilmemon 12-May-11 12:59pm View

thanx a lot u r a true programmer yaar

adilmemon 2-May-11 10:51am View

thanx i want bcoz i generate reports on based on that

adilmemon 1-May-11 12:52pm View

IF I WANT TIME TO BE 0:00 THEN

adilmemon 1-May-11 7:41am View

in sqlserver 2005 there is no date datatype there is datetime only i have modify the question so check it out n give the solution thanx..

adilmemon 29-Apr-11 11:02am View

how to store only date instead of date with time in sql server 2005 with 2008
plz help i am short on time quick

adilmemon 28-Apr-11 12:38pm View

through this only in asp.net date will be ready but how to store it in sqlserver 2005

adilmemon 28-Apr-11 12:37pm View

Deleted

in sqlserver2005 there is no date datatype so through asp.net i want to store data only in sqlsever2005 in that date column

adilmemon 18-Apr-11 11:29am View

@GRIFF
BUT BOTH ARE SCRIPTING LANGUAGE NA
N IF U DONT KNOW THE ANSWER DONT COMMENT

adilmemon 25-Mar-11 14:56pm View

thanx a lot
after setting break point i got that role has value Admin but wid spaces as
so i use trim(role)
and i got it thanx thanx thanx
thanx a lot

adilmemon 25-Mar-11 14:08pm View

i have checked wid response.write(role) command it has value as Admin only but it is not redirecting

adilmemon 25-Mar-11 14:06pm View

ya but it is also not working
i am not understanding yaar
do you know how to compare the value of reader wid string variable my problem is there only all thing is work properly
thanx for ur suggession but it is giving me same answer

adilmemon 25-Mar-11 6:53am View

AREY IT IS RUNNING NO ERRORS IN IT
OK BUT AFTER READING VALUE OF ROLE IN VARIABLE ROLE
IT IS NOT REDIRECTING AND AT THAT ALSO IT IS NOT SHOWING ERROR BUT IT IS NOT REDIRECTING PAGE
AND WHEN I WRITE VALUE OF ROLE BY USING
RESPONSE.WRITE(ROLE)
IT IS SHOWING ON PAGE ADMIN
BUT IT IS NOT REDIRECT THAT PAGE

adilmemon 24-Mar-11 15:09pm View

after reader reads data it should redirect the page if role = "admin" but it is not redirecting
it is my issue

Comments by adilmemon (Top 27 by date)