SQL ServerBeginnerString Functions in SQL Server: Part One
Use ASCII, CHAR, NCHAR, CHARINDEX, LEFT, LEN, LOWER, LTRIM and DIFFERENCE correctly in SQL Server, with examples, results and the pitfalls of each.
#t-sql
Tanishk · 8 min
Loading…
Library
150 results
SQL ServerBeginnerUse ASCII, CHAR, NCHAR, CHARINDEX, LEFT, LEN, LOWER, LTRIM and DIFFERENCE correctly in SQL Server, with examples, results and the pitfalls of each.
#t-sql
Create, alter and drop views in SQL Server, update data through them safely, and understand schema binding, indexed views, permissions and common mistakes.
#t-sql
SQL ServerBeginnerFind failed SQL Server logins in the error log, read the error 18456 state codes, check SQL logins with LOGINPROPERTY, and set up a lasting audit.
SQL ServerBeginnerNumber rows with ROW_NUMBER() in SQL Server, then use it to get the latest row per group, delete duplicates and page results without surprises.
#t-sql
IBM Db2BeginnerInstall IBM Db2 with the free Community Edition container image or the Windows and Linux setup wizard, check edition limits, verify the instance and fix common setup errors.
#windows
MySQLBeginnerWrite a MySQL CREATE TABLE statement with sensible data types, keys and constraints, check the result, fix the common errors and drop the table safely.
SQL ServerBeginnerDo arithmetic in a T-SQL SELECT and avoid the usual traps: integer division, NULL results, divide-by-zero errors, overflow, rounding and float inaccuracy.
#t-sql
MySQLBeginnerCreate a MySQL database with the right character set and collation, add an application user with limited grants, verify the result and fix the usual errors.
#mysql-5.7
SQL ServerBeginnerSort SQL Server results by one or more columns, control where NULLs land, page with OFFSET and FETCH, and fix the common ORDER BY errors.
#t-sql
Apache CassandraBeginnerUnderstand what Apache Cassandra is, how its ring, replication and tunable consistency work, how to model tables in CQL, and when it is the wrong choice.
#data-modeling#scalability
IBM Db2BeginnerFix Db2 error DB29501E on Windows by setting the DB2INSTANCE environment variable to a valid instance, verify the change, and handle the related SQL1390C message.