Access modifiers in C#:
public, protected, internal, and private.
Public access means accessible by any code.
Protected access enables access for all derived classes.
Internal access enables access from any code in the same assembly.
Private access is limited to code in the same class.
Xamarin acquired by Microsoft
Now it is a part of Visual Studio
Replace multiple space with single space – SQL Server
DECLARE @Temp TABLE (OriginalString VARCHAR(8000))
INSERT INTO @Temp (OriginalString)
SELECT ‘ Hello. This is Hello World. ‘
SELECT REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(OriginalString)), ‘ ‘, ‘ ‘ + CHAR(7)), CHAR(7) + ‘ ‘, ”), CHAR(7), ”) AS [result]
WHERE CHARINDEX(‘ ‘, OriginalString) > 0
Split a delimited string AND LOOP through
DECLARE @Id VARCHAR(50)
SET @Id = ‘51,52,61,75,95’
WHILE LEN(@Id) > 0
PRINT LEFT(@Id, CHARINDEX(‘,’, @Id + ‘,’) – 1)
–Your SP Code
SET @Id = STUFF(@Id, 1, CHARINDEX(‘,’, @Id + ‘,’), ”)
Mistake #1: Incorrect references to this
Mistake #2: Thinking there is block-level scope
Mistake #3: Creating memory leaks
Mistake #4: Confusion about equality
Mistake #5: Inefficient DOM manipulation
Mistake #6: Incorrect use of function definitions inside for loops
Mistake #7: Failure to properly leverage prototypal inheritance
Mistake #8: Creating incorrect references to instance methods
Mistake #9: Providing a string as the first argument to setTimeout or setInterval
Mistake #10: Failure to use “strict mode”