SQL::R...LServer(3pm)

πŸ“¦
version 0.8 Β· 4 versions
, in debian bookworm, debian trixie, ubuntu noble, ubuntu resolute, ubuntu stonking

πŸ’– SQL::ReservedWords::SQLServer β€” bestie edition πŸ’–

okay so real talk: this is a <pink>section 3pm</pink> page, straight out of the User Contributed Perl Documentation for <purple>perl</purple> (the title up top got squished into SQL::R...LServer, but you and me both know what it really says πŸ’…). Anyway. Buckle up, because this module is genuinely so useful and we are about to be obsessed.


✨ NAME ✨

SQL::ReservedWords::SQLServer β€” reserved SQL words, but the SQL Server flavour πŸ¦‹


🌸 SYNOPSIS 🌸

like, the whole vibe in four lines:

if ( SQL::ReservedWords::SQLServer->is_reserved( $word ) ) {
    print "$word is a reserved SQL Server word!";
}

πŸŽ€ DESCRIPTION πŸŽ€

It figures out whether words are <hotpink>reserved</hotpink> by SQL Server. That's it, that's the whole thing, and honestly? iconic.


πŸ‘‘ METHODS πŸ‘‘

is_reserved( $word )

Hands you back a boolean saying whether $word is reserved by SQL Server 7, 2000 or 2005. all three, bestie, no favourites πŸ’–

is_reserved_by_sqlserver7( $word )

Boolean, but make it specifically SQL Server 7.

is_reserved_by_sqlserver2000( $word )

Boolean, and this time it's SQL Server 2000 only. periodt.

is_reserved_by_sqlserver2005( $word )

Boolean for SQL Server 2005 and nobody else 🌈

reserved_by( $word )

Returns a <mint>list</mint> of the SQL Server versions that reserve $word. so if a word is reserved in more than one place, you get the whole receipts list 🧾

words

Returns a <mint>list</mint> of all the reserved words. the whole collection. the entire wardrobe πŸ”₯


🫢 EXPORTS 🫢

Nothing by default. (not me giving you zero freebies, it's giving boundaries βœ‹)

But these subroutines can be exported if you ask nicely:

  • is_reserved
  • is_reserved_by_sqlserver7
  • is_reserved_by_sqlserver2000
  • is_reserved_by_sqlserver2005
  • reserved_by
  • words

πŸ¦‹ SEE ALSO πŸ¦‹

go read it, iykyk πŸ“š


πŸ’œ AUTHOR πŸ’œ

Christian Hansen <chansen@cpan.org> β€” thank you for your service, king πŸ‘‘


This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. (slay, open source behaviour fr fr πŸŽ€)


lowkey the most important thing: nothing here is dangerous, nothing's deprecated, nothing's undefined β€” it's just a vibe check for reserved words. go forth and is_reserved responsibly ✨

perl v5.34.0 Β· 2022-06-17 β€” and that's the whole page, bestie, mwah πŸ’‹πŸŒˆπŸ’–

πŸ“¦ where this page comes from