ChuckLu - 博客园

2021年4月30日

The object 'DF__*' is dependent on column '*' - Changing int to double

摘要： The object 'DF__*' is dependent on column '*' - Changing int to double Try this: Remove the constraint DF_Movies_Rating__48CFD27E before changing your 阅读全文

posted @ 2021-04-30 11:24 ChuckLu 阅读(736) 评论(0) 推荐(0)

CREATE VIEW must be the only statement in the batch

摘要： CREATE VIEW must be the only statement in the batch Just as the error says, the CREATE VIEW statement needs to be the only statement in the query batc 阅读全文

posted @ 2021-04-30 10:33 ChuckLu 阅读(359) 评论(0) 推荐(0)

What is the use of GO in SQL Server Management Studio & Transact SQL?

摘要： What is the use of GO in SQL Server Management Studio & Transact SQL? SQL Server Management Studio always inserts a GO command when I create a query u 阅读全文

posted @ 2021-04-30 10:32 ChuckLu 阅读(80) 评论(0) 推荐(0)

CREATE DATABASE

摘要： CREATE DATABASE Creates a new database. Click one of the following tabs for the syntax, arguments, remarks, permissions, and examples for a particular 阅读全文

posted @ 2021-04-30 10:01 ChuckLu 阅读(405) 评论(0) 推荐(0)

2021年4月28日

发票税费计算

摘要：比如消费27.5，开餐饮发票的时候，税率按照6%计算。 x*(1+0.06)=27.5 税27.5/106*6=1.56 价27.5-1.56=25.94 最后的合计是27.5 阅读全文

posted @ 2021-04-28 18:30 ChuckLu 阅读(2162) 评论(0) 推荐(0)

SQL Server “RESTORE FILELISTONLY” Resultset

摘要： SQL Server “RESTORE FILELISTONLY” Resultset Dead-end: SELECT INTO is nice because you don't have to define the table columns but it doesn't support EX 阅读全文

posted @ 2021-04-28 16:46 ChuckLu 阅读(117) 评论(0) 推荐(0)

SQL SERVER – Restore Database Backup using SQL Script (T-SQL)

摘要： SQL SERVER – Restore Database Backup using SQL Script (T-SQL) In this blog post we are going to learn how to restore database backup using T-SQL scrip 阅读全文

posted @ 2021-04-28 16:33 ChuckLu 阅读(271) 评论(0) 推荐(0)

'database' is compressed but does not reside in a read-only database or filegroup

摘要： 'database' is compressed but does not reside in a read-only database or filegroup As stated here, SQL Server databases are not supported on compressed 阅读全文

posted @ 2021-04-28 14:32 ChuckLu 阅读(148) 评论(0) 推荐(0)

SQL Server: Database stuck in “Restoring” state

摘要： SQL Server: Database stuck in “Restoring” state 回答1 I had this situation restoring a database to an SQL Server 2005 Standard Edition instance using Sy 阅读全文

posted @ 2021-04-28 13:46 ChuckLu 阅读(164) 评论(0) 推荐(0)

Database Stuck in a Single User Mode in SQL Server

摘要： Database Stuck in a Single User Mode in SQL Server 第一步 By using the the dynamic view "sys.dm_tran_locks" we can find out the active sessions of the da 阅读全文

posted @ 2021-04-28 13:42 ChuckLu 阅读(151) 评论(0) 推荐(0)

Chuck Lu

公告