Question { 5386 }

What is a job?

Answer

Don't post rubbish Answer

Jobs : A job is a specified series of operations performed
sequentially by SQL Server Agent.
A job can perform a wide range of activities, including
running Transact-SQL scripts, command prompt applications,
Microsoft ActiveX scripts, Integration Services packages,
Analysis Services commands and queries, or Replication
tasks. Jobs can run repetitive or schedulable tasks, and
they can automatically notify users of job status by
generating alerts, thereby greatly simplifying SQL Server
administration.


More Information Click This Link


http://msdn.microsoft.com/en-us/library/ms186273.aspx

Question { Virtusa, 27427 }

how to find number of columns in a table in sql server 2000
and 2005 also

Answer

IN SQLSERVER 20005


SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'TABLENAME'


try in sql server 2000

Question { 11845 }

what is different between SqlCommand object and Command
Behaviour Object

Answer

ADO.NET Command Object - The Command object is similar to
the old ADO command object. It is used to store SQL
statements that need to be executed against a data source.
The Command object can execute SELECT statements, INSERT,
UPDATE, or DELETE statements, stored procedures, or any
other statement understood by the database. See sample
code...

'Code below in VB.NET ...
Dim ObjCom as SqlClient.SqlCommand
ObjCom.SqlConnection(strCon)
ObjCom.Connection.Open()
ObjCom.CommandText = "Select * from tblSample"
ObjCom.ExecuteNonQuery()


SqlCommand objects are not used much when we use datasets
and data adapters. Following are some properties of the
SqlCommand class...

Question { Accenture, 58552 }

What are mdf,ndf,ldf files and how to see the data in those
files?

Answer

mdf: When You Create Database .this Primary file
ndf: This is Sceondry File
ldf: Lof Files