You’re probably looking forwith (updlock, holdlock). This will make a select grab an exclusive lock, which is required for updates, instead of a shared lock. The holdlock hint tells SQL Server to keep the lock until the transaction ends. FROM TABLE_ITEM with (updlock, holdlock)
Yes. add a linked server entry, and use select into using the four part db object naming convention. Example: SELECT * INTO targetTable FROM [sourceserver].[sourcedatabase].[dbo].[sourceTable]
In order to be independent of the language and locale settings, you should use the ISO 8601 YYYYMMDD format – this will work on any SQL Server system with any language and regional setting in effect: SELECT CAST( CAST(year AS VARCHAR(4)) + RIGHT(‘0’ + CAST(month AS VARCHAR(2)), 2) + RIGHT(‘0’ + CAST(day AS VARCHAR(2)), 2) … Read more
I was able to solve a problem similar to this in Visual Studio 2010 by using NuGet. Go to Tools > Library Package Manager > Manage NuGet Packages For Solution… In the dialog, search for “EntityFramework.SqlServerCompact”. You’ll find a package with the description “Allows SQL Server Compact 4.0 to be used with Entity Framework.” Install … Read more
MSSQL can handle that many rows just fine. The query time is completely dependent on a lot more factors than just simple row count. For example, it’s going to depend on: how many joins those queries do how well your indexes are set up how much ram is in the machine speed and number of … Read more
Had the same problem, I fixed it. Open SQL Server Configuration manager Click on the SQL Server Services (on the left) Double-click on the SQL Server Instance that I wanted to start Select the Built-in account radio button in the Log On tab and choose Local system from the dropdown menu Click apply at the … Read more
OK, I think I have found the answer to my own question. (It was buried under the tabs on the SS Express product page.) Here is a summary of the distinctives of LocalDB I found on that page: LocalDB is a lightweight deployment option for SQL Server Express Edition with fewer prerequisites and quicker installation. … Read more
Same as your other code, add a “Database project” to your application solution and keep the sql files used to build the database objects in there. Use the same version control for those code files as you do for the application.
select name, compatibility_level , version_name = CASE compatibility_level WHEN 65 THEN ‘SQL Server 6.5’ WHEN 70 THEN ‘SQL Server 7.0’ WHEN 80 THEN ‘SQL Server 2000’ WHEN 90 THEN ‘SQL Server 2005’ WHEN 100 THEN ‘SQL Server 2008/R2’ WHEN 110 THEN ‘SQL Server 2012’ WHEN 120 THEN ‘SQL Server 2014’ WHEN 130 THEN ‘SQL Server … Read more
There is a bitwise XOR operator – the caret (^), i.e. for: SELECT 170 ^ 75 The result is 225. For logical XOR, use the ANY keyword and NOT ALL, i.e. WHERE 5 > ANY (SELECT foo) AND NOT (5 > ALL (SELECT foo))