[thelist] Constructive Crit
JenniferE at mif.com
JenniferE at mif.com
Tue Apr 17 07:25:30 CDT 2001
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 !
More information about the thelist
mailing list