THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Architecture » T-SQL   (RSS)
  • Stored procedures are not parameterized views

    Peter van Ooijen over at CodeBetter.com posted in his blog about some observations he had when working with stored procedures in a recent project. What I found to be interesting about his post was his comment that a stored procedure can be, ''a view with parameters.''  I've run into this assertion before, and it's something I think needs ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
  • Rowset string concatenation: Which method is best?

    Yeah, yeah, yeah, let's get this out of the way right from the start: Don't concatenate rows into delimited strings in SQL Server. Do it client side. Except if you really have to create delimited strings in SQL Server. In which case you should read on. There was a little discussion on SQLTeam about the best way to concatenate. I ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
  • Caveats of the TEXT datatype

    Someone named ''Krygim'' posted the following question today in the microsoft.public.sqlserver.programming newsgroup:   ''Will defaulting a TEXT field to an empty string take up more space than defaulting it to Null when no data is entered into the field. [sic]'' Before reading any further, I ask that you think for a moment and ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement