C# DataTable sıralama

            DataTable dt = new DataTable("TestTable");
            dt.Columns.Add("Kolon1");
            dt.Columns.Add("Kolon2");

            dt.Rows.Add(1, "deneme 1");
            dt.Rows.Add(7, "deneme 7");
            dt.Rows.Add(3, "deneme 3");
            dt.Rows.Add(5, "deneme 5");
            dt.Rows.Add(2, "deneme 2");

 

            DataView dataView = dt.DefaultView;
            dataView.Sort = "Kolon1";
            DataTable dtSortedAsc = dataView.ToTable();

 

            dataView.Sort = "Kolon1 desc";
            DataTable dtSortedDesc = dataView.ToTable();

Bir text hangi stored procedure'de geçiyor?

SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%aranacak text%' AND ROUTINE_TYPE='PROCEDURE'

veya

SELECT OBJECT_NAME(id) FROM SYSCOMMENTS WHERE [text] LIKE '%aranacak text%' AND OBJECTPROPERTY(id, 'IsProcedure') = 1 GROUP BY OBJECT_NAME(id)

veya

SELECT OBJECT_NAME(object_id) FROM sys.sql_modules WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1 AND definition LIKE '%aranacak text%'

Kaynak: http://stackoverflow.com/questions/5079457/how-do-i-find-a-stored-procedure-containing-text