select * Table t where t.id = 1 and (@type <> 0 OR t.name = 'something')
Dim strDDiff As String = ddiff.ToString Dim intIdx As Int16 intIdx = strDDiff.IndexOf(".") '<= decimal separator depends on localization!!! strDDiff = strDDiff.Substring(intIdx, strDDiff.Length - 1) Y = ThisDate.Year.ToString & strDDiff
restultString = ThisDate.Year.ToString() & ddiff.ToString("SpecificFormatHere")
int inp = 4; int term = 9; int temp = term; int total = term; for(int i=0; i<inp; i++) { temp *= 10; temp += term; Console.WriteLine($"current={total}; next={temp}"); total += temp; }
SELECT tt.Evnt_GUID, tt.Transactiontimestamp, je.* FROM TestTrasncstion tt(NOLOCK) LEFT JOIN ( SELECT Evnt_GUID , StartTime = MIN(CASE WHEN SpecialEventName_s='Job Started' THEN TimeGenerated ELSE NULL END) , StopTime = MAX(CASE WHEN SpecialEventName_s='Job Stopped' THEN TimeGenerated ELSE NULL END) FROM JobsEvents GROUP BY Evnt_GUID WHERE SpecialEventDescription_s like '%GUID%' ) je (NOLOCK) ON tt.Evnt_GUID = je.Evnt_GUID AND tt.Transactiontimestamp BETWEEN je.StartTime and je.StopTime ORDER BY 2
join
Dim clipNumbers = clipboarddata.Split(New String(){Microsoft.VisualBasic.vbNewLine}, StringSplitOptions.RemoveEmptyEntries) _ .Select(Function(x) Convert.ToInt32(x)) _ .OrderByDescending(Function(x) x) _ .ToList()
update d set d.[validation]=case when d3.Output >0 then 'Yes' else 'No' end
Dim mystring As String = Me.TextBox1.Text.Substring(0, 3)
return listModel.Distinct().Take(3);
return 666;
Submit an article or tip