Saya ingin mencapai 70 Kg

Oooops gw baru tahu..
Ternyata selama ini di dalam stored procedure (SQL Server 2005),
kita dapat declare variabel dengan tipe data table

-- declare a new TABLE variable
DECLARE @Products TABLE
(ProductID INT,
Name VARCHAR(50),
Description VARCHAR(5000))

dan dapat mengisinya seperti ini..


-- populate the table variable with the complete list of products
INSERT INTO @Products
SELECT ProductID, Name, Description
FROM Product

dan kita dapat ambil data dari object tabel tersebut

-- extract the requested page of products
SELECT Name, Description FROM @Products

Advertisements

Comments on: "Table Variables pada SQL Server 2005" (2)

  1. mykatherine said:

    @anwar chandra
    tlg atur widget gw donk, ilangin “category 3”-nya gmn c?
    trus kok klo ada postingan dikirim ke email lu, bru lu fwrd ke email gw? So, plz setting klo ada postingan kirim ke email gw dl donk..
    trus di Options > general > email address, ganti jd my_katherine@hotmail.com.
    Gw udh coba ganti sendiri, tp ga dikonfim2 ke email gw.

    help!

  2. yang 2000 juga uda bisa kok ndra.. ^-^

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Tag Cloud

%d bloggers like this: