User msi77

37 votes

How to show the column names of a table?

answered Sep 29, 2011 at 9:22

7 votes

How to test if a column definition allows nulls?

answered Sep 27, 2011 at 9:23

5 votes

Accepted

An example of a relation without any functional dependency?

answered Dec 4, 2013 at 10:23

5 votes

Where to learn advanced SQL coding

answered Mar 11, 2012 at 5:42

4 votes

How do I use SSMS to compare Database 1 Table 1 against Database 2 Table 1?

answered Jan 8, 2013 at 13:03

4 votes

Is it possible to make one column readonly?

answered Mar 8, 2013 at 10:03

3 votes

Many-to-one Subselection in single query

answered Nov 10, 2012 at 6:23

3 votes

Use of HAVING without GROUP BY in SQL queries

answered Jan 26, 2014 at 7:32

2 votes

Changing field length when foreign keys reference primary key field in table

answered Dec 29, 2012 at 13:13

2 votes

Accepted

Is there a free/web-based game that requires knowledge of SQL to win?

answered May 1, 2014 at 16:08

2 votes

Display all tables and their columns

answered Nov 28, 2012 at 20:53

2 votes

INSERT succeeds but all inserted values become NULL

answered Jan 22, 2013 at 10:23

2 votes

How to find all positions of a string within another string

answered May 11, 2013 at 16:05

2 votes

Accepted

How do you create a composite foreign key when key being referenced is also a foreign key

answered May 20, 2013 at 17:53

1 vote

Accepted

Merge Fields into one Row with a Query

answered Oct 5, 2013 at 17:57

1 vote

Access: search for more than one parameter?

answered Nov 16, 2013 at 5:44

1 vote

Delete word, its meanings, its meaning's example sentences from DB

answered Jan 16, 2013 at 19:13

1 vote

Where can I find example databases for MySQL, SQL Server and Oracle?

answered Feb 23, 2012 at 7:00

1 vote

Check of SQL Server upgrade success

answered Dec 2, 2012 at 20:08

1 vote

How to split a string to and get info from another table in mysql

answered Dec 12, 2012 at 18:37

1 vote

Error deleting more than 1 row

answered Dec 21, 2012 at 18:51

1 vote

SQL - double column used from primary key with autoincrement

answered Mar 28, 2012 at 7:18

1 vote

Return int value from boolean field in SQL select

answered Sep 22, 2011 at 9:14

1 vote

How to get super parent from table with self relationship

answered Nov 23, 2011 at 17:39

1 vote

Set timeout expiration in ms sql 7

answered Dec 7, 2011 at 15:34

1 vote

Small sample database for practicing database administration?

answered Dec 10, 2011 at 15:02

1 vote

How do I count and order by unique entries?

answered Jun 28, 2014 at 12:14

0 votes

how to add muliple rows with insert in order

answered Sep 23, 2018 at 4:58

0 votes

unpivot 2 columns into one column

answered Oct 24, 2018 at 14:04

0 votes

Help with query statement

answered Jan 29, 2014 at 15:59

Stack Exchange Network

46 Answers

How to show the column names of a table?

How to test if a column definition allows nulls?

An example of a relation without any functional dependency?

Where to learn advanced SQL coding

How do I use SSMS to compare Database 1 Table 1 against Database 2 Table 1?

Is it possible to make one column readonly?

Many-to-one Subselection in single query

Use of HAVING without GROUP BY in SQL queries

Changing field length when foreign keys reference primary key field in table

Is there a free/web-based game that requires knowledge of SQL to win?

Display all tables and their columns

INSERT succeeds but all inserted values become NULL

How to find all positions of a string within another string

How do you create a composite foreign key when key being referenced is also a foreign key

Merge Fields into one Row with a Query

Access: search for more than one parameter?

Delete word, its meanings, its meaning's example sentences from DB

Where can I find example databases for MySQL, SQL Server and Oracle?

Check of SQL Server upgrade success

How to split a string to and get info from another table in mysql

Error deleting more than 1 row

SQL - double column used from primary key with autoincrement

Return int value from boolean field in SQL select

How to get super parent from table with self relationship

Set timeout expiration in ms sql 7

Small sample database for practicing database administration?

How do I count and order by unique entries?

how to add muliple rows with insert in order

unpivot 2 columns into one column

Help with query statement