Showing posts with label Microsoft SQL Server. Show all posts
Showing posts with label Microsoft SQL Server. Show all posts
2018/11/10

[SchemaSpy] How to generate SQL Server schema document via SchemaSpy

›
Steps 1. Download SchemaSpy jar from http://schemaspy.org/ 2. Downnload and install Graphviz from https://www.graphviz.org/ 3. Download J...
2018/11/09

[SQL Server] Utilize FOR XML PATH to merge multiple rows into one row

›
Problem Assume I get two rows from the following SQL statement: select t1.CASEID, t1.PID, t1.NAME, t2.QVALUE + CHAR ( 10 ) + t2.AVALU...
2017/10/08

[Oracle to SQL Server Migration] NVL

›
Problem In Oracle, NVL function lets you replace null (returned as a blank) with a string in the results of a query.  If expr1 is nu...
2017/08/07

[SQL Server] How to find similar table / column name by SQL

›
I am using Microsoft SQL Server... If I would like to get a list of table name which table name has %arap% , you can use this SQL statemen...
2016/05/08

How to Get All Sequences in SQL Server

›
Problem If I would like to get all sequences in Microsoft SQL Server, how to do it? How-To You can use this SQL statement to retrieve a...
2016/02/05

[Microsoft SQL Server] Adding Rows by Using INSERT and SELECT

›
Problem Assume I have a function, as user click a button it will copy last year's data and insert data into this year. How to use SQL s...
2016/02/04

[Microsoft SQL Server] How to subtract a year in SQL

›
Problem I have a select SQL statement as bellows: SELECT sta_date FROM dbm031fa WHERE year ( sta_date ) = year ( CURRENT_TIMESTAMP ...
2015/12/07

[Oracle to SQL Server Migration] MINUS

›
Problem Here has a SQL statement which is working fine in Oracle: 1 2 3 4 5 6 7 8 9 select distinct fund_id FROM dbm034fa MINUS s...
2015/12/02

How to utilize Oracle SQL Developer to Connect to Microsoft SQL Server

›
Problem Oracle SQL Developer only support connection to Oracle and Access by default. If I would like to connection to Microsoft SQL Serve...
2015/11/16

[Oracle to SQL Server Migration] ROWNUM

›
Problem We used rownum = 1 in Oracle as bellows: If we migrate to Microsoft SQL Server, how to translate it? 1 2 3 4 5 6 7 8 ...

[SQL Server] Year function

›
Problem Here is my table schema in Microsoft SQL Server. If I would like to retrieve an integer that represents the year of the STA_DATE (w...
2015/10/12

[Oracle to SQL Server Migration] Outer Join

›
In Oracle, we use outer join, (+), in the SQL statement as bellows: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 ...
2015/08/03

[Oracle to SQL Server Migration] Outer Join

›
In Oracle, we use outer join, (+), in the SQL statement as bellows: SELECT A . MGE_TYPE , B . ORG_TYPE , F_DBM_FIND_CODE_N...