MulaiMulai sekarang secara gratis

Declare multiple variables

You've seen how to DECLARE and SET set 1 variable. Now, you'll DECLARE and SET multiple variables. There is already one variable declared, however you need to overwrite this and declare 3 new ones. The WHERE clause will also need to be modified to return results between a range of dates.

Latihan ini adalah bagian dari kursus

Introduction to SQL Server

Lihat Kursus

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

-- Declare @start


-- SET @start to '2014-01-24'
Edit dan Jalankan Kode