Tag Archives: Ms. SQL

SQL: Insert Field Auto-Number

07 Tuesday Sep 2004

Posted by in Database, Pemrogramman

≈ 1 Comment

Tags

, ,

Sering kita menemui kesulitan didalam menyusun query untuk mendapatkan hasil yang diinginkan, tetapi kadang juga kita menemui kemudahan didalam menggunakan query.

Saat ini saya akan memecahkan suatu masalah yang mungkin juga sering dihadapi oleh rekan2 programmer khususnya yang menggunakan database Microsoft SQL, baik pemula maupun senior programmer. Anda pernah berpikiran atau menginginkan suatu field tambahan muncul dalam query? jawaban pasti ya dan itu mudah sekali… bukan? Hanya memberikan syntak AS namaField… selesai sudah. :)

Bagaimana jika anda diminta untuk memunculkan satu field bersifat auto, seperti type data Auto-Number ?.

Anda ingin mengetahui solusinya… mari kita bahas:

Continue reading »

How to Search for Date and Time Values Using Microsoft SQL Server 2000

17 Friday Oct 2003

Posted by in Database

≈ Leave a Comment

Tags

, ,

Before you can effectively query date/time (or temporal) data, you have to know something about how date/time values are stored. SQL Server supports two date/time data types: datetime and smalldatetime. This article explains in detail the differences between the two, talks about the performance effect of database design on querying, and teaches how to search by time and by time.

by Bryan Syverson, author of  Murach’s SQL for SQL Server

Suppose you’re writing a query to find all the invoices that were written on January 6, 2003. You know from the control totals that 122 invoices were written that day. But when you run this query:

SELECT * FROM Invoices
       WHERE InvoiceDate = '2003-01-06' the result set is empty. What’s going on?

How dates and times are stored in SQL Server

Continue reading »