MS SQL Server 2016 course 70-761 - Chapter 8 Using Build-in function - Scalar function

Published: 08 May 2018
on channel: Learning For All

228

دوره تعليمية أكاديمية للتأهل لشهادة MCSA رقم 761-70
تعتمد كل المنهج المعتمد من ميكروسوفت

Chapter 8 Using Build-in function - Scalar function

All Build-in function
https://docs.microsoft.com/en-us/prev...)

Conversion function
https://docs.microsoft.com/en-us/sql/...

select @@DATEFIRST
SET Language Arabic
select @@DATEFIRST

select @@SERVERNAME

select @@LANGUAGE
set language Arabic
select @@LANGUAGE

select abs(-25)

select round(345.7654,2)

select DB_NAME (), file_name(2)

select index_col(N'tsql.hr.employees',1,1)
select INDEX_COL (N'tsql.HR.Employees',2,1 )

select orderid,orderdate AS OrderDateTime, CAST(orderdate AS date) AS OrderDate, cast(SYSDATETIME() AS int) AS MyDate
from sales.orders

select try_convert(datetime2, '20181331')
select try_cast('20181531' AS datetime2)
select try_parse('01/01/2018' AS datetime2)

select convert(datetime2 , '14390822',130)
select parse('1439/08/22' as datetime2 using 'ar-sa')

On this page of the site you can watch the video online MS SQL Server 2016 course 70-761 - Chapter 8 Using Build-in function - Scalar function with a duration of hours minute second in good quality, which was uploaded by the user Learning For All 08 May 2018, share the link with friends and acquaintances, this video has already been watched 228 times on youtube and it was liked by 3 viewers. Enjoy your viewing!

1,120