All Questions
Tagged with sql-server beginner
23 questions
1
vote
1
answer
83
views
Is there a more concise way to write this query in SQL Server?
I'm playing with data from a Time Use survey as a beginner SQL user.
Gender is represented as 1's (Male) and 2's (Female), and the age of each participant is listed. I would like to divide them into ...
- 303
2
votes
1
answer
136
views
My first c# program: Get Data from Sql Server and show it in Textboxes
So I have been programming in VB.net and want to learn C#.
I "successfully" created a simple program that retrieves data from Sql Server during Form1_Load. The ...
- 123
1
vote
2
answers
105
views
Bash Script for file auditing, push information to server and be able to view in a web page
Edit: The goal of this Question was only seeking code review and guidance in learning or tips for improvement. I apologize if that was not clear or aligned properly with the goals of this forum.
...
- 23
3
votes
1
answer
403
views
Reading Database, scraping Barchart and uploading prices to DB
This is my first real excursion into Python, coming from C#. I wanted to see if my code is well-formatted and efficient.
The following will read the needed codes from a Database Table, then submit ...
- 208
9
votes
1
answer
151
views
The seasoned Zombie sniper: a query to find unanswered questions with specific tags
The query (on SEDE)
This query builds upon the previous and includes the suggestions by rofl as well as the now mentioned activity index.
...
- 19.6k
11
votes
1
answer
135
views
The sniper: a Zombie searcher for specific tags
Sometimes, it's not enough to know what the easy prey is. You also need to know whether you will be able to hunt it down. What good is an almost turned haskell zombie if you cannot read the functional ...
- 19.6k
15
votes
1
answer
1k
views
A wounded Zombie finder, or: how to find the almost dead undead?
The Zombies are on their way to eat our statistics. Fortunately, we have a way to get rid of them: our votes. However, we need to find them first. The /unanswered section is too large and contains ...
- 19.6k
3
votes
2
answers
4k
views
Retrieving data from SQL DB based on user input
I wrote this to connect to a local DB using my local login credentials. It pulls back card information based on the user's input.
...
- 33
2
votes
2
answers
4k
views
MVC simple Employee table with paging using SP
I am a beginner web developer and I have to do an exercise to show an Employee table using a WCF service, 10 entries at a time, with the paging of the table controlled by a stored procedure. What I ...
- 21
3
votes
3
answers
686
views
Querying employee schedules in a month [closed]
I have this code, this code querying employee schedules in a month, in a work unit. If the List<Employee> count are few, the code works great, but if the <...
- 143
11
votes
2
answers
2k
views
Batch file to backup and update SQL Server DBs
This is my first windows batch file. The script basically goes through this basic flow of tasks, in order to update some specific SQL Server DBs to a new DB version:
Backup all SQL server DBs that ...
- 548
3
votes
1
answer
968
views
Create database connection and run the insert, delete, update queries class-Update
Based on the feedback I have got from the guys reviewing the code as posted in my previous question.
Create database connection and run the insert, delete, update queries class
I have used ...
- 243
5
votes
2
answers
83
views
Adding dynamic column names to a table
I'm using Microsoft SQL Server 2014 Express.
I found myself wanting to add the Columns CompanyNameChangeDate (1 through 10) and ...
- 8,820
15
votes
1
answer
714
views
Example script for teaching DDL and CRUD/DML operations
I have taught some SQL to others before, and I thought of making a script that has these attributes, for the purposes of teaching:
Fully functional to run on local DB instance with no fuss
Easy to ...
- 20.5k
5
votes
2
answers
2k
views
Basic Bill of Materials schema
I've been working on Bill of Materials mini schema for a while. At first I had single Part table where I've referenced itself. I was told it would be better to have ...
- 109