随笔分类 -  SQL Server

SQL Express - "Failed generate a user instance..."
摘要：Error Details2010-04-11 19:20:01.73 spid7s Script level upgrade for database 'master' failed because upgrade step 'repl_master.sql' encountered error 5598, state 1, severity 16. This is a serious erro... 阅读全文
posted @ 2010-04-11 15:32 Vincent Yang 阅读(744) 评论(0) 推荐(0)
SQL Express 2008 x64 Integration with Visual Studio 2008 SP1
摘要：This problem makes me nuts. I spent several hours try to resolve this problem. The following article is the best one which teach solve this silly problem step by step.Ref: http://blogs.visoftinc.com/a... 阅读全文
posted @ 2010-03-18 04:57 Vincent Yang 阅读(837) 评论(1) 推荐(0)
64bit SQL Server issues : Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly
摘要：Simple and easiest way to solve this problem => Uninstall 64bit SQL server express and install 32bit version Otherwise, Congratulations on boldly accepting the challenge to stick with the native 64... 阅读全文
posted @ 2009-08-05 17:24 Vincent Yang 阅读(432) 评论(0) 推荐(0)
SQL Server Precision And Scale Problems (SQL Server 精度问题)
摘要：Ref: http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-precision-and-scale-problemsSQL Server Precision And Scale Problemsby George Mastros 24 Nov 2008 08:43 , Categories: D... 阅读全文
posted @ 2009-01-23 05:23 Vincent Yang 阅读(1082) 评论(0) 推荐(0)
Creating, detaching, re-attaching, and fixing a suspect database
摘要：http://www.sqlskills.com/BLOGS/PAUL/category/Involuntary-DBA.aspxThis is one I've been trying to get to since I started blogging a couple of years ago: how to re-attach a detached suspect database. Th... 阅读全文
posted @ 2008-12-31 13:09 Vincent Yang 阅读(1524) 评论(5) 推荐(0)
SQL Server 2005 CTE (Common Table Expression)
摘要：Ref: http://www.eggheadcafe.com/tutorials/aspnet/c5c48628-5f72-4132-b0cf-b15d65b91c9c/sql-server-2005-cte-comm.aspx CTE is a new feature provided by Microsoft SQL Server 2005. In real world, we often ... 阅读全文
posted @ 2008-05-22 12:23 Vincent Yang 阅读(554) 评论(1) 推荐(0)
Upselling promotion stored procedure
摘要：CREATE PROCEDURE ProductPromotion_Select @ProductID int AS SELECT ProductID, ProductName, SUBSTRING(Description, 1, 150) + '...' AS Description FROM Products WHERE ProductID IN ( SELECT TOP 5 details2... 阅读全文
posted @ 2008-04-02 06:00 Vincent Yang 阅读(312) 评论(0) 推荐(0)
SELF-JOIN
摘要：Ref: http://www.udel.edu/evelyn/SQL-Class3/SQL3_self.html A self-join is a query in which a table is joined (compared) to itself. Self-joins are used to compare values in a column with other values in... 阅读全文
posted @ 2008-04-02 05:19 Vincent Yang 阅读(797) 评论(0) 推荐(0)
How to use Trusted Connection when SQL server and web Server are on two separate machines.
摘要：(Ref: http://weblogs.asp.net/achang/archive/2004/04/15/113866.aspx) Recently, in our consideration to make the production server environment more secure, one of the things we looked into was securing ... 阅读全文
posted @ 2008-02-22 11:16 Vincent Yang 阅读(1468) 评论(0) 推荐(0)
SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
摘要：February 6, 2008 by pinaldave This is very common request recently - How to import CSV file into SQL Server? How to load CSV file into SQL Server Database Table? How to load comma delimited file into ... 阅读全文
posted @ 2008-02-08 07:39 Vincent Yang 阅读(1011) 评论(0) 推荐(0)
How to move databases between computers that are running SQL Server
摘要：Ref http://support.microsoft.com/kb/314546/en-us 阅读全文
posted @ 2008-01-29 08:37 Vincent Yang 阅读(208) 评论(0) 推荐(0)
How can you use IIf in Transact-SQL?
摘要：This is a quite common question. It is usually asked by people arriving at SQL Server with a background in Microsoft Access. They either want to use SQL Server as a backend for their Access project,... 阅读全文
posted @ 2008-01-08 09:04 Vincent Yang 阅读(391) 评论(0) 推荐(0)
SQL Server Express WebLog : How to: Configure Express to accept remote connections
摘要：1434 Source: SQL Server Express WebLog : How to: Configure Express to accept remote connections 阅读全文
posted @ 2006-09-24 22:52 Vincent Yang 阅读(271) 评论(0) 推荐(0)
Configuring SQL Server Express 2005 for Remote Access
摘要：Link to Configuring SQL Server Express 2005 for Remote Access 阅读全文
posted @ 2006-09-24 22:51 Vincent Yang 阅读(275) 评论(0) 推荐(0)
关于SQL Server的view
摘要：今天就先发一篇数据库的基础文章,因为最近碰到过几个SQL Developer的工作，所以趁此机会把以前学校学的东西都拣拣。好了，废话不多说，进入正题吧。 首先View是干什么用的呢？ Views allow you to create a virtual representation of table data using a SELECT statement as its definition.... 阅读全文
posted @ 2006-09-20 21:45 Vincent Yang 阅读(2837) 评论(0) 推荐(0)
SQL 语法的规定
摘要：这个东西虽然看起来没什么实际意义，但是如果想为了看SQL Server Online Book很容的话，我觉得有必要花一些时间去记忆。 阅读全文
posted @ 2006-09-20 21:26 Vincent Yang 阅读(608) 评论(0) 推荐(0)