[thelist] Constructive Crit

[JenniferE at mif.com]

win2000, ie 5.5, 17" monitor - I think both look great.  Easy to read; clean, sharp layouts; professional.  I really like them both!

Jennifer

-----Original Message-----
From: Michael Buffington [mailto:mike at price.com]
Sent: Tuesday, April 17, 2001 4:22 AM
To: 'thelist at lists.evolt.org'
Subject: [thelist] Constructive Crit


Looking for some design crit on:
http://www.michaelbuffington.com/resume

Also:
http://www.stompzine.com/index.cfm

Any thoughts on color, design, readability, usability, etc, appreciated.

<tip type="SQL Server" Author="Michael Buffington">
Having trouble executing a highly dynamic stored procedure in SQL Server?

Build the SQL statement as a string, like so:

set @statement =
(
'SELECT cols
FROM table
WHERE col_id IN (' + @ids +  ' )'
)

Then execute it:
exec (@statement)

Or print it for debugging:
print (@statement)

Pros - allows you to execute stored procedures that would otherwise bonk, in
this case, let's you pass a comma delimited list of ID numbers

Cons - no execution plan is created for the executed string, which can
result in performance loss.
</tip>

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !