Printer Definition file (PRT) is very use ful when we are 
crating Character Mode report it process faster and using 
this file we can write printer code in print before & Print 
after property of the report.

The Validation Triggers are used to validate the data 
entered int the parameter form.
If the parameter is having the number format and if the 
varchar2 is entered then to restrict such situations the 
VAlidation Triggers are used.

for the summary feilds like grand totals we can place this 
column,and it should be placed out of the repeating frame

we can create lexical parameter & bind parameter in the 
report in the data model query.
The bind parameter is used as well and lexical parameter 
used for ex:

select &deptno,ename,deptno from emp where empno=:empno

Its like temp variable to limit the formula column we can 
used it.

Before parameter 
After parameter 
Before report 
Between pages 
after report

BACK GROUND 
COPIES
CURRENCY
DESCIMAL
DESCIMAL FORMAT.
DES. NAME
DES. TYPE
MODE
ORIENTATION
PRINT JOB

we put the pictures in report output use bellow path
    
     goto livepriviwer of reports--->goto file
import--->image browse--->select image and save it

Lexical parameter is a condition (where clause) given at 
runtime to generate the report on that condition. The '&' 
symbol will preceed the where clause condition.

Lexical parameters can dynamically replace clauses in the 
Select statement in the data model and even the whole 
select statement. It replaces any part of a SELECT 
statement, such as column names, the FROM clause, the WHERE 
clause, the ORDER BY clause. To create a lexical reference 
in a query, prefix the parameter name with an ampersand (&)

The Text property exposes the Transact-SQL or other script 
that defines the referenced Microsoft? SQL Server? 2000 
database object.

The FunctionName property specifies the function name to 
call in the Microsoft? ActiveX? script associated with a 
script task or step.

1) functions are used for computations where as procedures 
can be used for performing business logic
2) functions MUST return a value, procedures need not be.
3) you can have DML(insert, update, delete) statements in a 
function. But, you cannot call such a function in a SQL 
query..eg: suppose, if u have a function that is updating a 
table.. you can't call that function in any sql query.- 
select myFunction(field) from sometable; will throw error.
4) function parameters are always IN, no OUT is possible

1. Functions can be used inline with a select statement 
while sprocs can't.

2. EXEC command can't be used inside a Function where it 
can be used inside an sproc.

Stored procedures are a set of actions already written and 
stored inside the database for acheiving a particular task 
where as functions are general database objects which are 
used for general purpose programming

there are 3 main differences between sp and function.
1 sp takes input,output parameters, function takes only 
input parameters.
2 temparary variables required to store return values of 
sp. in functions temparary variables will be optinale.
3 sp can not be called directly into DML statements , 
functions can be called directly into DML statements.

Stored procedure have the security and reduce the network
traffic.
and also we can call stored procedure in any no.of
applications at a time.

SP return a single result-set,
SP works with table variables,
SP uses EXEC stmts

SELECT GETDATE() AS 'Current Date'
GO

i donot abt the SQLserver2000and MSaccess.But in ORACLE we 
get current date by following SQLstmt:
SELECT sysdate() FROM DUAL;

we use getdate()in SQL server to view current date and in 
oracle we use sysdate().

In Access We USE 'Select Date()'
In Sql server 2000 'Select getdate()'
In Oracle 'Select SysDate() from dual'

In Access 'Select date()'
In Oracle 9i 'Select Sysdate from dual;'
In SQL Server 2000 'Select Getdate()'

This command is not working, I transferred MySQL database 
to SQL Server 2000 database.

Please tell me the actual command to use

To display current systems date
 
 DateTime.Now

select getdate(); in sql server 2000

slect TO-CHAR(syssdate,'dd-mm-yy h:mipm') from dual; this is
oracle query..

select date() does not work in Access 97.

The INSERTED and DELETED tables, popularly known as MAGIC 
TABLES, and update () and columns_updated() functions can 
be used to determine the changes being caused by the DML 
statements.
Note that the Magic Table does not contain the information 
about the columns of the data-type text, ntext, or image. 
Attempting to access these columns will cause an error.

While using triggers these Inserted & Deleted tables 
(called as magic tables) will be created automatically. 

When we insert any record then that record will be added 
into this Inserted table initially, similarly while 
updating a record a new entry will be inserted into 
Inserted table & old value will be inserted into Deleted 
table.

In the case of deletion of a record then it will insert 
that record in the Deleted table

wen we are performing DML operations into table . amagic 
table created in the memory.
inserted  magic table 
deleted magic table 
update magic table

is there any new table named "update magic table"???

NO THERE IS NO UPDATED MAGIC TABLE

only 2 magic tables

- INSERTED
- DELETED

in case of an Update operation the original row is stored in
the DELETED table and the new row is saved in the INSERTED table

Select  select_list from my_tabel

SQL Server stored procedures can return multiple record 
sets. The following is an example:

CREATE PROCEDURE procCustomerGet
@CustomerID VarChar(5)
AS
     SELECT * FROM Customers
	   WHERE CustomerID = 
           @CustomerID
     SELECT * FROM Orders
           WHERE CustomerID =
           @CustomerID