科技行者

行者学院 转型私董会 科技行者专题报道 网红大战科技行者

知识库

知识库 安全导航

至顶网软件频道SQL Server 2008 T-SQL - you learn something new everyday

SQL Server 2008 T-SQL - you learn something new everyday

  • 扫一扫
    分享文章到微信

  • 扫一扫
    关注官方公众号
    至顶头条

It's the little thing that make you smile. I am at TechEd this week at an excellent session by Bob Beauchemin on the T_SQL enhancements in SQL Server 2008.

作者:Andrew_Fryer 来源:blog 2007年11月19日

关键字: SQL Server 2008 SQL Server 数据库

  • 评论
  • 分享微博
  • 分享邮件

It's the little thing that make you smile.  I am at TechEd this week at an excellent session by Bob Beauchemin on the T_SQL enhancements in SQL Server 2008.

He popped up a slide with the += operator which allows you add a number to itself in common with many other languages so:

@MyNumber += 2 would add to the number (this also works for  minus, multiplication and divide).

Somebody asks Bob "Does that work with strings as well?"

Let's check that Bob says.

declare @myName varchar(12) = 'Bob'

set @myName += ' Foo'

Print @myName

that returns 'Bob Foo' which is what you'd expect but good to know.

So top marks to Bob for his presentation style, and to the product guys for making the new function consistent.

    • 评论
    • 分享微博
    • 分享邮件
    邮件订阅

    如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。

    重磅专题
    往期文章
    最新文章