• Sign in
  • Sign up 
  • Welcome
  • FAQ
  • Block Explorer 
  • Night Mode
  • Stolen Accounts Recovery 
  • Change Account Password 
  • Vote for Witnesses 
  • Hive Proposals 
  • OpenHive Chat 
  • Developer Portal 
  • Hive Whitepaper 
  • Privacy Policy
  • Terms of Service
logo
  • Posts
  • Proposals
  • Witnesses
  • Our dApps
LoginSign up

pretentious (45)Hivebuzz level badge

889 followers7 posts1610 following15 HP
Blacklisted Users
Muted UsersFollowed BlacklistsFollowed Muted Lists

Joined February 2018 Active 8 years ago

  • Blog
  • Posts
  • Replies
  • Social
  • Notifications
  • Wallet
  • pretentious (45)in #sql • 8 years ago
    featured

    SQL Issue: INSERT without column_list

    When reviewing application code, I often see INSERT queries that don't specify a column list. INSERT INTO Table1
    $7.11
    • Past Payouts $7.11
    • - Author $6.89
    • - Curators $0.23
     29 3
  • pretentious (45)in #sql • 8 years ago
    featured

    SQL Issue: Short Table Aliases

    I often see queries that use short names for table aliases. The queries look something like this. SELECT a.Column2
    $11.24
    • Past Payouts $11.24
    • - Author $10.59
    • - Curators $0.66
     25 2
  • pretentious (45)in #sql • 8 years ago
    featured

    SQL Issue: Code Comments... or lack of them

    I was looking at a stored procedure the other day, trying to troubleshoot an issue. The stored procedure was well structured, short and relatively simple. The problem was, I…
    $6.10
    • Past Payouts $6.10
    • - Author $6.02
    • - Curators $0.08
     11 3
  • pretentious (45)in #sql • 8 years ago
    featured

    SQL Issue: SELECT INTO #TempTable

    When writing queries, we often require an intermediate table to store results which will be used later in the query. One of the more common ways to achieve this is with a…
    $7.57
    • Past Payouts $7.57
    • - Author $6.59
    • - Curators $0.98
     14 5
  • pretentious (45)in #sql • 8 years ago
    featured

    SQL Issues: LIKE '%stuff%'

    The SQL 'LIKE' operator is powerful. It allows us to do wildcard searches on column values. We love to use it, but sometimes we misuse it. I often see developers use the LIKE…
    $3.60
    • Past Payouts $3.60
    • - Author $3.56
    • - Curators $0.04
     13 1
  • pretentious (45)in #sql • 8 years ago
    featured

    SQL Issue: SELECT * FROM Table

    While troubleshooting an application, I stumbled across this SQL query issued by the app. SELECT *
    $5.06
    • Past Payouts $5.06
    • - Author $5.00
    • - Curators $0.06
     23 1
  • pretentious (45)in #csharp • 8 years ago
    featured

    C# 001: Hello World

    This is the first in a series of articles describing how to program in C#. We'll start from the very beginning and provide the building blocks for you to create more elaborate…
    $3.76
    • Past Payouts $3.76
    • - Author $3.73
    • - Curators $0.03
     15 2