select *into <destination_database.dbo.destination table> from _
<source_database.dbo.source table> where 1 = 2

Select *,ROW_NUMBER() OVER (PARTITION BY Product ORDER BY Price DESC) AS RN from Test

RANK () OVER ([<partition_by_clause>] <order_by_clause>)

Select *,RANK() over (ORDER BY Price ) AS RANK from Test

Select *,RANK() over (Partition by Product ORDER BY Price Desc) AS RANK from Test

Select *,dense_RANK() over (ORDER BY Price ) AS dense_RANK from Test

NTILE (integer_expression) OVER ([<partition_by_clause>] <order_by_clause>)

Select * ,NTILE(4) over ( ORDER BY Price desc) from Test

Select *,NTILE(3) over ( ORDER BY Price desc) AS NTILE from Test                              

Create Table FindField
(ID int,
Firstname varchar(255),
Lastname varchar(255))
Go
CREATE PROCEDURE PROCEDURE_FindField
AS
    SELECT Firstname FROM FindField;
GO
CREATE FUNCTION FUNCTION_FindField (@id int)
RETURNS int
WITH EXECUTE AS CALLER
AS
begin 
declare @id1 int;
   set @id1= (Select Max(Firstname) from dbo.FindField) ;
   RETURN (@id1);
END;

SELECT OBJECT_NAME(object_id) as 'Procedure/Function/View Name',
definition
FROM sys.sql_modules
WHERE definition LIKE '%' + 'Firstname' + '%'

Declare
@x int,
@y int

Set @x = 1
If (@x + @y = 1)
BEGIN
  print 'yes!'
End

Set @y = (select sum(id) from Account)
If @x + @y = 1
BEGIN
  print 'yes!'
End

CREATE TABLE #tableA
(
column1  INT,
column2  INT
)

INSERT INTO #tableA
VALUES
(1,1)
,(1, 2)
,(1, 3)
,(2, 1)

SELECT column1,
     column2
FROM   #tableA

CREATE TABLE #tableB
(
column1  INT,
column2  INT
)

INSERT INTO #tableB
VALUES
(1,1)
,(1, 3)
,(2, 2)
   
SELECT column1,
     column2
FROM   #tableB

#tableA
column1   column2
-----------  -----------
1               1
1               2
1               3
2               1


#tableB
column1   column2
-----------  -----------
1              1
1              3
2              2

SELECT column1,
     column2
FROM   #tableA
WHERE  NOT EXISTS (
         SELECT *
         FROM   #tableB
         WHERE  #tableA.column1 = #tableB.column1
                AND #tableA.column2 = #tableB.column2
     )

column1   column2
-----------  -----------
1               2
2               1

SELECT column1, column2 FROM #tableA
EXCEPT
SELECT column1, column2 FROM #tableB

column1   column2
-----------  -----------
1               2
2               1

ALTER DATABASE myDB SET READ_WRITE

DECLARE @str1 VARCHAR(4),
    @str2 NVARCHAR(4)

--متن یونیکد اینجا ناقص ذخیره می‌شود
SET @str1 = 'وحید' 

SET @str2 = N'وحید'

SELECT hashbytes('md5', @str1) --C82A7D721AAE517AD76EF1B871BC33CE

SELECT hashbytes('md5', @str2) --7D883091B80F3CD20B872CADBFDDACDF

using System.Text;
using System.Security.Cryptography;

class CHash
{
public static string GetMD5Hash(string input, Encoding encoding)
{
    byte[] bytes = new MD5CryptoServiceProvider().ComputeHash(encoding.GetBytes(input));
    StringBuilder chars = new StringBuilder();
    foreach (byte chr in bytes)
    {
        chars.Append(chr.ToString("x2"));
    }
    return chars.ToString();
}
}

string result = CHash.GetMD5Hash("وحید", Encoding.Unicode);

Insert into tblTest(f1,f2) values(1,N'متن فارسی')

<div align="center"><table border="1" width="95%" dir="rtl" cellspacing="0" cellpadding="0"  style="font-family: Tahoma; font-size: 8pt" bordercolor="#660066"><tr><td bgcolor="#FFF9FF"><blockquote><p align="justify"><br>????? ????? ?<br>???? ???? ? ????? ?????? ??? ?? ????? ????? ?????. ???? ??? ???? ???? ????? ????? ????? ????? ????? ??? ??? ???? ???? ?????? ? ???? ?? ????? ???? ???? ??? ????? ??????.<br>???? ??? ????? ???? ?? ?????? ???? ????? ?????? ????? ? ?? ???? ???????? ????? ???? ???? ???? ?????? ???? ???? ??? ?? ????? ????.</blockquote></td></tr></table></div>

DECLARE @msg NVARCHAR(max)
SET @msg=N'متن فارسی'

SELECT * from sysmail_allitems
SELECT * from sysmail_faileditems
SELECT * from sysmail_event_log