#SQL script

SQLServerCentral Article

SQL Window Functions Series: NTILE()

  • Article

Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.

(3)

You rated this post out of 5. Change rating

2024-02-03 (first published: )

5,207 reads

SQLServerCentral Article

SQL Window Functions Series: LAG() and LEAD()

  • Article

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

(3)

You rated this post out of 5. Change rating

2023-12-11

10,708 reads

SQLServerCentral Article

(4)

You rated this post out of 5. Change rating

2023-11-20 (first published: )

15,706 reads

SQLServerCentral Article

Different Ways to Populate the List of Tables

  • Article

This article shows how you can query different types of tables, based on certain criteria that may be important to you. A good list of basics for any database administrator that will help you find tables in your database.

(1)

You rated this post out of 5. Change rating

2023-10-06

1,954 reads

Blogs

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

By

I’ve had a Dropbox account for years. Like a lot of people, I started...

KDA: Echoes of Deception - Case 4

By

Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...

EightKB 2026 – Schedule and Registration

By

Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...

Read the latest Blogs

Forums

BCA KCU BLITAR Telp/WA:0817839777

By R4nt4u

Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111

BCA KCU DIPONEGORO Telp/WA:0817839777

By layanan_Bca88

Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241

BCA KCU JOMBANG Telp/WA:0817839777

By m4rt1n4

Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415

Visit the forum

Question of the Day

Displaying Money

I want to get the currency sign displayed with my amount stored in a money type. Does this work?

DECLARE @Amount MONEY;
SET @Amount = '?1500';

SELECT CAST( @Amount  AS VARCHAR(30)) AS Euros

See possible answers