Viewing 15 posts - 13,156 through 13,170 (of 13,469 total)
here's a lame example of both to help you visualize.
element centric:
<ROOT>
<BOOK>
<TITLE>The Best of SQLServerCentral.com - Vol. 3</TITLE>
<AUTHOR>Brian Knight</AUTHOR>
<NUMBEROFPAGES>250</NUMBEROFPAGES>
</BOOK>
</ROOT>
Attribute centric:
<ROOT>
<BOOK TITLE="The Best of SQLServerCentral.com - Vol. 3" AUTHOR="Brian Knight" NUMBEROFPAGES="250" />
</ROOT>
January 24, 2006 at 6:12 am
i think you might be getting hung up on formatting...
remember the date is actually stored as a double,where the integer portion is days and the decimal portion it part of a...
January 20, 2006 at 10:17 am
create an index on the column and see how that affects the speed:
CREATE INDEX IX_ActivityDate on C_Tracked_Item_Hist(ActivityDate);
also throw away all your converts...
Select * from table where activitydate > DATEADD(day,...
January 20, 2006 at 10:05 am
i think you are confusing the versions a little bit.
if you have a non server operating system, your SQL 2000 instance IS a MSDE instance...if you had either the SQL2000...
January 20, 2006 at 9:42 am
copy and paste it from a raw text editor...word might reformat it to a microsoft format.
copying that as text, naming it test.xls and then opening it in excel and you'll...
January 20, 2006 at 8:07 am
if you create an html document and give it the .xls extension, then when excel opens it, it will maintain the format...so if you make a <TD BGCOLOR="#EEEEEE"><B>COLUMN NAME</B></TD>
the cell...
January 19, 2006 at 2:36 pm
it's godawful easy; download the source fromt eh web link i posted.
copy the dll from the release folder to your c:\program files\microsoft sql server\$instancename\Binn directory.
run the .SQL script that is...
January 19, 2006 at 7:29 am
as Vladan identified, malformed HTML will result in an unwanted result from regular expressions.
here i used the extended stored proc i mentioned before:
declare @string varchar(8000),@regExpr varchar(500)
set @string='<OL>
<LI>
<DIV align=center>Store...
January 19, 2006 at 6:55 am
this is kind of hard to do; i use an extended stored procedure in order to strip RTF or HTML tags;
see this post for the details, other examples, etc:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=242853#bm243180
January 18, 2006 at 3:33 pm
you can't truncate a table that has a foreign key reference.
also, if you delete from the tables out of order, you'll end up with errors as well.
another thing to consider...
January 18, 2006 at 2:42 pm
i think the only way to do this is to use a function, and have the function return ONE column with all the values in a comma delimited format:
CREATE FUNCTION...
January 18, 2006 at 9:22 am
without using e3nterprise manager, here is a copy and paste solution:
declare
@isql varchar(2000),
@procname varchar(64)
create table #procResults(procid int identity(1,1) primary key,ProcText varchar(4000) )
declare c1 cursor for select name from...
January 17, 2006 at 1:19 pm
dumb question from someone less experienced....if you have a small database, say 300 meg...your server most likely has multiple gigs of ram...couldn't you pin every table and achieve a performance...
January 17, 2006 at 6:15 am
folowing some of the links there that have answers says that your MDAC is out of date and that you may be missing a .rll file.
HTH
\
January 16, 2006 at 1:33 pm
did you just post real client data credit cards on a forum? i hope the data you pasted is fake developer data.
edit the post and remove the data right away.
January 16, 2006 at 11:28 am
Viewing 15 posts - 13,156 through 13,170 (of 13,469 total)