Question of the month November 2017 – How do leading dots of table work in SQL Server?

In SQL Server, let us consider the following data set

create table test(number int);
insert into test(number)
select 10;

Now execute the following query

select * from ...test

The result is 10

The question is “How do leading dots of table work in SQL Server?”

MySQL – Functions to get current date and time

You may often need to do some data filters based on the current date and time. In MySQL you can use the system functions available to get current date and time.

Refer the following examples.

1 Get current date

SELECT CURRENT_DATE() AS today_date

or

SELECT CURDATE() AS today_date

The result is

2017-11-20

2 Get current time

SELECT CURRENT_TIME() AS today_time

or

SELECT CURTIME() AS today_time

The result is

08:36:29

3 Get Current Date and time

SELECT NOW() AS today_date_time

The result is

2017-11-20T08:36:29Z

MySQL – How to create random number with fixed length?

Please note that this post is available now at https://exploresql.com/2017/11/06/mysql-how-to-create-random-number-with-fixed-length/