Tutorial by Examples: e

If you want to have a table organized in column-store format instead of row store, add INDEX cci CLUSTERED COLUMNSTORE in definition of table: DROP TABLE IF EXISTS Product GO CREATE TABLE Product ( ProductID int, Name nvarchar(50) NOT NULL, Color nvarchar(15), Size nvarchar(5)...

CREATE CLUSTERED COLUMNSTORE INDEX enables you to organize a table in column format: DROP TABLE IF EXISTS Product GO CREATE TABLE Product ( Name nvarchar(50) NOT NULL, Color nvarchar(15), Size nvarchar(5) NULL, Price money NOT NULL, Quantity int ) GO CREATE CLUSTERED C...

Declare @ObjectName nVarChar(1000) Set @ObjectName = 'HeadOfficeSQL1.Northwind.dbo.Authors' SELECT PARSENAME(@ObjectName, 4) as Server ,PARSENAME(@ObjectName, 3) as DB ,PARSENAME(@ObjectName, 2) as Owner ,PARSENAME(@ObjectName, 1) as Object Returns: ServerDBHeadofficeSQL1NorthwindOwn...

The NotifyPropertyChangedBaseclass below defines a generic Set method that can be called from any derived type. public class NotifyPropertyChangedBase : INotifyPropertyChanged { protected void RaisePropertyChanged([CallerMemberName] string propertyName = null) => PropertyChanged?.Invo...

Erlang on OpenBSD is currently broken on alpha, sparc and hppa architectures. Method 1 - Pre-built Binary Package OpenBSD let you choose desired version you want to install on your system: ###################################################################### # free-choice: ####################...

Consider the following partial example: import com.example.somelib.*; import com.acme.otherlib.*; public class Test { private Context x = new Context(); // from com.example.somelib ... } Suppose that when when you first developed the code against version 1.0 of somelib and versi...

Detailed instructions on getting teradata set up or installed.

In this iText 5 example, we will create a Hello World example in different languages, using different fonts: public void createPdf(String dest) throws DocumentException, IOException { Document document = new Document(); PdfWriter.getInstance(document, new FileOutputStream(dest)); ...

In this iText 7 example, we will create a Hello World example in different languages, using different fonts: public void createPdf(String dest) throws IOException { PdfDocument pdf = new PdfDocument(new PdfWriter(dest)); try (Document document = new Document(pdf)) { PdfFont fon...

You can setup your client browser to listen in incoming server events using the EventSource object. You will need to supply the constructor a string of the path to the server' API enpoint the will subscribe the client to the server events. Example: var eventSource = new EventSource("api/my-ev...

An event stream to the server can be closed using the EventSource.close() method var eventSource = new EventSource("api/my-events"); // do things ... eventSource.close(); // you will not receive anymore events from this object The .close() method does nothing is the stream is already...

In this iText 5 example, we need to switch between different styles in the same document: The best way to do this in iText 5, is to create a convenience method that creates a Chunk in the style that needs to be used frequently; see the createBgChunk() method: public Chunk createBgChunk(String s,...

In this iText 7 example, we need to switch between different styles in the same document: The best way to achieve this in iText 7, is to create a Style object, and to apply that Style to a Text object: public void createPdf(String dest) throws IOException { PdfDocument pdf = new PdfDocument...

There are many ways to communicate with servers using Unity as the client (some methodologies are better than others depending on your purpose). First, one must determine the need of the server to be able to effectively send operations to and from the server. For this example, we will send a few pie...

In this example, we'll create the following table using iText 5: We need the PdfPTable and PdfPCell class to achieve this: public void createPdf(String dest) throws IOException, DocumentException { Document document = new Document(); PdfWriter.getInstance(document, new FileOutputStream...

In this example, we'll create the following table using iText 7: We'll need the Table and Cell class to achieve this: public void createPdf(String dest) throws IOException { PdfDocument pdf = new PdfDocument(new PdfWriter(dest)); try (Document document = new Document(pdf)) { T...

Requirements: PHP 5.6.0 or greater mbstring PHP extension (default works in WAMP/XAMPP, if not then enable it) intl PHP extension (Available in WAMP/XAMPP, you have to enable it from php.ini) CakePHP will run on a variety of web servers such as nginx, LightHTTPD, or Microsoft IIS. Befor...

Suppose that we have the following text file: jekyll_hyde.txt How do we convert it to a PDF that looks like this: When using iText 5, we'd use the following code: public void createPdf(String dest) throws DocumentException, IOException { Document document = new Document(); PdfWriter....

Suppose that you have the following text file: jekyll_hyde.txt How do we convert it to a PDF that looks like this: When using iText 7, we'd need the following code: public void createPdf(String dest) throws IOException { PdfDocument pdf = new PdfDocument(new PdfWriter(dest)); Document...

Suppose that we have the following text file: jekyll_hyde.txt How do we convert it to a PDF that looks like this: When using iText 5, you'd need code like this: public void createPdf(String dest) throws DocumentException, IOException { Document document = new Document(); PdfWriter wr...