MS SQL Server
文章平均质量分 69
zlxadhkust
这个作者很懒,什么都没留下…
展开
-
dotNET Trouble Shooting
1. 由于启动用户实例的进程时出错,导致无法生成 SQL Server 的用户实例。该连接将关闭。原创 2014-04-24 14:30:39 · 932 阅读 · 0 评论 -
Deploying ASP.NET MVC App On Azure
Prerequisite & Precondition:Windows 7 ProVisual Studio 2015 Enterprise (Update 3)SQL Server 2014 ExpressThe web app is based on ASP. NET MVC 5, Entity Framework, and it has data stored i原创 2016-10-24 16:08:28 · 334 阅读 · 0 评论 -
Note on <Beginning Microsoft SQL Server 2012 Programming> - 04
Chapter 11: Writing Scripts and BatchesChapter 12: Stored Procedures原创 2015-08-16 15:27:04 · 1662 阅读 · 4 评论 -
Vincent's ASP.NET Cookbook: Get Connected to Database
Open Visual Studio 2012 ExpressYou may have no clue about how to type in the "Server name", find it in your SQL Server Mangement StudioOnce connected, a new node wi原创 2015-09-19 15:56:21 · 626 阅读 · 0 评论 -
Vincent's SQL Server Cookbook: Script the Collation
Collation is a fundamental setting option of a database, it determines how the letters are sorted alphabetically, therefore its value affects sorting, comparison of literal fields and indexes on those原创 2015-09-19 15:43:53 · 356 阅读 · 0 评论 -
Note on <Professional SQL Server 2012 Internals And Troubleshooting> - 01
Chapter 1: SQL Server ArchitectureSELECT COUNT(*)*8/1024 AS 'Cached Size (MB)' ,CASE database_id WHEN 32767 THEN 'ResourceDb' ELSE db_name(database_id) END原创 2015-09-05 23:21:22 · 467 阅读 · 0 评论 -
Note on <Beginning Microsoft SQL Server 2012 Programming> - 03
Chapter 9: SQL Server Storage and Indexs StructuresHow Data Is Accessed in SQL ServerUsing a table scanWhen a table scan is performed, SQL Server starts at the physical beginning of原创 2015-08-28 21:17:17 · 907 阅读 · 0 评论 -
Note on <Beginning Microsoft SQL Server 2012 Programming> - 01
CHAPTER 1 RDBMS BASICS: WHAT MAKES UP A SQL SERVER DATABASE?masterThis database holds a special set of tables (system tables) that keeps track of the system as a whole. All extended an原创 2015-06-14 23:04:46 · 730 阅读 · 1 评论 -
Note on <Beginning Microsoft SQL Server 2012 Programming> - 05
Chapter 14: Transactions and LocksTransactionsDefinition of ACID:Atomicity: The transaction is all or nothing.Consistency: All constraints and other data integrity rules have been原创 2015-08-28 21:10:42 · 650 阅读 · 0 评论 -
Note on <Beginning Microsoft SQL Server 2012 Programming> - 02
Chapter 5: Creating and Altering TablesObject Names in SQL ServerThere are actually four levels in the naming convention for any SQL Server table (and any other SQL Server object for that ma原创 2015-08-28 21:03:59 · 727 阅读 · 0 评论 -
SQL in SQL Server Trouble-shooting
#1: Cannot insert explicit value for identity column in table 'table_name' when IDENTITY_INSERT is set to OFF.SET IDENTITY_INSERT [dbo].[tbl1] ONINSERT INTO [dbo].[tbl1] ([Id], [原创 2015-06-04 11:19:43 · 835 阅读 · 11 评论 -
SQL Interview Preparation (in the context of MS SQL Server)
1. Inner join on multiple columnsSuppose we have two tables in place as below:Joining them on F1 and F4 will give you:And join them on both F1=F4 and F2=F5, you will get:Re原创 2015-06-04 11:42:57 · 540 阅读 · 2 评论 -
Note On <Programming Entity Framework 2nd Edition> -04
Setting Default Values"You can also set default values in your database, so why define defaults directly in the model? The CustomerTypeID property is non-nullable. Not only is this defin原创 2015-01-28 15:49:56 · 524 阅读 · 0 评论 -
关于本人将会搬家博客的声明
至对这个博客有点关注的人:本人写博客的初衷很简单,主要是管理个人的知识和信息,软件开发这个行业的知识有其独特的性质,博大精深,结构宏大而细微处又琐碎,往往要经过一番长期的求索才能领悟一些知识,比如原理,算法等等,所以作为从业人员,记录下自己解开的知识点非常重要。这些博客其实只是个人的学习笔记,目标读者也只是我自己而已,没想到还是有很多人来看,也有些被收入知识库。也没有想到有一天会写原创 2017-04-13 17:05:25 · 532 阅读 · 0 评论