How to get date in T-SQL?

From Internet Forum when I browse about SQL:

Another interpretation of the question, “How to get a date in T-SQL?”:

Find out what your database’s interests are, and talk animatedly about them.

Use subtle flattery, “Wow, that’s a really nice stored procedure you got there.”

Don’t overemphasize or show too much interest in physical hardware and specs, most databases consider that shallow and sexist.

Remember that each database is unique, what works well for one may be a total disaster for another.

Always listen. CPU utilization might only be 7%, but that might be a problem for some databases. Be empathetic.

Don’t assume that because everything goes well at first that you’ll be granted full permissions to every part of the database. Work your way up to it, and enjoy the journey. Your database will appreciate the attention.

…and always remember, GetDate() will get you a date, but it may not turn out exactly the way you want it.

SELECT ThePerfectWoman
FROM AllTheWomenInTheWorld
WHERE HerInterests Like Mine
AND CurrentMate Is Null
AND CurrentlyLives IN (‘Jakarta’, ‘Surabaya’)
GROUP BY CASE WHEN AsManyAsWillHaveMe>AsManyAsMyStaminaWillAllow
THEN AsManyAsWillHaveMe ELSE AsManyAsMyStaminaWillAllow * 2 END
HAVING Max(Libido)>=Mine

About dnial

You don't see anything You don't hear anything You don't know anything Move along and pretend nothing happen

Posted on 19 November, 2009, in life. Bookmark the permalink. 6 Komentar.

  1. If you lie to the computer, it will get you.

    Perry Farrar

  2. ||>47413/-\53 633||<. Ga mudeng saya.🙄

  3. Cuma mudeng yang bagian ini…

    SELECT ThePerfectWoman
    FROM AllTheWomenInTheWorld
    WHERE HerInterests Like Mine
    AND CurrentMate Is Null
    AND CurrentlyLives IN (‘Jakarta’, ‘Surabaya’)

    :mrgreen:

    Selebihnya..😕

    *ditendang*

  4. masalahnya saya gak paham SQL
    dan satu lagi, memangnya si perfect woman nya mau diajak dating?

  5. tunggu sebentar…
    situ sudah masukin semua datanya? saya ndak yakin…soalnya AllTheWomenInTheWorld

    atau situ punya petugas input data?:mrgreen:

  6. Ah, masak filternya cuma segitu doang? kolom religion nggak ikut? Terus kok nggak di outer join sama tabel Wealth sama Familiy? (evilsmirk)

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: