Archive for September 2019

Catat_tampil 03.17 Add Comment SQL SERVER, T-SQL Edit

T-SQL Example

begin print'hello world'; end begin declare @var int; --OR declare @var1 int = 200; set @var = 100 print @var; pri...

T-SQL sql server

T-SQL 1 Tutorials Point (India) Pvt. Ltd. https://www.youtube.com/watch?v=f93sYcdhg8Y 2 https://www.youtube.com/watch?v=V4hTLj...

Catat_tampil 20.39 Add Comment Oracle Edit

sql deveoper oracle

https://winapujiblog.wordpress.com/2018/01/16/belajar-oracle-11g-dan-sql-developer/

Catat_tampil 20.37 Add Comment SSIS Edit

conditional split / if then else

simple conditional split / if then else https://www.youtube.com/watch?v=skrEGUzQ0eg https://www.youtube.com/watch?v=dbqEsM0Ehx...

Catat_tampil 00.14 Add Comment SSIS Edit

lookup ssis

https://www.red-gate.com/simple-talk/sql/ssis/implementing-lookup-logic-in-sql-server-integration-services/

Catat_tampil 21.11 Add Comment SSIS Edit

learning url SSIS

1 row count https://www.tutorialgateway.org/row-count-transformation-in-ssis/#targetText=Row%20Count%20Transformation%20in%20SSIS&tar...

Catat_tampil 10.25 Add Comment SQL SERVER, SQL SERVER issue Edit

url bageshkumarbagi mssqltips

http://bageshkumarbagi-msbi.blogspot.com/2019/09/maximum-insert-commit-size-option-in.html https://www.mssqltips.com/sqlservertip/1070/si...

Catat_tampil 10.02 Add Comment SQL SERVER, SQL SERVER issue Edit

eksport all databases sql server

https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/ DECLARE @name VARCHAR ( 50 ) -- databas...

Catat_tampil 02.53 Add Comment SSIS Edit

import-and-export-packages-ssis, dan ssis services

https://docs.microsoft.com/en-us/sql/integration-services/import-and-export-packages-ssis-service?view=sql-server-2014 https://stackoverf...

Catat_tampil 02.33 Add Comment SSIS Edit

increase maximumerrorcoun ssis sql server

https://blogs.msdn.microsoft.com/sqlblog/2010/12/31/have-you-checked-the-maximumerrorcount-in-your-ssis-package/ klik di tasknya --> ga...

Catat_tampil 02.30 Add Comment SQL SERVER Edit

copy database attach-detach

https://dewadewonah.wordpress.com/2017/04/19/cara-copy-database-dari-sql-server-attach-detach/

Catat_tampil 02.29 Add Comment SQL SERVER Edit

delete primary key sql server

https://stackoverflow.com/questions/737152/how-to-disable-primary-key-constraint-programmatically ALTER TABLE mytable DROP CONSTRAINT...

Catat_tampil 20.55 Add Comment SSIS Edit

SSIS, SSAS, SSRS

http://bageshkumarbagi-msbi.blogspot.com/2016/02/remove-duplicate-records-in-ssis-package.html

Catat_tampil 03.18 Add Comment random Edit

get sid

https://www.windows-commandline.com/get-sid-of-user/

Catat_tampil 15.11 Add Comment Edit

ssdt tools

https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation?view=sql-server-2017

Catat_tampil 21.29 Add Comment SQL SERVER Edit

peletakan group by having count

select city, COUNT(city) as jumlah FROM sales.customers group by city having count(city) > 3 ORDER BY jumlah ASC

Catat_tampil 21.02 Add Comment SQL SERVER Edit

belajar SQL SERVER

http://www.sqlservertutorial.net/sql-server-sample-database/ https://www.quackit.com/sql_server/sql_server_2014/tutorial/query_designer.cf...

Catat_tampil 03.41 Add Comment SQL SERVER Edit

query catat nilai max dari setiap kolom seri

SELECT TOP 1000 [id] ,[Seri1] ,[Seri2] ,[Seri3] FROM [TES].[dbo].[SeriesData] ------------------------ GO SEL...

Catat_tampil 03.13 Add Comment SQL SERVER Edit

case when case-transact-sql

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql?view=sql-server-2017

Catat_tampil 02.49 Add Comment DataStage Edit

dataStage

https://github.com/jdelvign/datastage2docker docker db2 https://www.ibm.com/support/knowledgecenter/en/SSZLC2_9.0.0/com.ibm.commerce.ins...

Catat_tampil 21.41 Add Comment ETL Edit

ETL TESTING

https://www.tutorialspoint.com/etl_testing/etl_testing_quick_guide.htm ETL Testing – Categories ETL Testing – Challenges ETL – Tester...

Catat_tampil 09.20 Add Comment SQL SERVER Edit

begin di dalam begin sql server

https://stackoverflow.com/questions/45317170/how-to-use-begin-transaction-with-while-loop-in-sql-server

Catat_tampil 07.42 Add Comment SQL SERVER Edit

perulangan sql server , while, nested while (loop)

http://working-log.blogspot.com/2013/06/cara-membuat-looping-pada-sql-server.html http://www.blackwasp.co.uk/SQLWhile.aspx nested h...

Catat_tampil 00.57 Add Comment SQL SERVER Edit

Collate collation sql server

MSDN collate sql server --------------------------------------------------------------------- https://docs.microsoft.com/en-us/sql/t-sql...

Catat_tampil 21.04 Add Comment SQL SERVER Edit

function trigger sql server

function https://ndereklangkung.wordpress.com/2009/12/23/sql-membuat-functions-sederhana-di-sql-server/ https://belajarquery.wordpress....