Hi!!!!

If data is in XML format like as below then....

declare @idoc int

declare @doc varchar(1000)

set @doc ='

<ROOT  YYYY="1996"  MM="8" DD="11">

</ROOT>'

--Create an internal representation of the XML document.

exec sp_xml_preparedocument @idoc OUTPUT, @doc

--...

Hi!!.......

Thanks for your reply...but can u explain it little bit more cause in first two cases fillfactor is 0 but still values are........

Avg. Page Density (full).....................: 99.06%

Avg. Page Density (full).....................:...

Hii!!!!

             update table categories

            set  faxnumber= 1234567

            where cust_name IN (Select cust_name  From   Table_Name/categories)

Table_Name is name of table where ur 1000 records are there or categories table itself I think..............

Hii!!!!

U can modified like this also!!!!

SELECT S.NAME TABLE_NAME,P.INDEX_NAME,P.CREATED_DATE FROM SYSOBJECTS S INNER JOIN (SELECT TOP 100 PERCENT NAME INDEX_NAME,PARENT_OBJ,TYPE,CRDATE CREATED_DATE FROM SYSOBJECTS ORDER BY 1) P

ON S.ID = P.PARENT_OBJ...

Hi!!!!!

When restoring a database backup to another server, you may experience a

problem with orphaned users.........

Hi!!

Thanks for ur help!!  But now it seems.. , that my database table

design should be normal........I will...

Hi!!

I am getting such type of resords in Test1 table from the application...

So I cannot do any thing from there...so pls suggest me any solution to get the records from...

Hi!!

Try to run your job (Shrink @DB and Shrink @DBFile) in QA that works faster than scheduled job...

Regards

Shashank

Hi!!!

As u told that u r new joiny there , so might be possible that u have given access to only that table , that u r seeing by this...

Hi!!!!

this SP Execute permission default to public role.

Examples

A. Return a list of objects that can be queried in the current environment

EXEC sp_tables

so first check that u r not assinged to...

Hi u can use this!!!

SELECT * INTO <Destination_Table>

FROM

(

SELECT * FROM <Source_Table>

) S

Hi!!

Try to understand concept of it n then use this!!

Donot play blindly
 Regards,
Papillon
 

Hey!!! Go through this one

USE <Database_Name>

SET NOCOUNT ON

GO

/*

**  If the objects already exist (i.e. if...

Hi!!

i dont think so only 11 records are copied out of 155 thats not possible as it is bulk insert statement either all records should copy or no records copied...

Hi..I got that one

Can you tell me what "WHERE NOT EXISTS (SELECT 1 FROM Etable2 WHERE B.ID=Etable2.ID AND B.CreateDate=Etable2.CreateDate)"

Do exactly here.......

any documents @ WHERE NOT EXISTS  function you have...