Browsed by
Category: Development

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

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

[Direct link] MS SQL Server 2016 Service Pack 1

[Direct link] MS SQL Server 2016 Service Pack 1

Microsoft just release the first service pack for MS SQL Server, with some improvement as mention here The following table compares the list of features which were only available in Enterprise edition which are now enabled in Standard, Web, Express, and LocalDB editions with SQL Server 2016 SP1. This consistent programmatically surface area allows developers and ISVs to develop and build applications leveraging the following features which can be deployed against any edition of SQL Server installed in the customer…

Read More Read More

Create Visual Studio 2017 RC Offline Installer

Create Visual Studio 2017 RC Offline Installer

Microsoft just launched new version of Visual Studio 2017 (previously it’s called Visual Studio 15) with the lightweight installer For some users are good since they have enough bandwidth to download it, but for limited bandwidth and needs to install to several computers, it’s the problem. But, don’t worry, there’s a way to download it and you can distribute to another computers without internet connection. Download the installer here Use the following switch or argument below (using two dash) –layout…

Read More Read More

Visual Studio 15 New Installer and problem solving

Visual Studio 15 New Installer and problem solving

In this new release, Microsoft introduce new installer of Visual Studio, it’s faster than Visual Studio 2015 installer. To download the installer, click here. The new installer almost like a web platform installer. Below is the step by step to use this new installer Double click vs_bootstrapper.exe Klik Install Wait until the Installer gets the update Once the installer check for updates, you’re ready to install You can specific install the component to install and it’s faster than the previous…

Read More Read More

Visual Studio 15 Preview 3

Visual Studio 15 Preview 3

Microsoft just launched the next version of Visual Studio, it’s Visual Studio 15 Preview 3. Download link is here https://go.microsoft.com/fwlink/?LinkId=746567 From the release notes, some improvement in this version are: The very first launch of Visual Studio is 30-35% faster The version control status bar makes it easier to publish local repos to an SCC host and keep track of uncommitted and un-pushed work. New Visual Studio “15” Feature: Open Folder Open Folder is a convenient way to navigate code…

Read More Read More