Andrew Kuprianov

20 tips on converting MySQL views to MS SQL

This article gives 20 tips how to modify MySQL views to make it compatible with Microsoft SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(23)

You rated this post out of 5. Change rating

2012-05-02

4,087 reads

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...

la guadière – n. a glint of goodness you notice in something that you...

Tlp/Wa_Cs:0817-866-887. Jl. Rawasari Sel. No.24 A, RT.12/RW.9, Rawasari, Kec. Cemp. Putih, Kota Jakarta Pusat,...

Tlp/Wa_Cs:0817-866-887. Jl. Taman Aries Blok E1 No. 2A & 2 B, RT.12/RW.8, Meruya Utara,...

Tlp/Wa_Cs:0817-866-887. Jl. Sumber Sari No.23 T 12, Babakan, Kec. Babakan Ciparay, Kota Bandung, Jawa...

I run the SQLCMD utility as follows:

lcmd -S localhost -E

I then type this (the 1> is the prompt):

1> select @@version go

If I hit enter, what happens?