Андрей Ласточкин

this.Text = string.Format("current thread #{0}",
                Thread.CurrentThread.ManagedThreadId);

var text =  string.Format("current thread #{0}", Thread.CurrentThread.ManagedThreadId);
this.Invoke(()=> Text = text);

ins = new SqlCommand("INSERT INTO [User] (Имя, Фамилия, Группа) VALUES (" +

private async void Callback(BrokeredMessage receivedMessage)
{
CallbackPrim(receivedMessage).Wait(); // НЕ await!
}

private async void CallbackPrim(BrokeredMessage receivedMessage)
{
   ///... некоторый код опущен
  
   await BusinessLayer.DoSomeWork1(arg);

   await BusinessLayer.DoSomeWork2(arg);

   await _commandQueueClient.SendAsync(new BrokeredMessage(data));  

   receivedMessage.Complete(); 
}

SELECT uName, 
(
SELECT MIN(uDate) 
FROM Res 
WHERE uName = T.uName AND CAST(uDate AS Date) = D
) FirstDate
FROM 
(
SELECT DISTINCT uName, CAST(uDate AS Date) D
FROM Res
) T

... .Split(new [] {' ', ',', '.', ':', '\t', '\n'}, StringSplitOptions.RemoveEmptyEntries) ...

AppDomain.CurrentDomain.UnhandledException 
       += (_, e) => Environment.FailFast("", e.ExceptionObject as Exception);

SELECT DISTINCT article.name
FROM article
INNER JOIN prop2article P1 ON article.id = P1.article_id
INNER JOIN prop2article P2 ON article.id = P2.article_id
WHERE
  (P1.prop_id = 1 and P1.prop_value_id = 1)
  AND
  (P2.prop_id = 2 and P2.prop_value_id = 3)

void MyFunc(string func, params object[] args)
{
        var argTypes = Type.GetTypeArray(args);
        var methodInfo = this.GetType().GetMethod(func, argTypes);
        methodInfo.Invoke(this, args);
}
        ...
        MyFunc("M2", 5, "строка");

...
        if (reader.Read())
        {
            Response.Write(reader["id"]);
            Response.Write(reader["level"]);
        }

        var ok = reader.NextResult(); // <---

        if( !ok ) return;

        if (reader.Read())
        {
            Response.Write(reader["lid"]);
            Response.Write(reader["sublid"]);
        }
...

update cred_zaborg 
set Suma_zaborg = kurs*Suma_zaborgVAL
from cred_zaborg 
inner join credit_rah on Credit_Rah.Credit_rah=Cred_zaborg.Credit_rah
inner join valuta  on Credit_Rah.Valuta_name=Valuta.Valuta_code

CREATE PROCEDURE usp_DropNonUsedTables @LastDateUse date
AS
BEGIN

    SET NOCOUNT ON

    DECLARE @TablesWithLastSeek AS TABLE (
        TableName varchar(100),
        LastAccessDate date
    );

    WITH LastDates
    AS (SELECT
        SCHEMA_NAME(T.schema_id) + '.' + OBJECT_NAME(T.object_id) AS TableName,
        (SELECT
            MAX(last_user_date)
        FROM (VALUES (last_user_seek), (last_user_scan), (last_user_lookup)) AS AllValues (last_user_date))
        AS AccessDate
    FROM sys.dm_db_index_usage_stats IUS
    RIGHT OUTER JOIN sys.tables T
        ON IUS.object_id = T.object_id)

    INSERT INTO @TablesWithLastSeek
        SELECT
            TableName,
            MAX(AccessDate)
        FROM LastDates
        GROUP BY TableName
        HAVING MAX(AccessDate) <= @LastDateUse

    DECLARE @TableName varchar(100)
    DECLARE @LastAccessDate date
    DECLARE @Command varchar(1000)

    DECLARE C CURSOR LOCAL FOR
    SELECT
        *
    FROM @TablesWithLastSeek

    OPEN C

    WHILE 1 = 1
    BEGIN
        FETCH C INTO @TableName, @LastAccessDate
        IF @@FETCH_STATUS != 0
            BREAK

        SET @Command = 'DROP TABLE ' + @TableName + ';'
        EXECUTE (@Command)
    END

    CLOSE C
	
END;
GO