SQL Server is a relational database management system from Microsoft.
-4
votes
1answer
56 views
how to write a stored procedure to insert data in to a sql server database in a datagridview in a form?
I need to insert data through a form using a datagridview connected to a SQL Server 2008 R2 database. is it ok, if I write a single insert stored procedure query in a while loop in the form.cs
0
votes
0answers
11 views
Retrieving chinese characters in database [migrated]
i have a database that contains both chinese characters and english. when i queried the database to display them on my browser using php, all i get for the chinese characters are gibberish, none ...
1
vote
1answer
140 views
Best way to process a queue in C# (PDF treatment)
First of all let me expose what I would like to do : I already dispose of a long-time running webapp developed in ASP.NET (C#) 2.0. In this app, users can upload standard PDF files (text+pics). The ...
5
votes
2answers
85 views
Tracking changes to posts
I'm currently in the process of writing a support ticket system... Let's say it's a small forum application, or something like Uservoice.
Now I want my users to be able to edit their tickets, but ...
0
votes
1answer
61 views
Different ways to generate the latest int type primary foreign key in code
I am new to sql. I have added 2 new tables in database. The primary key of first is a foreign key in the other. The type of the keys is integer. Now I want to generate the keys in the code and assign ...
0
votes
1answer
51 views
Running SQL Server Express on Micro/Extra Small VM
I'm exploring options for running a small cloud Windows Server (either AWS EC2 Micro or Azure Extra Small).
The server won't be hit very hard, but I need to run a simple relational database, which ...
1
vote
1answer
125 views
Reading CSV files located on a Linux server and updating the tables in a SQL Server database
I was wondering how we could ingest CSV files located on a Red Hat Linux server into SQL Server database tables.
I know we can write a stored procedure/bulk insert to read the files that are located ...
1
vote
1answer
122 views
Are there any SQL servers that support compiled queries?
Can SQL queries be compiled into byte code or equivalent to enhance performance?
I know that most database servers support prepared statements, but is that the same thing as compiling? Most ...
-1
votes
2answers
108 views
SQL Server: When to use SSIS vs T-SQL for ETL Tasks [closed]
When should I use one versus the other? For instance, let's say I have 20 comma delimited, denormalized text files and I want to transform the data and load it into normalized SQL Server tables.
0
votes
2answers
105 views
Will SQL Server autonumber reuse a value if a record is deleted?
The titled basically states it. If I have a bigint column with primary key and autonumber, and a record is deleted, will SQL Server ever reuse that now available value?
The underlying issue is that I ...
1
vote
1answer
157 views
JOIN vs. INNER JOIN and FULL OUTER JOIN
I know there is a difference between INNER JOIN and FULL OUTER JOIN, I can see it, but, what is the difference between the two following: JOIN ... ON... and INNER JOIN...ON... and still yet ...
0
votes
4answers
136 views
Storing application users in SQL: create a new “Users” table or use built-in database user management?
I am specifically interested in SQL Server, but the same question applies in general. When creating a new application, the way I see it, there are two options:
Create a table called "Users" and ...
3
votes
1answer
320 views
Rewriting C# Formula Calculations in T-SQL
We have a 3-tier application with a C# client that connects to a C# web service via WCF and requests data from a SQL Server database.
One feature in our application is a user-created form app in ...
2
votes
4answers
312 views
ado.net or EF for a point-of-sale system
We have a point-of-sale system that was developed using ado.net, our current concern is to make the application real fast in creating transactions (sales). Usually there are no performance concerns ...
0
votes
1answer
101 views
Advanced Search Stored procedure
So I am working on an MVC ASP.NET web application which centers around lots of data and data manipulation.
PROBLEM OVERVIEW:
We have an advanced search with 25 different filter criteria. I am using a ...
