FENDER TIMES

UPDATE  [YOURTABLE] SET [DATETIME]=DATEADD(YEAR,1,[DATETIME]) WHERE [YOURTABLE].ID=[YOURTABLE].ID datepart 可以自訂為year、month、day等 number 為加減日期或年月 DATEADD (datepart , number , date )  See also https://dotblogs.com.tw/lastsecret/2010/10/04/18097:

在透過SSMS建立AZURE雲端DATABASE SQL 封裝dacpac時 遇到以下畫面 sql error 71564 其原因是因為資料庫的結構有問題 存有失去關聯的帳號 要解決 可以利用以下SQL語法找到失去關聯的帳號 將他刪除重建 再執行一次就會成功了 /************************* * * Script written by Dale Kelly 11/23/2011 * Revision 1.0 * Purpose: This script searches all databases for orphaned users * and displays a list. If desired the orphaned users can be deleted * ***********************/ Use master Go Create Table #Orphans ( RowID int not null primary key identity(1,1) , TDBName varchar (100), UserName varchar (100), UserSid varbinary(85) ) SET NOCOUNT ON DECLARE @DBName sysname, @Qry nvarchar(4000) SET @Qry = '' SET @DBName = '' WHILE @DBName IS NOT NULL BEGIN SET @DBName = ( SELECT MIN(name) FROM master..sysdatabases WHERE /** to exclude named databases add them to the Not In clause **/ name NOT IN ( 'model', 'msdb', 'distribution' ) And DATABASEPROPERTY(name, 'IsOf...

修正一些官方的錯誤 注意  AZURE的PowerShell版本需要6.0.0以上 另外網路相關的設定會丟失 IP、虛擬網路、VPN等 需要重新設定 Connect-AzureRmAccount Get-AzureRMSubscription | Format-Table $subscrID="132cdab3-5b8a-4920-b89b-81fdaadb46fd" Get-AzureRmSubscription -SubscriptionId $subscrID | Select-AzureRmSubscription $resourceGroupName = 'ClassicVM' $destinationResourceGroup = 'ClassicVM' $location = 'southeastasia' $virtualNetworkName = 'ClassicVNet' # new VM vnet $virtualMachineName = 'classicvm' # new VM name $virtualMachineSize = 'Standard_DS1_v2' $adminUserName = "fender" $adminPassword = "Xyz=1234567890" | ConvertTo-SecureString -AsPlainText -Force $imageName = 'classicVMImage' $osVhdUri = 'https://storagever1.blob.core.windows.net/vhds/classicvm-os-5668.vhd' $dataVhdUri = 'https://storagever1.blob.core.windows.net/vhds/classicvm-datadisk.vhd' $dataDiskName = 'dataDisk1'  $osDiskName = 'myOsDis...