sudhir


{ City } noida
< Country > india
* Profession * software engineer
User No # 15989
Total Questions Posted # 0
Total Answers Posted # 4

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 83
Users Marked my Answers as Wrong # 16
Questions / { sudhir }
Questions Answers Category Views Company eMail




Answers / { sudhir }

Question { 5098 }

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

Is This Answer Correct ?    3 Yes 0 No

Question { Virtusa, 26204 }

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

Is This Answer Correct ?    29 Yes 5 No


Question { 11565 }

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...

Is This Answer Correct ?    9 Yes 2 No

Question { Accenture, 58005 }

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

Is This Answer Correct ?    42 Yes 9 No