jump to:all–mastodon–bluesky–lemmy–lobsters–dev–stack–wiki–rss–hn

Knowledge / everything · hot matching “sql”

3 shown · updated 6s ago · read only

What is the difference between .one() and .scalar() (stackoverflow.com)stack

7 points by Syed mohamed aladeen in stackoverflow.com · 7y ago · stack

What is the main difference between .one() and .scalar() in SQLAlchemy, as both doing the same jobs. I saw some sites like tutorialpoint.com but that explanation is not enough for me to understand clearly
filed under python sqlalchemy flask-sqlalchemy
Improving the SELECT query performance on a large table in SQL Server (stackoverflow.com)stack

4 points by HOY in stackoverflow.com · 13y ago · stack

Q: How can I improve the performance of my queries ? Details: I have one table with 200k records (Sales) and one function getView_sls(@TON_orNPS) Below query takes 10-12 seconds SELECT * FROM Sales Below query takes 32-34 seconds SELECT * FROM getView_sls('TON') Below is my sale…
filed under sql performance t-sql sql-server-2005 query-performance
How to convert the Long value to String using sql (stackoverflow.com)stack

3 points by vijayboli in stackoverflow.com · 13y ago · stack

I am doing a long to string conversion using java in following way. Long longValue = 367L; String str = Long.toString(longValue, 36).toUpperCase(); this is returning me as value A7. how can achieve this in doing oracle sql. UPDATED: Hi, I have analyzed how java code is working t…
filed under plsql