Skip to content

Instantly share code, notes, and snippets.

@alliwallibobali

alliwallibobali/ImpactOfWrongDataTypes.sql Secret

Created October 29, 2021 20:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alliwallibobali/ae5be19a92a515179df3748aff6984d3 to your computer and use it in GitHub Desktop.
Save alliwallibobali/ae5be19a92a515179df3748aff6984d3 to your computer and use it in GitHub Desktop.
Download ZIP
This example creates a table called numbers with an INT column and inserts a record with the value 1.
Raw
ImpactOfWrongDataTypes.sql
CREATE TABLE Numbers (V1 INT)
INSERT INTO Numbers (V1) VALUES (1)
SELECT V1 FROM Numbers WHERE V1 = '1'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment