Viewing 15 posts - 76 through 90 (of 132 total)
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
--...
October 19, 2005 at 2:40 am
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).....................:...
October 18, 2005 at 6:16 am
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..............
October 17, 2005 at 6:36 am
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...
October 15, 2005 at 3:29 am
Hi!!
Thanks for ur help!! But now it seems.. , that my database table
design should be normal........I will...
October 15, 2005 at 12:02 am
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...
October 14, 2005 at 7:04 am
Hi!!
Try to run your job (Shrink @DB and Shrink @DBFile) in QA that works faster than scheduled job...
Regards
Shashank
October 14, 2005 at 6:43 am
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...
October 10, 2005 at 10:14 pm
Hi!!!!
this SP Execute permission default to public role.
EXEC sp_tables
so first check that u r not assinged to...
October 10, 2005 at 3:10 am
Hi u can use this!!!
SELECT * INTO <Destination_Table>
FROM
(
SELECT * FROM <Source_Table>
) S
October 10, 2005 at 12:44 am
Hi!!
Try to understand concept of it n then use this!!
Donot play blindly
October 3, 2005 at 10:48 pm
Hey!!! Go through this one
USE <Database_Name>
SET NOCOUNT ON
GO
/*
** If the objects already exist (i.e. if...
October 2, 2005 at 11:12 pm
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...
September 30, 2005 at 5:19 am
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...
September 22, 2005 at 6:43 am
Viewing 15 posts - 76 through 90 (of 132 total)