Few Questions

Hi,

I have few questions about SQL Server, let me mention here..

How to generate XML File from SQL Server? Is there anyway can we generate directly from Query?

What are Temporary tables (Regular & Global) and where do we need them in Real Time?

What are BCP Statements? where do we need them?

How to pass XML Document to Proc, and insert the data, any example?

Types of Triggers?

Shink data, what is that?

What T-Read, Uncommitted read?

What is Replication ?

Thanks
Seshu

hey this is not few... hahaha

How to generate XML File from SQL Server? Is there anyway can we generate directly from Query?

you can use the for XML clause

example :

select * from employees for xml auto

What are Temporary tables (Regular & Global) and where do we need them in Real Time?

these are temporary table and are use to store data that still needs to be processed or

processed information that are too large to be return via a regular variable. temporary tables

performs like a regular table except that they are automatically destroyed when there are no more

connection referencing it. Regular temp tables as ( represent by tablename #temp, single pound sign) as oppose to

global temptable (which are named ##temp, using double pound sign) are visible only to the connection

that created it while Global temp tables are visible to any connection

What are BCP Statements? where do we need them?

bulk copy program is a Dos based interface for loading multiple records from files(CSV,stc) using bcp formats

How to pass XML Document to Proc, and insert the data, any example?

in 2005 XML datatype can be used as parameters in table definition and as variables. you can insert an XML or fragment of XML to an XML columns. You can see my blogs for some examples

Types of Triggers?

insert, update, delete, instead of, DDL triggers

Shink data, what is that?

This is used to compress the data and release unused spaces use by the database. you can also use Shrinkfile to individually shrink the database

What T-Read, Uncommitted read?

looks like this topic belongs to serialization and locking. this is how sql server is going to read the data

What is Replication ?

replication is copying and synchronizing data to another server

Your homework is quite long hahaha.