|
Παρουσίαση με Ετικέτες
Όλες οι Ετικέτε... » Notes » sql (RSS)
-
In Entity Framework code-first, if you have a domain model like the following: [crayon-582b152280188265428148/] and want to create an index for a string property, when you execute update-adtabase for your migration, you may end up with the following error: This usually happens when you use VARCHAR(max) which is the default column type when creating a string property in EF. To make...
|
-
In Azure if you have two or more SQL Databases and you want to perform a query across them, you might come across the following error: [crayon-579cfaea2349f498907233/] In order to perform cross database queries among SQL Azure databases you need to use the elastic database query feature. What is the Elastic Database Query Feature? The elastic database query feature enables you to run a Transact-SQL query...
|
-
These are some quick notes on how to configure an SQL Server to Listen on a Specific TCP port. Open Run Command line and type: SQLServerManager12.msc for SQL Server 2014 SQLServerManager11.msc for SQL Server 2012 SQLServerManager10.msc for SQL Server 2008 and press Enter. To assign a TCP/IP port number to the SQL Server Database Engine In SQL Server Configuration Manager, in the console...
|
|
|
|