Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server
Search options not deleted
user 21276
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
1
vote
How to convert unsigned int accidentally stored as signed int?
I think you might be mistaken about what happened to your data. Positive integers generally have the same representation as signed and unsigned integers.
It looks like your first value is 564 or 141 …
- 383
10
votes
Accepted
Can I skip the intermediate table in a join?
tl;dr
The short answer is no. You have to do the multiple join, even if you only want columns from the two tables 'on each side'.
Table design
This seems like a pain, but although it makes your que …
- 383
2
votes
Relational Design - One table, two foreign keys or Two tables, one foreign key each
I would certainly recommend B in most cases. Both A and C leave open lots of room for inconsistency. Enforcing that exactly one of two columns is NOT NULL (for case A) is quite a pain. If you need uni …
- 383