Catatan

Stored Procedure MSSQL

Imej
Nota Ringkas List nota Code Sample Code Description Rujukan SET LOCK_TIMEOUT (Transact-SQL) sp_testlinkedserver (Transact-SQL)

Date and Time Conversions Using SQL Server

Rujukan :  Date and Time Conversions Using SQL Server https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/ SQL Server CONVERT() Function https://www.w3schools.com/sql/func_sqlserver_convert.asp

How to create and configure a linked server in SQL Server Management Studio

Imej
Hi... Rujukan :  How to create and configure a linked server in SQL Server Management Studio https://www.sqlshack.com/how-to-create-and-configure-a-linked-server-in-sql-server-management-studio/

Error datetime mssql

Imej
 

mssql after install server name for localhost does not exist

Imej
Cannot connect to SQL Server | how to fix cannot connect to MS SQL Server error Rujukan : https://www.youtube.com/watch?v=YS0YC_U_3sA

Difference between DataReader, DataSet, DataAdapter and DataTable in C#

Difference between DataReader, DataSet, DataAdapter and DataTable in C# and VB.Net Rujukan :  https://www.aspsnippets.com/Articles/Difference-between-DataReader-DataSet-DataAdapter-and-DataTable-in-C-and-VBNet.aspx

How to configure remote access and connect to a remote MS SQL

Imej
Hi... How to configure remote access and connect to a remote SQL Server instance with ApexSQL tools Rujukan : https://knowledgebase.apexsql.com/configure-remote-access-connect-remote-sql-server-instance-apexsql-tools/