Tip Bank

DevX - Software Development Resource

Arithmetic functions in SQL

Question: How do you create or access arithmetic functions like INT, MOD, or SQRT for use in Microsoft SQL Server? Answer: SQL Server supports math functions including SQRT, CEIL, FLOOR,

DevX - Software Development Resource

SQL Database setup

Question: I am writing a CGI program to query an SQL database for a client’s information. I will then create a Microsoft Access database from this querry to pass to

DevX - Software Development Resource

Select

Question: I have a table with three columns. The first, an integer type, is the primary key that is automatically increased by one every time a new row is inserted.

DevX - Software Development Resource

Windows 95/NT

Question: How does Windows know the default browser settings? Answer: I can think of two possible answers to the question. If you are asking how IE knows whether or not

DevX - Software Development Resource

Windows NT 4.0 and Oracle Light

Question: Is the following notification error an NT or an Oracle problem? nt.stp(633): permission_denied while copying key softwareoracleoracle_homes How how can I fix it? Answer: This sounds like a NT

DevX - Software Development Resource

Error message

Question: I have two hard drives. I have 95 on C and want to install NT on E. I have 1.99 gig on D and E Free. I would like

DevX - Software Development Resource

NT Server Local Groups

Question: I would like to be able to gain access to NT server local groups for enum, member enum, add member, delete member. We have a lot of servers as

DevX - Software Development Resource

FPNW

Question: I have 130 users on my Novell side and I want them to be able to use all of the printer on my NT side. How can I authenticate

DevX - Software Development Resource

NT API

Question: I am trying to use the CreateProcessAsUser API function. If I put the declaration found in the win32api.txt, the program responds, “Can’t found DLL entry point” (Lib kernel32 function