Question { IBM, 3779 }

How to Install SQL SERVER 2005 remotely?

Answer

Performing a Remote Installation
Introduction
You can install SQL Server 2005 on a remote computer over a
network. Being able to perform a remote installation is
useful when you need to install SQL Server on multiple
computers in different locations, or when it is not
practical to require physical access to the computer on
which you want to inst all SQL Server.


Remote installation requirements
Remote installations must be performed from a command
prompt using an .ini file. The .ini file must include the
parameters explained in the following table.

Parameter Description
TARGETCOMPUTER The network name of the computer on which
SQL Server is to be installed
ADMINACCOUNT The account with administrative privileges to
be used to log onto the remote computer
ADMINPASSWORD The password for the administrative account
to be used to log onto the remote computer


Remote installation is supported only in a domain
environment; it cannot be used to install SQL Server on a
remote computer in a workgroup.
http://www.programmersheaven.com/2/SQL-server-2005-school-
lesson-3-p2

Question { Intel, 6788 }

difference between select column name from table name where
serviceid=2; and select max(column name) from table name
where serviceid=2;
IN ORACLE

Answer

Let's Say Struct of Table_Name is
Column_name Varchar, Service_id Int

Values:('Z',2),('Y',2),('B',2),('C',2)

ANS:
select column name from table name where
serviceid=2
Will be 'C'

ANS:
select max(column name) from table name
where serviceid=2;
Will Be 'Z'