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 answers only
not deleted
user 6605
SQL Server is a relational database management system from Microsoft.
5
votes
Accepted
SQL Server Management Studio Show last executed query
If you want to know what is the query corresponding to the change you've done to a table (or other object) in designer mode, use Generate Change Script (Table Designer → Generate Change Script... or t …
- 142k
9
votes
Accepted
Should "tags" be an nvarchar field in a table, or should it be another table altogether?
Warning: the question being tagged sql-server, my answer applies to Microsoft SQL Server only, and is not relevant for other SQL engines.
There are three approaches for storing tags:
One table: a …
- 142k
2
votes
Accepted
SQL scripts in TFS without putting them into solutions?
With TFS Power Tools, you can access your repository (do commits, add files to the repository, etc.) directly from Windows Explorer, just like you do with TortoiseSVN.
Then, you can add any file you …
- 142k
11
votes
Accepted
Best practice for storing HTML coming from text fields to a database?
It's not silly at all.
Consider the following possibilities:
Store just HTML. That 's silly! Once stored this way, editing it would be painful: you either should decode it, or simply forbid any edi …
- 142k
4
votes
Storing application users in SQL: create a new "Users" table or use built-in database user m...
Database user management is intended to provide a mechanism for the users to access the database itself. Using it to store, for example, the accounts of your customers, is a perversion: it was never d …
- 142k
1
vote
Accepted
Mid-Large Asp.net MVC project: Storing images on filesystem or via SQL Server FILESTREAM
Since you're talking about images in a context of a news portal, I imagine that those images are small JPEGs, not RAW files which can easily be 30 MB in size. In that case, FILESTREAM won't be recomme …
- 142k
2
votes
Single Database Vs Multiple Database on SQL Server
How oranges are different from lemons? I mean, are they “structurally different” like a Product is structurally different from Person or from Comment, or they are just different forms of the same obje …
- 142k
3
votes
Accepted
Is Entity Framework 6 agnostic enough different sql server and OS platforms?
Entity Framework (EF) uses mostly basic syntax and keywords: select, join, distinct, etc. This basic syntax doesn't change too much from version to version.
Between SQL Server 2008 and SQL Server 201 …
- 142k
12
votes
Entity Framework - Is there a safety mechanism to prevent accidentally running Update-Database?
Permissions
In SQL Server (and virtually any popular SQL databases), you can configure in a granular manner what a given user can do. Maybe it makes sense for the developers to access the production d …
- 142k
4
votes
SQL Server: Which License? Any alternatives?
The thing is I'm using EF Core to connect to de database, so I'm pretty attached to SQL Server.
No, you are not.
EF Core contains a bunch of providers, including Sqlite, PostgreSQL, and MySql.
…
- 142k