Posts Tagged “database”
Did a simple, customized SQL query builder that’s only specific for UPDATE statements some time early last year. Thought I’d just write it down here. It was a smaller part of a bigger application. It wasn’t required for all update cases, but a number of them did. I’ve mostly re-written it from memory. It should…
Using Repository implementation with Spring Data, one can develop applications with an underlying database rapidly in Spring Boot. The Spring Data JPA handles the abstraction of the persistence layer quite well. Many times you probably won’t need anything else beyond what it has to offer. A lot can already be done with the exposed methods…
There are 2 ways that I know of. I tend to always do what is easier. That is through the GUI application that is Microsoft SQL Server Management Studio (SSMS). Option 1 Login into Microsoft SQL Server. Select the database. Go to Security. It usually is down at the bottom. Click on the yellow folder…