Comments by v03051435 (Top 27 by date)

seriously sir = =!

thanx for ur reply and i voted, but i found a better answer too for u :

http://stackoverflow.com/questions/354070/sql-join-where-clause-vs-on-clause

that's what i mean :)

thanks Abhinav, i have another question, what's the diff between :
select t1.name,t2.name,t3.name
from t1
left join t2 on t1.id=t2.id
(and/where) t2.name='aa'
i noticed that "and or where" make different result, so what's the difference? thank you

hi,Goel, thanks for ur reply, if i wanna use short hand and left join in the same time, how to achieve? like "Where a.col1 *= b.col1"? and there is no influence of matenance between "short hand" and "writing left join each time" method? thanks for ur reply.

thank you very much!!

i found that, just get the actuel edit row index, if index<= i (i is rows dont want to be validated), then i make args.IsValid=true; if acutel edited index>i, then args.IsValid=false

@Soumitra, thank you for ur response, yeah, the 1st issue sovled by using left join:
select s.Id,e.Name,COALESCE(s.salary, 0) AS salary,s.employeeId,s.dateId
from employee e
left join salary s on s.employeeId = e.id,

and then i can insert update using query as i like :D

i am new to sql, i kown what u mean, i can use employee left join salary, so i can always have all the actual employee in my selected table. but if i add a new employee, how can i insert his salary if i just use left join to show his name

my query is :

<pre lang="sql">declare @DateValue int
set @DateValue=201310
if not exists (select e.*,s.* from employee e,Salary s where s.dateid=@DateValue)
insert into salary (Name,SalaryA,SalaryB,EmployeeId,DateId) (select Name,0,0,Id,@DateValue from Employee)</pre>

1.when i choose a month, it will insert all empolyee names and salary value 0 into salary table. 2, i can modify their salaries in salary table 3. when i add a new employee "Tom" in employee table and then select salary table, i want to see ancient employee with their salaries and Tom with salary 0

employee table is just an template, the 1st time when i choose a month 201310(e.g) in my site, salary table will show all the employee name with salary value 0, then i modify value to 1000 for example, and i add a new employee Tom e.g, and when i choose month 201310, salary table will show me ancient employee with their salary i modified and Tom with salary 0, that's what i want, but my query doesnt work

@thatraja, i dont understand which place should be modified, in my oracle, statement works well, but in my calling of stored precedure, dont work...

??

u mean that if i move all the dll from the 2nd Bin folder to the 1st bin folder, and i can delete the 2nd bin folder?

thanks for ur reply. but i still wonder that : in my project's classlibrary, the path of oracle.dll is "D:\app\Y8485185\product\11.2.0\client_1\ASP.NET\bin\2.x\Oracle.Web.dll", seems not from the GAC(c:\windows\assemblies).. so if in my server, my oracle.dll in in the path F:\\exemple(not same with my local pc), all though in my server's gac(c:\windows\assemblies) there are oracle.dll, how can it be loaded to my published project, i mean how my project can find the oracle.dll's path? thank you

i used masterpage..and crystal of version 10.XXX works well, but version 13.XXXX doent work... i dont have any other solution, but at least one solution works well that's not bad :D

i dont understand..

i just modified little piece of codes in aspx and classlibrary files, so how can i do to just copy and paste the server's existe files? the aspx i can copy paste, but bin..how should i do ?