Trigger AutoNumber di SQL Server

Trigger AutoNumber di SQL Server

Berikut ini trigger buatan saya untuk membuat autonumber, mungkin belum sempurna 100%, tapi paling tidak sudah berjalan dalam 3 tahun terakhir === begin trigger === SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[ti_Quotation] ON [dbo].[Quotation] after insert AS declare @xcounter nvarchar(100), @tahun nvarchar(2), @bulan nvarchar(2), @nomor int; declare @curr_tahun nvarchar(2), @curr_bulan nvarchar(2); declare xcount cursor for select counter,substring(counter,4,2), substring(counter,6,2),CONVERT(INT,substring(counter,8,5)) from AutoGen where table_name = ‘Quotation’; declare curr_monthyear cursor for select replicate(‘0’,2-len(convert(varchar,MONTH(GETDATE()))))+convert(varchar,MONTH(GETDATE())) , substring(convert(varchar,YEAR(getdate())) ,3,2); open xcount; open…

Read More Read More

Saving bandwidth when downloading Visual Studio 2017

Saving bandwidth when downloading Visual Studio 2017

Today Microsoft release Visual Studio 2017, in the my previous post, you can download offline install of Visual Studio, but for some people, they just need Desktop development only, no need to download all component which is total around 18GB. To saving your bandwidth, download only what you need, use –add <workload_id> options,for example: I just want download Winform Development only, so use vs_community__18950355.1469052767.exe –layout d:\vs2017a –add Microsoft.VisualStudio.Workload.ManagedDesktop It’s only 1.4GB, faster than you download all component which is total…

Read More Read More

Tutorial menggunakan Syncfusion Dashboard part 1

Tutorial menggunakan Syncfusion Dashboard part 1

Pada tulisan ini saya mencoba berbagi aplikasi dari Syncfusion, yaitu Syncfusion Dashboard, sebuah aplikasi yang menampilkan dashboard secara interactive melaui browser, beberapa feature yang ada di Syncfusion Dashboard adalah Designer Dashboard yang mudah digunakan Mengatur atau memanage dashboard melalui web Dashboard server yang dapat di deploy pada Azure Web Application Menggunakan engine HTML5 Dapat digabungkan dengan aplikasi web kita Free jika menggunakan Community License Jika ingin mencoba, silahkan register atau request terlebih dahulu untuk Community License di https://www.syncfusion.com/downloads/communitylicense Instalasi Syncfusion…

Read More Read More

Cisco Packet Tracer 6.3 and 7 for Windows and Linux

Cisco Packet Tracer 6.3 and 7 for Windows and Linux

Cisco Packet Tracer The best way to learn about networking is to do it. Cisco Packet Tracer, an innovative network configuration simulation tool, helps you hone your networking configuration skills from your desktop or mobile device. Use Packet Tracer to: Sharpen your skills for a job interview Prepare for a certification exam Practice what you learn in networking courses Cisco Packet Tracer  7.0 (Windows and Linux, 32bit and 64 bit) and 6.3 (Windows and Linux) download link http://viid.me/qxs8H6   System…

Read More Read More

Windows Server 2016 Released

Windows Server 2016 Released

Microsoft released Windows Server 2016 on January 12, 2017, you can download the evaluation version https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-2016 or download from your MSDN Library some new feature from this version: Strengthen your security—starting at the operating system Help prevent malicious attacks and detect suspicious activity where it matters: your operating system and workloads. Rely on security features built into Windows Server 2016 to control privileged access, protect virtual machines, and harden the platform against emerging threats. Be more efficient with a software-defined…

Read More Read More

[HOAX] IMAGE “GIF” YG SANGAT MEMBAHAYAKAN

[HOAX] IMAGE “GIF” YG SANGAT MEMBAHAYAKAN

Apakah anda mendapatkan pesan seperti ini lewat broadcast Whatsapp? PESAN YG SANGAT PENTING IMAGE “GIF” YG SANGAT MEMBAHAYAKAN ( Format gambar yg terus berulang )💀☠💀☠💀☠💀☠ Ini adalah permintaan saya kepada semua teman2 saya di Whatsapp.. Tolong Berhenti dan jangan kirim lagi Gambar maupun video dlm bentuk GIF KARENA HAL ITU AKAN MERUSAK/MEMBOROSKAN BATERE DAN JG KUOTA GBs /MBs anda . Seperti yg sdh anda ketahui HP kita sangat bergantung pd Batere dan saat ini banyak model HP yg batere nya…

Read More Read More

Step by step using Microsoft Synchronize SDK for multi client

Step by step using Microsoft Synchronize SDK for multi client

Prepare SQL Server Local Cache Start command prompt Check your localdb version, if you want deploy to 32 bit client, you should use version 12.xx (SQL server 2014 LocalDB) Type sqllocaldb v To check SqlLocalDB Instannce, use sqllocaldb i If you have 2 version, now check your MSSQLLocalDB server version If the version is not version 12.x, you have to create new instance and set version to 12 Now check again your synctestDB instance using correct version (12.0.2000.8) Now you’re…

Read More Read More

[Free Ebook for Today] Cross-platform UI Development with Xamarin.Forms

[Free Ebook for Today] Cross-platform UI Development with Xamarin.Forms

Cross-platform UI Development with Xamarin.Forms Create a fully operating application and deploy it to major mobile platforms using Xamarin.Forms Create standard user interfaces on Windows Mobile, Android, and iOS and then make those interfaces look good with ease Design a full-blown application in very little time with just about the entire code being shared Learn how to access platform-specific features and still have the same core code with this handy guide Download the ebook here

Installing SQL Server on Ubuntu

Installing SQL Server on Ubuntu

Microsoft just launched SQL Server vNEXT CTP1 for Linux, below is tutorial for installing SQL Server on Ubuntu Prerequisites: Internet connection At least Ubuntu 16.04 64bit Here’s the steps to install SQL Server on Ubuntu Import the public repository GPG keys curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add – Add Microsoft SQL Server Ubuntu repository curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list Run commands below sudo apt-get update sudo apt-get install -y mssql-server Once the installation finish, run the script to install…

Read More Read More

Essential Studio 2016 Volume 4 Release v14.4.0.15

Essential Studio 2016 Volume 4 Release v14.4.0.15

Syncfusion just release new version that support Visual Studio 2017 (https://www.syncfusion.com/forums/127486/essential-studio-2016-volume-4-release-v14-4-0-15-is-available-for-download) Direct link for download is here or if you already have community license, just login to your portal and download from there. For Offline documentation for VS 2010/2012/2013/2015/2017 can download here and for VS 2005/2008 can download here