#SQL statements

[thedbahub]

Connecting SQL Statements to C#: Traceability Techniques for Seamless Integration

In the realm of software development, traceability plays a crucial role in ensuring the integrity and maintainability of your codebase. When it comes to connecting SQL statements to C# code, implementing effective traceability techniques becomes even more essential. In this article, we’ll explore practical T-SQL code examples and applications that demonstrate how to establish a robust connection…

[rhysintherain]

If anyone is wondering what I'm like in real life, I have two great examples from this morning:

Read "select entry-application-received-deposit-date from entry-application where entry-application-received-deposit-date is less than term-deadline and entry-ID equals entry-ID" out loud perfectly in one breath, then stumbled and stammered over "so now the roommate page won't be visible after the term deadline" so badly my coworkers couldn't figure out what I was trying to say less than 10 minutes later.

Bought extra hold pins for my hair last week, forgot them all at home, and pinned the sides of my hair where it isn't long enough to go in a ponytail up with paperclips when I got to work.

That's it, that's probably all you need to know about me.

[fujimen]

Current work mood collage

[tutor-net-in]

https://www.tutornet.in/database-management-and-sql/sql-select-statement/

SQL SELECT Statement: The SELECT statement in SQL is used to retrieve data from one or more tables in a database. It allows you to specify which columns you want to retrieve and apply various conditions, groupings, and orderings to the data.

[cyrsed]

how have i spent this long trying to fweaking Sort A List in java

[marsdevs]

Simplify Your SQL Statements with These Handy Functions

Mastering a new programming language might be scary. Like any other, it has a wide vocabulary that you must learn. But what better way to learn SQL than mastering the SQL functions? There are numerous SQL functions for working with various data types. Once you are all versed with some of the most common, you'll have enough confidence to go on to more challenging ones. Once you have mastered the fundamentals, consider digging further into these topics to expand on what you already know.

Click here to know more: https://www.linkedin.com/posts/marsdevs_carousel-sql-statements-activity-7112682284868120578-0by5

[anonymusbosch]

on wanting to do a million things

prompted by @bloodshack 's

i wanna learn SQL but i wanna learn haskell but i wanna learn statistics but i wanna start a degree in macroeconomics also sociology also library science but i wanna learn norwegian but i wanna learn mandarin but i wanna paint but i wanna do pottery but i wanna get better at woodworking but i wanna get better at cooking but i wanna bake one of those cakes that's just 11 crepes stacked on top of each other but i wanna watch more movies but i wanna listen to more podcast episodes but i need to rest but i need to exercise but i wanna play with my dog but i wanna go shopping but i need to go grocery shopping but i need to do the dishes but i need to do laundry but i need to buy a new x y and z but i need to save money but i wanna give all my money away to people who need it more but i wanna pivot my career to book editing but to do that i have to read more and i wanna read more nonfiction but i wanna read more novels but i wanna get better at meditating but i wanna volunteer but i wanna plan a party but i wanna go to law school. but what im gonna do is watch a dumbass youtube video and go to bed

I think I've been doing slightly better this year about Actually Doing Things. not great! but I do a lot and I've been "prototyping" ways to get closer to doing as much as is possible. and if I actually talk about it it's a bunch of very obvious statements but I'll try to make them a little more concrete

rule number one: experiment on yourself

there's no one approach that's right for everyone and there's not even one approach for me that works at all times. try things out. see what works. pay attention to what doesn't. try something else.

rule number two: ask what's stopping you and then take it seriously

example: I often want to do Everything in the evening at like 2 PM, but then get home and am tempted sorely by the couch, and then get stuck inertia'd and not doing much but being tired and kind of bored. why?

if I don't have plans, it's easy to leave work later than planned and hard to make myself do something by a specific time

i'm generally tiredish after work. 4 out of 5 times, that'll go away if I actually start Doing Something, but 1 out of 5 it's real and I will go hardcore sleepmode at 8 PM and just be Done

i use up a ton of my program management/executive function/Deciding Things brain at work and usually find it noticeably harder to string together "want to do Thing > make list of Things > decide on a Thing > do Thing" after I'm home. Even if I have a list of Things to Do, how does one decide! how does one start! and god forbid there's a Necessary thing. then it's all downhill

therefore, mitigations: have concrete time-specific plans in advance.

if I have an art class at 6:00 PM I need to leave work by 5:15 and NO LATER and I can't get sucked into "oh 10 more minutes to finish this" *one hour later*

that also means I have to have a fridge or freezer dinner ready and can't spend 45 minutes cooking "fuck it, what the hell did I put in the fridge, why don't we have soy sauce" evil meal that is not good

plans with friends: dinner! art night! music night! repair-your-clothes night! seeing a show! occasionally, Accountability Time where a friend comes over for We Are Doing Tasks with tea and snacks etc.

for some reason I'm way better about Actually Doing Things when the plan exists already. magically I overcome couch inertia even though I am the same amount of tired! and while I never learn the ability to decouch without plans I at least learn to make them

still working on:

a "prototype" for maybe next month is a weeklyish Study Session for a thing I want to learn about. I want to somehow make it employer-proof (I am accountable to some entity to being at place X at time Y) and haven't figured out a good way. Maybe I can leverage that the local library is open til 8 on wednesdays and somehow make it a Thing? maybe I'll try it!

oh god oh fuck the thing about plans is that if you want to have them you need to make them. christ. a lot of the time I can cover this with some combo of weekend planning + recurring events (things like weekly friend dinner/weekly class) + having cool friends who reach out proactively but it still requires active planning and it can fall thru the cracks

rule three: cool friends

they can take you to things

they can remind you that you can do whatever the fuck you please

i have a friend who is somehow Always doing cool classes and learning shit. and this reminds me that I can ... do that. and sometimes I do

you can take them to things!!

rule four: try to kill the anon hate in your head

obv this depends on your circumstance but sometimes it's worth it to me to look at constraints that "feel real" and check whether they're an active choice I made thoughtfully or, like, the specters of people I don't know judging my choices

time and money are obvious ones. recently was gently nudged towards looking at whether i could give myself more time to Do Things by cooking less. imaginary specters of judgmental twitterites: "it's illegal to spend money. if you get takeout you're the first up against the wall when the revoution comes. make all your lunches and dinners and hoard the money for Later. for Something. how dare you get lunch at the store. you bourgeois hoe. taking charity donations from the mouths of the poor cause you don't have your life together enough to cook artisanal bespoke dinners every night. fuck you." and obviously eating takeout 24/7 is not the answer, but realizing I was not making an active choice helped me try making the active choice instead. "how much do I actually want to balance cost, time, tastiness, and wastefulness of my food, given my amount of free time and my salary and the tradeoff against doing something else? can I approach it differently to do more quick cheap food + some takeout?" -> current prototype: substitute in 1 takeout dinner or restaurant-with-friends a week, 1 frozen type dinner, and then batch cook or sandwiches lunches w/ "permission" to get fast lunch at the store. we'll see how it goes!

i am really really bad at this and find it helpful to talk to other people who can help point out when I'm being haunted by ghosts about it.

rule five: what would it take? what's the next step?

this one i give a lot of credit to @adiantum-sporophyte in particular for, especially for prompting me with questions when I muse about the million-ideal-lives on car rides. what would it look like to do xyz? what's something I could do right now to move in that direction? what's the obstacle? like, actually ask the question and think through it. with a person talking to you! damn! maybe the obstacle to x is that I don't know if I'll like it or if I just like the idea of it. and I don't want to commit to x without knowing. Okay, so maybe an approach would be to find someone who does x and talk to them about how their life is, or maybe it's "spend 15 minutes looking up intro-to-x near me", or "actively schedule 1 instance of x", or something like that. Or maybe it's that I don't know what it takes to do x. Okay, how about on Tues after dinner Adiantum fixes a sweater at my apartment while I spend 20 min looking at prereqs for x. like, it's so basic to say "to do a thing, you could try figuring out how to do it" but I think the important thing here is the feedback/prompting to even recognize "hey, step back, if you don't know the next step then figuring out the next step is the next step"

rule six: habits

prototyping: exercise

I do a lot better when I exercise in the mornings. I do a lot better when I do PT exercises regularly. For a while I was doing PT with friend in the morning every morning before work (accountability! a friendly face to make it more pleasant!) but that didn't really solve - it's not the kind of exercise that makes me feel awake/active, it's like dumb little foot botherings. but: having the habit of morning exercise made it easier to swap out 2 of the 5 days for more intense exercise, and then to swap those 2 for a different more intense exercise when I needed a break. it's easier to build a low-effort version of the habit and then work in the higher-effort one than to just Decide to be the kind of person who gets up at ass o clock to do cardio or whatever

rule seven: set up the structure of your life to make it easy

this is also a "duh" thing but like. on so many levels it comes down to structure your life to make the choice more doable. this can be something like "i structure my life to make vegetarian cooking baseline and vegan cooking the majority by stocking the pantry with staples and spices from cuisines that work well that way" or "i chose an apartment that lets me commute by bike" or "i have my camping gear put away in a fashion that makes it easier to gather frequently and lowers the barrier to trips" or "i keep physical books around to prompt myself to read xyz" to "i don't use instagram or twitter or snapchat or facebook" to . idk.

and in terms of charitable giving: similar deal. I have an explicit budget at the beginning of the year (~10% of my before-tax income), I know in advance what charities I give to, and I know what timing I will use (basically, alerts for donation matching around specific fundraising times). Anything outside the Plan comes from my discretionary budget/fun money. That makes it less of a mental load (the choice is already made; I don't grapple with every donation request or every bleeding-heart trap because I have a very solid anchor on "I give to xyz, the money's set aside") and it's armor against impulsive-but-not-useful scrupulosity. I structure the rest of my spending/life to prioritize a set amount and it makes it easier to follow through

rule eight: if you can do it at work a tiny bit that counts for real life

(infrequently used)

"hi mr. manager I think it would be great if I could use enough SQL to make basic queries in the database so we don't have to go through the software team for common/basic questions. I'd like to take 1 hr on Friday to go through some basic tutorials and then 1 hr with Pat on Monday so he can walk me through an intro for our specific use case. I estimate this will help save the team a couple hours a week of waiting for answers from the other team." and then you have enough of a handle with baby's first SQL that you can add little bits and bobs as you exercise it. this is responsible for a medium amount of my knowledge of python and all 3 brain cells worth of SQL.

rule nine: life is an optimization problem

not in, like, "you need to optimize your skincare and career and exercise and social life and have everything all at once" that's not what optimization means. optimization is like, maximize something with respect to a set of constraints. i explicitly Do Not do skincare beyond "wash face" and "sunscreen" bc I want to optimize my life for like looking at weird plants in the mountains. explicitly choosing to put time and money elsewhere! can't have it all all at once. so fuck them pores. who give a shit. yeah i ate a lot of protein shakes instead of home cooked breakfasts this week bc i was prioritizing morning exercise. im looking at this beautiful bug and it doesn't know what fashion is or what my resume looks like. im holding a lizard. im not spending time on picking cool clothes or whatever bc i spent that time looking up lizard hotspots on purpose.

that's really long and probably mostly, like, not surprising? but i keep benefiting from ppl being like "hey have you considered Obvious Thing" framed very gently

[oldguydoesstuff]

I was in highschool in the late 1970s, and our "new" computer was a DEC PDP-8, that was five years old or so.

However the school was still largely running on punch cards, and older IBM equipment from the 50s. Attendance for instance, was handled by each home room teacher putting an absent students punch card in an envelope that went down to the computer room, a process that had probably been going on for decades.

There the cards were sorted, and fed into this beast, an IBM 405 alphabetic accounting machine. This is basically a SQL statement implemented in steel, wires, and relays. It would print off a report using fields on the cards fed into it, and could be programmed via a plug board:

I will never forget the IBM service guy coming in to change the oil on this, the whole bottom of it was relays that just kind of sat in an oil bath.

So if you have computer problems, just be happy changing the oil isn't one of them lol.

[thedbahub]

Using CASE Statements for Conditional Logic in SQL Server like IF THEN

In SQL Server, you can use the CASE statement to perform IF…THEN logic within a SELECT statement. The CASE statement evaluates a list of conditions and returns one of multiple possible result expressions. Here’s the basic syntax for using a CASE statement: SELECT column1, column2, CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ... ELSE default_result END AS…

[rhysintherain]

Which Mythological Trope are You?

Tagged by @blackjackkent

You know, I could really use the nap...

Tagging: @sassyminnesotan, @fixomnia-scribble, @invisible-goats, and anyone thinking "oh, they don't mean ME when they say anybody else who feels like it!"

[lunacoding]

SQL Interactive Websites

Hi! I wanted to share some websites that have helped me with bettering my SQL skills and are interactive, as in you can learn as you practice SQL on the website through an educational or fun way! 

SQL Bolt

This website is one of the best for beginners to SQL as it helps with explaining the different SQL statements as well as giving brief interactive exercises for each explanation/topic. Additionally, it offers help on more intermediate topics as well such as subqueries. However, this site doesn’t have many resources on more advanced SQL topics, so it may not be best if you’re more intermediate in SQL, but could be good for a basics refresher.

SQL Zoo

This website is another one which is good for beginners to SQL as similarly to SQL Bolt, it primarily explains different SQL statements and queries. There are brief interactive exercises as well as quizzes on various SQL topics. Additionally, there are assessments for more advanced users of SQL to test their knowledge which consist of 15 questions for different databases, including dressmaker, musicians, help desk, and so forth.

Select Star SQL

This website is an interactive SQL exercise where you learn as you go while interacting with a database of death row patients. The difficulty of queries slowly increases as you go through the exercise. I find this website helpful as it threw me into SQL and I prefer the learning while doing method, especially with real-world data. This could potentially be triggering if you don’t want to read the details of people being on death row.

SQL Murder Mystery

This website is an interactive SQL exercise where you try to figure out who committed a murder using SQL. This website is good for both beginners and more intermediate SQL learners. It offers a walkthrough for people who are completely new to SQL. Alternatively, the website gives schema details to those experienced with SQL and want to figure it out on their own.

SQL Police Department

This website is similar to SQL Murder Mystery where you try to figure out police cases through learning SQL. It has prompts where you then use SQL to try to figure out the information the police need. The site also has a guide on SQL and gives basic summaries on different queries. I found this site fun to use and it has a cool interface. However, one con of this site is you can only do a certain amount of SQL queries before it asks you to pay for the longer version of the site.

Practice SQL

This website has been my personal favorite as the interface is clean and easy to understand. The website gives you prompts to use SQL to select from two different databases, the first of which is based on doctors and patients in different provinces while the the second is based on products and their orders as well as employees who work at the company. For both of these databases, there’s a series of prompts/questions from easy to intermediate to advanced SQL. Additionally, there’s learning resources which helps explain different queries and functions of SQL as well, if you’re confused or need help!

I hope you guys find these websites helpful!!

[tahthetrickster]

banging my fists on my desk. why is writing fanwork erotica not a real full-time job with benefits. why do i have to be writing SQL statements instead. i could be doing a pornographic character study right now

[enterprise-bee]

do you think vulcans have arguments over which mathematical logic system they should use. like, okay, most computing and aristotle's logic is boolean logic/algebra, in which there are two possible values for any statement: TRUE/FALSE. a few computing languages (SQL being the most notable) use three-value logic: TRUE/FALSE/NEITHER (with the 'neither' sometimes being 'unknown' or 'null'). or do you think they use a many-valued logic system of some kind, with other logical states. what do they think of the law of the excluded middle? do they have their own symbolic logic notation? do they have a different word for logic (the mathematical and philosophical discussion) and logic (doing things that make sense, as is the colloquial use of the word in english). do you think their philosophers get into fights when they come across planets that use different mathematical logic systems? because there is nothing stating every society uses the same base assumptions about math, or even the same type of electronic circuits/computing systems that we do that so heavily rely on binary logic,

[codingquill]

SQL Fundamentals #2: SQL Data Manipulation

In our previous database exploration journey, SQL Fundamentals #1: SQL Data Definition, we set the stage by introducing the "books" table nestled within our bookstore database. Currently, our table is empty, Looking like :

books

| title | author | genre | publishedYear | price |

Data manipulation

Now, let's embark on database interaction—data manipulation. This is where the magic happens, where our "books" table comes to life, and we finish our mission of data storage.

Inserting Data

Our initial task revolves around adding a collection of books into our "books" table. we want to add the book "The Great Gatsby" to our collection, authored F. Scott Fitzgerald. Here's how we express this in SQL:

INSERT INTO books(title, author, genre, publishedYear, price) VALUES('The Great Gatsby', 'F. Scott Fitzgerald', 'Classic', 1925, 10.99);

Alternatively, you can use a shorter form for inserting values, but be cautious as it relies on the order of columns in your table:

INSERT INTO books VALUES('The Great Gatsby', 'F. Scott Fitzgerald', 'Classic', 1925, 10.99);

Updating data

As time goes on, you might find the need to modify existing data in our "books" table. To accomplish this, we use the UPDATE command.For example :

UPDATE books SET price = 12.99 WHERE title = 'The Great Gatsby';

This SQL statement will locate the row with the title "The Great Gatsby" and modify its price to $12.99.

We'll discuss the where clause in (SQL fundamentals #3)

Deleting data

Sometimes, data becomes obsolete or irrelevant, and it's essential to remove it from our table. The DELETE FROM command allows us to delete entire rows from our table.For example :

DELETE FROM books WHERE title = 'Moby-Dick';

This SQL statement will find the row with the title "Moby-Dick" and remove it entirely from your "books" table.

To maintain a reader-friendly and approachable tone, I'll save the discussion on the third part of SQL, which focuses on data querying, for the upcoming post. Stay tuned ...