asp.net bind drop down list

@Html.DropDownListFor(x => x.itmunit, new List<SelectListItem>

    {

                        new SelectListItem() {Text = "Piece", Value="Piece"},

                        new SelectListItem() {Text = "Box", Value="Box"},

                        new SelectListItem() {Text = "Kg", Value="Kg"},

                        new SelectListItem() {Text = "Litre", Value="Litre"}

    }, new { @class = "form-control" })

Check Performance in sql server

SELECT TOP 10 st.text

               ,st.dbid

               ,st.objectid

               ,qs.total_worker_time

               ,qs.last_worker_time

               ,qp.query_plan

FROM sys.dm_exec_query_stats qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st

CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp

ORDER BY qs.total_worker_time DESC

Find Deadlock in sql server

The only other way I could suggest is digging through the information by using EXEC SP_LOCK (Soon to be deprecated), EXEC SP_WHO2 or the sys.dm_tran_locks table.

SELECT  L.request_session_id AS SPID, 

    DB_NAME(L.resource_database_id) AS DatabaseName,

    O.Name AS LockedObjectName, 

    P.object_id AS LockedObjectId, 

    L.resource_type AS LockedResource, 

    L.request_mode AS LockType,

    ST.text AS SqlStatementText,        

    ES.login_name AS LoginName,

    ES.host_name AS HostName,

    TST.is_user_transaction as IsUserTransaction,

    AT.name as TransactionName,

    CN.auth_scheme as AuthenticationMethod

FROM    sys.dm_tran_locks L

    JOIN sys.partitions P ON P.hobt_id = L.resource_associated_entity_id

    JOIN sys.objects O ON O.object_id = P.object_id

    JOIN sys.dm_exec_sessions ES ON ES.session_id = L.request_session_id

    JOIN sys.dm_tran_session_transactions TST ON ES.session_id = TST.session_id

    JOIN sys.dm_tran_active_transactions AT ON TST.transaction_id = AT.transaction_id

    JOIN sys.dm_exec_connections CN ON CN.session_id = ES.session_id

    CROSS APPLY sys.dm_exec_sql_text(CN.most_recent_sql_handle) AS ST

WHERE   resource_database_id = db_id()

ORDER BY L.request_session_id

Execute Store Procedure with Parameters in SQL SERVER

Try This Example: 

USE [TEST_01_05_2020]

GO

DECLARE @return_value int

EXEC @return_value = [dbo].[SP_OUTBOUNDDELIVERYNOTE]

@MAWB = N'0700000064',

@EXTERNORDERKEY = N'0700000064',

@EXTERNLINENO = N'900001',

@BILLTOKEY = N'''''',

@DELIVERYDATE = N'20191205',

@CONSIGNEEKEY = N'0000005691',

@C_COMPANY = N'Samsonite Philippines (DS)',

@C_ADDRESS1 = N'2/F ENZO Building, 399 Sen. Gi',

@C_ADDRESS2 = N'''''',

@C_ZIP = N'1200',

@C_CITY = N'Makati',

@REFERENCENUM = N'''''',

@ODREFERENCENUM = N'4500581905',

@EXTERNALORDERKEY2 = N'4500581905',

@SKU = N'000000000000033824',

@ALTSKU = N'1041',

@LOTTABLE01 = N'1INU',

@CONVERTEDQTY = 10.00,

@UNITPRICE = 72.03,

@SUSR1 = N'PHP',

@OSUSR1 = N'''''',

@SCHEDULEDDELVDATE = N'20191210',

@ORDERSID = N'''''',

@TRADINGPARTNER = N'''''',

@PACKNOTES = N'''''',

@HUNDREDWEIGHT = 27.330,

@PRODUCT_WEIGHT = 22.670,

@PRODUCT_CUBE = 511.290,

@OSUSR2 = N'CDM',

@RETAILSKU = N'''''',

@NOTES = N'''''',

@CREATEDON = N'20191210',

@TYPE = N'SAL',

@NOTES2 = N'''''',

@OSUSR4 = N'5690',

@OSUSR5 = N'0001'

SELECT 'Return Value' = @return_value

GO

Convert Date in Numeric Format(Remove Separation) In SQL SERVER Query

Try this Query:

SELECT CONVERT(VARCHAR(10),CAST('2019-12-15 00:00:00.000' AS DATE),112) AS date1

Results:- 

        date1

    20191215