文章分类 -  SQL

摘要：There are a whole bunch of articles, blog entries and tutorials that seek to explain how SQL JOINS work. Some of them are excellent, and others are just confusing. The reason I am adding my go at try... 阅读全文

摘要：When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool — although you must be careful when using it. This article explores how you can use this fun... 阅读全文

摘要：site:http://articles.techrepublic.com.com/5100-22_11-5035150.html?tag=rbxccnbtr1 Takeaway: Security in the development of a SQL Server database must be a priority right from the start, beginning with ... 阅读全文

摘要：两种经常使用的方法: 1. Update, if @@ROWCOUNT = 0 then insert UPDATE Table1 SET Column1 = @newValue WHERE Id = @id IF @@ROWCOUNT = 0 BEGIN INSERT INTO Table1 (Id, Column1) VALUES (@id, @newV... 阅读全文