local_offer SQL Server local_offer Java local_offer kerberos local_offer NTLM
With Microsoft SQL Server JDBC driver, you can connect to the database through SQL Server Authentication or Kerberos Authentication. This post summarizes the configurations required for each authentication method with coding examples. *NTLM block in the following diagram represents pure Jav...
local_offer SQL Server local_offer hive
In one of my previous post, I showed how to configure Apache Hive 3.0.0 in Windows 10. Apache Hive 3.0.0 Installation on Windows 10 Step by Step Guide ...
local_offer SQL Server local_offer python local_offer spark local_offer pyspark
Spark is an analytics engine for big data processing. There are various ways to connect to a database in Spark. This page summarizes some of common approaches to connect to SQL Server using Python as programming language. ...
local_offer SQL Server local_offer spark local_offer hdfs local_offer parquet local_offer sqoop
This page shows how to import data from SQL Server into Hadoop via Apache Sqoop. Prerequisites Please follow the link below to install Sqoop in your machine if you don’t have one environment ready. ...
local_offer SQL Server local_offer lite-log
If you have used Visual Studio Code, you probably will also enjoy a new client tool SQL Operations Studio. Currently it is available as preview version and not formally released yet. What is SQL Operations Studio SQL Operations Studio is a data management tool that enables working w...
local_offer SQL Server local_offer zeppelin
This page demonstrates the steps you need to connect to SQL Server in Zeppelin. There are many ways to implement this, for example SQL Server interpreters in GitHub. In this page, I am going to use the JDBC driver to connect to SQL Server instead of using third party interpreters. For authe...
local_offer teradata local_offer t-sql local_offer mssql local_offer SQL local_offer SQL Server
Tutorial –1 For Teradata developers, if you have no SQL Server installed, please go to the following link to download the SQL Server 2014 Expression Edition. ...
local_offer SQL local_offer SQL Server local_offer t-sql local_offer teradata
SELECT is one of the most commonly used statements. In this tutorial, I will cover the following items: Two of the principal query clauses—FROM and SELECT Data Types Built-in functions CASE expressions and variations like ISNULL and COALESCE. * The functio...
我们都知道在一个表中当需要2列以上才能确定记录的唯一性的时候，就需要用到联合主键，当建立联合主键以后，在查询数据的时候性能就会有很大的提升，不过并不是对联合主键的任何列单独查询的时候性能都会提升，但我们依然可以通过对联合主键中的首列除外的其他列建立非聚集索引来提高性能。关于索引，可以参考我的这篇文章：http://hi.baidu.com/1987raymond/blog/item/a0f7b11062e1330a213f2e26.html。
个人感觉这个存储过程写得比较的好：转载自：http://www.cnblogs.com/eme/archive/2006/12/19/597275.html