All Questions
7 questions
1
vote
1
answer
63
views
MSSQL database structure and stored procedure performance
I build database called MessageBoard and created StoredProcedure GetHomeView that return data for HomeView. I am completely new ...
- 19
4
votes
1
answer
1k
views
SQL e-commerce database design
I want as an exercise to create an e-commerce application from bottom up. My main goal here is to gain a lot of knowledge. I have experience in web development, but never have been there from the ...
- 143
4
votes
2
answers
126
views
Simple locale loader
I have a class that loads locales from a database. I'm not sure if locale is the right word. It's basically loading texts for a game, generic sayings like alerts and error messages.
I'm also not sure ...
- 1,355
1
vote
1
answer
469
views
Schema for SQL database of guitars
I just want to ask you guys if the database design that i made for my asp.net website is correct or not. So basically, I created a database for the brands of my guitar products, which is like this:
...
- 125
6
votes
1
answer
92
views
Stored procedure to describe the reason that a particular employee is unsuitable for a particular task
I used the following Stack Overflow questions as references for writing this code:
Select columns from result set of stored procedure
What is the equivalent of String.Join on TSQL?
The idea behind my ...
5
votes
2
answers
6k
views
University Database
I am building a database for a hypothetical university. This is my SQL definition, with generated data added for my future use, such as demonstrating queries:
...
user34073
2
votes
1
answer
71
views
Find foreign key membership including owner in SQL Server
Was hoping someone could sanity-check this SQL statement. I need to find the owner (schema), table, and column on both sides of a foreign key:
...
- 103