Search results for query: *

Hi, I am new to oracle and i am having the following basic doubt. 1.Differnce between Varchar and Varchar2 data types. ( As of my knowledge varchar is deprecated in oracle 9i and memory management is different btw varchar and varchar2.i am not sure about it) 2.Locking Mechanism in Oracle...

Sorry Guys, I made one mistake.This is the correct query. select fld1 as col1 ,fld2 as col2,max(fld3) as col3 , count(fld4) as col4 from table1 group by fld1,fld2,fld4 It gives the result as col1 col2 col3 col4 ------------------------------------------ A B...

Yes.It is looking a safe method.Make it as a MTS Component.Dont use it as a VB Exe. If u use this method,u must create a password decryption component in session_onstart. <SCRIPT LANGUAGE=VBScript RUNAT=Server> Sub Session_OnStart Set objpassdecrypt =...

Hi, I have one requirement. select fld1 as col1 ,fld2 as col2,max(fld3) as col3 , count(*) as col4 from table1 group by fld1,fld2 It gives the result as col1 col2 col3 col4 ------------------------------------------ A B 25 5 A B...

Thanx for this nice tip.I read one article from swynk.com we check the file existing thru sp_MSexists_file which is in master db. Instead of using Extended SP this one is better ,I think. ------------------------------------------------------------ This stored procedure can be used to...

Hi, try this code snippit.it will satisfy ur requirement. set nocount on declare @startdate datetime, @enddate datetime set @startdate = convert(datetime,'03/12/2002') set @enddate = convert(datetime,'06/14/2002') create table #temp( weekdate datetime) while @startdate<=@enddate begin...

If a hacker broke ur NT server, he can view any thing in ur system.After broken the NT Server,u cant do anything to protect viewing Global.asa. But u can encrypt asp and global.asa files using ASPEncrypt Component. Refer : http://www.aspencrypt.com P.Madhana Gopal, Principal Software Engineer...

Add QTY_ORD-QTY_REC field in Group By Clause. Hope now it will run.Try the following query. SELECT PO_HEADER.ORDERNO, PO_HEADER.SUPPREF, PO_DETAIL.NON_STK_RF, PO_DETAIL.PART, Sum(PO_DETAIL.QTY_ORD), Sum(PO_DETAIL.QTY_REC), QTY_ORD-QTY_REC, PO_HEADER.SUPPLIER, SUPPLIER.SUP_NAME, PART.DESCR...

It is from http://vyaskn.tripod.com/administration_faq.htm#top I think it may be useful to u. If you are running SQL Server 7.0, after renaming the SQL Server machine, the SQL Server service will fail to start, with an error message &quot;Your installation was corrupted or had been tampered...

Hi Terry, your solution is used to acheived my Goal.But is there any possibility to write it in ANSI Standard?B'use Top is SQL Server Specific. P.Madhana Gopal, Principal Software Engineer, LCube Innovative Solns. Pvt. Ltd., India.

In a following Table , Table : order Fields: order Id value i want to find the 'n' th maximum value of order using a single query. Thanx in Advance. P.Madhana Gopal, Principal Software Engineer, LCube Innovative Solns. Pvt. Ltd., India.

Yes.u r correct.

Hi Terry L. Broadbent I think there is no way to choose first entry of each image path.There is a function called Firstof and Lastof in Access.It fullfills the above requirement.There is no equallent function in SQL Server. Select ImagePath, ImageDescription=Min(ImageDescription) From...