{"id":71948,"date":"2024-08-02T23:12:40","date_gmt":"2024-08-02T19:42:40","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/how-to-remove-duplications-on-tsql-2akh\/"},"modified":"2024-08-02T23:12:40","modified_gmt":"2024-08-02T19:42:40","slug":"how-to-remove-duplications-on-tsql-2akh","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/how-to-remove-duplications-on-tsql-2akh\/","title":{"rendered":"\u0646\u062d\u0648\u0647 \u062d\u0630\u0641 \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 TSQL"},"content":{"rendered":"

Summarize this content to 400 words in Persian Lang
\n \u0647\u0645\u06cc\u0634\u0647 \u0634\u0631\u0627\u06cc\u0637\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u0628\u0627\u06cc\u062f \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u062f\u0631 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062e\u0648\u062f \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645. \u06cc\u06a9 \u0631\u0627\u0647 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0686\u0646\u062f \u0645\u0646\u0638\u0648\u0631\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0645\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u0632 \u0645\u0646\u0628\u0639 \u0642\u0633\u0645\u062a \u0633\u0648\u0645 \u0628\u0647 \u0627\u06cc\u0646 \u0634\u06a9\u0644 \u0648\u0627\u0631\u062f \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645.<\/p>\n

\u00ab\u0627\u06af\u0631 OBJECT_ID (N'tempdb..#Product\u00bb) \u062a\u0647\u06cc \u0646\u06cc\u0633\u062a\u0634\u0631\u0648\u0639\u0645\u06cc\u0632 \u0642\u0637\u0631\u0647 #\u0645\u062d\u0635\u0648\u0644\u067e\u0627\u06cc\u0627\u0646\u0627\u06cc\u062c\u0627\u062f TABLE #\u0645\u062d\u0635\u0648\u0644 (\u0646\u0627\u0645 VARCHAR(100),\u0634\u0631\u062d VARCHAR(255));<\/p>\n

INSERT INTO #Product(Name, Description) VALUES ('Entity Framework Extensions', 'Entity Framework Extensions Description.');INSERT INTO #Product(Name, Description) VALUES ('Dapper Plus', 'Dapper Plus Description.');INSERT INTO #Product(Name, Description) VALUES ('C# Eval Expression', 'C# Eval Description');INSERT INTO #Product(Name, Description) VALUES ('Entity Framework Extensions', 'Entity Framework Extensions Description.');INSERT INTO #Product(Name, Description) VALUES ('Dapper Plus', 'Dapper Plus Description.');INSERT INTO #Product(Name, Description) VALUES ('C# Eval Expression', 'C# Eval Description');'<\/p>\n

\u0686\u06af\u0648\u0646\u0647 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u06cc\u0645:<\/p>\n

(SELECT Name ,ROW_NUMBER() over (partition by Name order by Name) RowNumber FROM #Product) a where a.RowNumber = 1;<\/p>\n

\n

\u0647\u0645\u06cc\u0634\u0647 \u0634\u0631\u0627\u06cc\u0637\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u0628\u0627\u06cc\u062f \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u062f\u0631 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062e\u0648\u062f \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645. \u06cc\u06a9 \u0631\u0627\u0647 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0686\u0646\u062f \u0645\u0646\u0638\u0648\u0631\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0645\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u0632 \u0645\u0646\u0628\u0639 \u0642\u0633\u0645\u062a \u0633\u0648\u0645 \u0628\u0647 \u0627\u06cc\u0646 \u0634\u06a9\u0644 \u0648\u0627\u0631\u062f \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645.<\/p>\n

\u00ab\u0627\u06af\u0631 OBJECT_ID (N'tempdb..#Product\u00bb) \u062a\u0647\u06cc \u0646\u06cc\u0633\u062a
\u0634\u0631\u0648\u0639
\u0645\u06cc\u0632 \u0642\u0637\u0631\u0647 #\u0645\u062d\u0635\u0648\u0644
\u067e\u0627\u06cc\u0627\u0646
\u0627\u06cc\u062c\u0627\u062f TABLE #\u0645\u062d\u0635\u0648\u0644 (\u0646\u0627\u0645 VARCHAR(100),\u0634\u0631\u062d VARCHAR(255));<\/p>\n

INSERT INTO #Product(Name, Description) VALUES ('Entity Framework Extensions', 'Entity Framework Extensions Description.');
INSERT INTO #Product(Name, Description) VALUES ('Dapper Plus', 'Dapper Plus Description.');
INSERT INTO #Product(Name, Description) VALUES ('C# Eval Expression', 'C# Eval Description');
INSERT INTO #Product(Name, Description) VALUES ('Entity Framework Extensions', 'Entity Framework Extensions Description.');
INSERT INTO #Product(Name, Description) VALUES ('Dapper Plus', 'Dapper Plus Description.');
INSERT INTO #Product(Name, Description) VALUES ('C# Eval Expression', 'C# Eval Description');'<\/p>\n

\u0686\u06af\u0648\u0646\u0647 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u06cc\u0645:<\/p>\n

(SELECT Name ,ROW_NUMBER() over (partition by Name order by Name) RowNumber FROM #Product) a where a.RowNumber = 1;<\/code><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

Summarize this content to 400 words in Persian Lang \u0647\u0645\u06cc\u0634\u0647 \u0634\u0631\u0627\u06cc\u0637\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u0628\u0627\u06cc\u062f \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u062f\u0631 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062e\u0648\u062f \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645. \u06cc\u06a9 \u0631\u0627\u0647 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0686\u0646\u062f \u0645\u0646\u0638\u0648\u0631\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0645\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u0632 \u0645\u0646\u0628\u0639 \u0642\u0633\u0645\u062a \u0633\u0648\u0645 \u0628\u0647 \u0627\u06cc\u0646 \u0634\u06a9\u0644 \u0648\u0627\u0631\u062f \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645. …<\/p>\n","protected":false},"author":2,"featured_media":71949,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-71948","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/71948","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=71948"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/71948\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/71949"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=71948"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=71948"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=71948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}