Tagged: sql

answers  2
views  819
votes  0

[Question] UPDATE from SELECT in SQL Server  

How can I update/modify the contents of a table, by using a subset of data obtained from secondary SQL query statement?
Oct 13, 2016
Alaattin Snijder
{ 50 - 1 - 0 }
answers  0
views  347
votes  1

[Question] How to name tables in a database: Singular or Plural?  

What is the convention with respect to naming tables in a relational database: singular or plural? I have always been using singular and it has served me well. I think it is more intuitive. The one ...
May 12, 2016
Nhean Duong
{ 54 - 1 - 0 }
answers  0
views  95
votes  1

[Question] SQL Select only rows with MAX columns value  

Our Conversation table maintains many message threads. Each thread between two users has a unique id, and every time a new message is added to the thread, the message number get incremented by 1. Her ...
Apr 07, 2016
Craig Yamada
{ 54 - 1 - 0 }
answers  0
views  388
votes  3

[Question] How to pass a parameter to a SQL IN clause with C#, SQL Server  

My database has two tables that have master-child relationship. They are School and Student. Each school can have any number of students. A user has selected a number of schools. Next, they want to ...
Apr 07, 2016
Cheng Cao
{ 64 - 1 - 0 }
4  posts
You may also like
When to use 'ref' and 'out' keywords - specifically with strings?
Visual Studio 2015 F10 Debugger key not working
Horizontally centering a <div> inside another <div>
How to Encrypt and Decrypt a string in C#
Server Side Rendering in JavaScript?
Curlybrackets Software
The source code for Curlybrackets (C#/.NET/SQL Server) is available for purchase here. Start your own Q+A site now!

Easily create custom post types: messages, ideas, questions, tickets, whatever.

The Software Pack is a great place to start your corporate Q+A customer support site.