ChuckLu - 博客园

2021年4月30日

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 阅读(66) 评论(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 阅读(394) 评论(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 阅读(2116) 评论(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 阅读(108) 评论(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 阅读(256) 评论(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 阅读(131) 评论(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 阅读(149) 评论(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 阅读(125) 评论(0) 推荐(0)

2021年4月27日

GitHub Actions 教程：定时发送天气邮件 weather

摘要： GitHub Actions 教程：定时发送天气邮件 GitHub Actions 教程：定时发送天气邮件 - 阮一峰的网络日志 (ruanyifeng.com) https://github.com/ChuckFork/weather-action/ curl -H "Accept-Languag 阅读全文

posted @ 2021-04-27 20:21 ChuckLu 阅读(380) 评论(0) 推荐(0)

vmware Increasing the size of a virtual disk

摘要： Increasing the size of a virtual disk For Workstation 7 and later and Player 3.x and later, you can increase the virtual disk from the GUI: Select the 阅读全文

posted @ 2021-04-27 01:43 ChuckLu 阅读(265) 评论(0) 推荐(0)

Chuck Lu

公告