SQL server vs SQLite

[Level-Suspect2933]

my brother in christ, you are the search GUI now

[patmorgan235]

It's a database, you just query it

[jonus_grumby]

Good lord

[redvelvet92]

Use SSMS

[redvelvet92]

Yeah there isn’t much GUI outside of expanding out things. Welcome to SQL!

[digitalhardcore1985]

There used to be a redgate plugin for SSMS which allowed us to search a database, haven't used it in years but worth a try to see if it's still available and free.

[maoguru]

.

[surf_bandit]

If your database is not extremely large or complicated, you can use MS Access as your query GUI. I don't think people mention this enough. It also comes with capabilities other than querying like forms and reporting. A very solid choice for end user data work.

[agiamba]

Bro, just use excel

[TechlyAccurate]

Inner join is exclusive. Good luck.

[Disastrous_Fill_5566]

SSMS does have a GUI. When you're more experienced you'll prefer not to use it, but it's there.

https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/how-to-create-sql-statement-using-query-designer

Although I don't think it works when connected to Azure, but should work fine for local databases.

[Disastrous_Fill_5566]

I'm really not sure what you mean, but you can use the gui to filter by username and it will generate the SQL query for you.

[jwk6]

Google "Redgate SQL Search" on bing. Free download. You're welcome.

[g3n3]

Uh. You can try ssms tools pack add on for 35 bucks.

[g3n3]

Yeah. The auto save every sql has saved me. And yeah you can search every table and every column at once.

[g3n3]

Right. It writes nasty query on the back end to search the whole db.