QUESTIONS

Tagged: sql-server

answers  2
views  700
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  111
votes  0

[Question] Difference between INNER JOIN and OUTER JOIN in SQL Server  

I am not sure what the difference is between INNER JOIN and OUTER JOIN. Can someone perhaps give an example with a simple query? BTW: I am using SQL Server, but ORACLE is fine too.
Jun 16, 2016
Harkrishna Nair
{ 50 - 1 - 0 }
answers  0
views  77
votes  0

[Question] How do I check that a column exists in a SQL Server table?  

What is the quickest way to check that a particular column exists in a table in SQL Server?
Jun 16, 2016
Harkrishna Nair
{ 50 - 1 - 0 }
answers  1
views  116
votes  0

[Question] How to get a list of all tables in a SQL Server database?  

How do I get all the names of tables in a specific database on SQL Server?
Jun 16, 2016
Harkrishna Nair
{ 50 - 1 - 0 }
answers  2
views  566
votes  3

[Question] How to add a new column, with a default value, to an existing table in SQL Server  

How do I add a column to an existing table in a SQL Server database? In my scenario I am adding a column of type int with a default value of 0.
May 14, 2016
Dylan Barlow
{ 65 - 1 - 0 }
answers  0
views  87
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  365
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 }
7  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.