All Questions
Tagged with database sql-server
21 questions
1
vote
1
answer
53
views
Generate Serial number based on column value in sql server
I have table called cash_voucher it has some columns.
I want to generate voucher number based location id.
I mean generates voucher numbers starting from 1 for each location
For example location id is ...
- 141
2
votes
0
answers
66
views
Case Study: Database design help for a small app used to coach tennis players
I have a small SQL server database and VBA program that is used to automate tasks related to tennis students, programs, practices, performances, and student testing.
I'm trying to learn db design and ...
- 21
1
vote
1
answer
149
views
Creating database and two tables linked by foreign key
These commands do what I want, but I'm trying to find out the best approach for this. My main areas of concern are: error handling and disposal of resources. In regards to error handling, I'm catching ...
1
vote
1
answer
454
views
Database schema for discussion forum scraping
I'm scraping posts from various discussion forums and storing those posts, along with some metadata, into a relational database (SQL). My actual use case is a bit more complex, but I think I can give ...
- 13
-1
votes
1
answer
93
views
IF SELECT statement will break SQL ACID Compliance? [closed]
My QA told me that I should not use IF SELECT before doing an UPDATE statement because it will breaks the atomicity of a ...
- 141
2
votes
1
answer
50
views
Performance stored procedure update multi-coulmn sql
I have a stored procedure the every 5 min run in sqlserver
high cost iO/cpu
do you have any idea to tune this query
...
2
votes
1
answer
2k
views
Database Model for Feedback Module
I wish to generate an online feedback system. Requirements are
Admin can enter feedback questions
Admin will select these questions and create a feedback session
One Question can be used in many ...
- 129
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
5
votes
2
answers
164
views
Combining SQL Tables into One Table in New DB with Similar Fields
I have a SQL Server Database filled with Reports all having the same schema.
What I've done is created a .NET application to automate the process of adding all reports to a new table.
How can the ...
4
votes
2
answers
86
views
Inserting two rows that are almost identical to each other
I'm trying to make test data for an application I'm writing, and some of my test data is very repetitive, involving inserting a row and then inserting another row that is identical except for one ...
- 43
1
vote
2
answers
126
views
Materiel position query for a war game written in Unity
I am making a tank game. I have a database on a server where I store information about Tank itself, Hulls, Turrets, and Guns.
When the server gets "Hull" request it returns all needed information ...
- 143
0
votes
1
answer
698
views
Normalizing an apartment rental database [closed]
We are to normalize a database, though it is mostly all theoretical, we aren't actually plugging in the SQL. This is the Data we have normalized to these tables..
and here is our SQL for normalizing ...
- 19
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 ...
2
votes
1
answer
64
views
Map groups to parent products using nested subqueries
I have the following tables
...
3
votes
1
answer
173
views
Database design for users' postcards
I would like to a review of my database design.
There are 3 tables + ASP.NET Identity tables.
The Users could have many postcards.
Here's my tables without Identity.
I attached also my scripts of ...
- 191