How can I manage printers on network, getting their status, ink level, if any printer have any problem then getting problem description,enable/disable printing on specific printer,etc. All these I need to manage programmatically. Regards
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
Where is the problem?
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
Keith Barrow wrote:
I'm not sure if you down-voted Blue_Boy
No really I didn't down-voted, maybe poster of question did it!
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
I didn't gave example to use query which is able to inject, the user used by him/herself, i just gave solution how to manage login case.
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
Try this
private static void selectfromdb() throws SQLException
{
Statement stmt = Connectionstring().createStatement();
ResultSet rs = stmt.executeQuery("SELECT Username,Password FROM LoginDetails where Username='"+tf_Fname+"' AND Password ='"+tf_Lname+"'");
rs.last();
int rowcount = rs.getRow();
if(rowcount ==0){
JOptionPane.showMessageDialog(null,"Login UNSuccessful! ","UNSuccessful",JOptionPane.WARNING\_MESSAGE);
}
else{
JOptionPane.showMessageDialog(null,"Login Successful! ","Success",JOptionPane.WARNING\_MESSAGE);
}
}
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
Can you explain more in details your case?
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
select * from vendor where id in (select top 2 id from vendor order by id desc)
union all
select * from labour where id in (select top 2 id from labour order by id desc)
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
Here it is
create table #tempMonths (monthNr int)
insert into #tempMonths (monthNr) values (1)
insert into #tempMonths (monthNr) values (2)
insert into #tempMonths (monthNr) values (3)
insert into #tempMonths (monthNr) values (4)
insert into #tempMonths (monthNr) values (5)
insert into #tempMonths (monthNr) values (6)
insert into #tempMonths (monthNr) values (7)
insert into #tempMonths (monthNr) values (8)
insert into #tempMonths (monthNr) values (9)
insert into #tempMonths (monthNr) values (10)
insert into #tempMonths (monthNr) values (11)
insert into #tempMonths (monthNr) values (12)
SELECT isnull( YEAR(RequestedDate) ,YEAR(getdate())) as Years,
isnull( Month(RequestedDate),temp.monthNr) as MonthInNumbers,temp.monthNr,
Count(Month(RequestedDate)) as MonthCount
FROM tblMYTABLE
right join #tempMonths temp on temp.monthNr = Month(RequestedDate)
GROUP BY YEAR(RequestedDate),Month(RequestedDate),temp.monthNr
drop table #tempMonths
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
You can try this query
SELECT mt.Field1,
(
SELECT TOP 1 mt2.Field2
FROM myTable mt2
WHERE mt2.Field1 = mt.Field1
ORDER BY
mt2.Amount DESC
) AS Field2,
MAX(mt.Amount)
FROM myTable mt
GROUP BY
mt.Field1
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
select p.* ,e.*,s.*,jh.*
from persons p
inner join Education e on e.PersonID = p.PersonID
inner join Skills s on s.PersonID = p.PersonID
inner join JobHistory jh on jh.PersonID = p.PersonID
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
One of the ways:
select min(dt.[pi]),min(dt.jobid),min(dt.formid),min(dt.shiftid), min(dt.startevent),
(
select top 1 (dt.sw)
from datatable dt
order by dt.endevent
)as sw,
(
select top 1 (dt.sg)
from datatable dt
order by dt.endevent
)as sg,
(
select top 1 (dt.endevent)
from datatable dt
order by dt.endevent desc
) as endevent,
(
select top 1 (dt.eg)
from datatable dt
order by dt.endevent desc
) as eg,
(
select top 1 (dt.ew)
from datatable dt
order by dt.endevent desc
) as ew
from datatable dt
group by dt.[pi],dt.jobid,dt.shiftid
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
use replace as
SELECT REPLACE('Jassim Loves Banana', ' ', ' x');
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
select * from tablename where startdate>=@startDate and enddate<=@endDate
Initialize parameters
@startDate
and
@endDate
with values
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
I guess you have to use SUM and GROUP BY, by the way your question is not enough clear.
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
use union all
select a.Column1,a.Column2 from TableA a
union all
select b.Column1,b.Column2 from TableB b
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
When you declare variable @param, set default value after declared. Do this replace: Old part of query
declare @param nvarchar(1000)= N'update [Common].[Language] set '
New part of query
declare @param nvarchar(1000)
set @param ='update [Common].[Language] set '
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
There exists DISTINCT option to retrieve non-repeated values, but your case was different from using DISTINCT. Glad to help you.
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
here it is
DECLARE @TEST TABLE (X VARCHAR(10),Y VARCHAR(10))
insert into @TEST values ('A','B')
insert into @TEST values ('C','D')
insert into @TEST values ('E','F')
insert into @TEST values ('B','A')
insert into @TEST values ('D','C')
insert into @TEST values ('F','E')
SELECT A.X
,(
select top 1 b.y from @test as b where b.y > a.x and b.x a.x and b.x
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.