Blog Archives

SQL Server Date Formatting and Date Examples

–Get Current Date and Time select getdate() –Date Format MMM DD YYYY select convert(nvarchar(12),getdate(),100) –Date Format MM/DD/YYYY select convert(nvarchar(10),getdate(),101) –Date Format YYYY.MM.DD select convert(nvarchar(10),getdate(),102) –Date Format DD/MM/YYYY select convert(nvarchar(10),getdate(),103) –Date Format DD.MM.YYYY select convert(nvarchar(10),getdate(),104) –Date Format DD-MM-YYYY select convert(nvarchar(10),getdate(),105) –Date

Tagged with: , , , , , ,
Posted in SQL Server

Visual Studio Write to a Text File

Visual Studio C# Write to a File: In order to test this code, do the following: Create a new Windows Application Add a New form Add a textbox to the form; use the default name for the textbox. Make sure to

Tagged with: , , , , ,
Posted in Visual Studio Code Examples

Visual Studio – Add Double Quotes To Text

C# string sText = “This expample shows how to add double quotes to text.”; sText = “\”” + sText + “\””; Visual Basic Dim sText As String = “This expample shows how to add double quotes to text.” sText =

Tagged with: , , ,
Posted in Visual Studio Code Examples