Exponent operator in javascript

const data = 2 ** 4;

//same as :Math.pow(2,4);

console.log(data);

Output:

16           

Github link : https://github.com/adi501/JavaScriptExamples.git

 

Template string in javascript

const name = "world";

const message = `Hello ${name}`;

console.log(message);

Output:

Hello world           

Github link : https://github.com/adi501/JavaScriptExamples.git

Multiline string example in Javascript

console.log(`

this is a

multiline string

example`);

Output:

this is a 

multiline string 

example           

Github link : https://github.com/adi501/JavaScriptExamples.git

Default parameters in javascript

function print(a = 100) {

console.log(a);

}

print();

print(200);

Output:

100

200            

Github link : https://github.com/adi501/JavaScriptExamples.git

Arrow function in javascript

const sum = (a, b) => a + b;

console.log(sum(2, 5));

Output: 7

Github link : https://github.com/adi501/JavaScriptExamples.git

 

How to find recently executed queries in SQL Server

select dest.text as Query,deqs.last_execution_time 

from sys.dm_exec_query_stats as deqs

cross apply sys.dm_exec_sql_text(deqs.sql_handle) as dest

order by deqs.last_execution_time desc

(or)

select dest.text as Query,deqs.last_execution_time 

from sys.dm_exec_query_stats as deqs

cross apply sys.dm_exec_sql_text(deqs.sql_handle) as dest

where dest.text like '%dm_exec_query_stats%'

order by deqs.last_execution_time desc