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

Pubblicato il: 08 maggio 2018
sul canale di: 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')

In questa pagina del sito puoi guardare il video online MS SQL Server 2016 course 70-761 - Chapter 8 Using Build-in function - Scalar function della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Learning For All 08 maggio 2018, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 228 volte e gli è piaciuto 3 spettatori. Buona visione!

1,120