What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-17 15:40:29
mysql limit rows
-- MySql SELECT * FROM emp ORDER BY sal DESC LIMIT 5; -- SQL Server SELECT TOP 5 * FROM emp ORDER BY sal DESC; -- Oracle < 11g SELECT * FROM ( SELECT * FROM emp ORDER BY sal DESC ) WHERE ROWNUM <= 5; -- Oracle 12c + SELECT * FROM emp ORDER BY sa... Add solution -
Other 2022-03-03 04:20:03
flutter&dart recommended settings for vs code
{ // Causes the debug view to automatically appear when a breakpoint is hit. This // setting is global and not configurable per-language. "debug.openDebug": "openOnDebugBreak", "[dart]": { // Automatically format code ... Add solution -
SQL 2022-02-14 10:50:01
how to get one year old query from plan cache
SELECT TOP 10 t.TEXT QueryName, s.execution_count AS ExecutionCount, s.max_elapsed_time AS MaxElapsedTime, ISNULL(s.total_elapsed_time / 1000 / NULLIF(s.execution_count, 0), 0) AS AvgElapsedTime, s.creation_time, ISNULL(s.execution_count / 1000 / NULLIF(D... Add solution -
SQL 2022-02-03 09:03:35
create a quick temp table with stored procedure sql
/* First you need to create a table type. */ CREATE TYPE Names AS TABLE (Name VARCHAR(10)) ; GO /* Next, Create a procedure to receive data for the table-valued parameter, the table of names and select one item from the table*/ CREATE PROCEDURE Ch... Add solution -
Other 2022-02-02 11:46:39
dapper
string sqlOrderDetails = "SELECT TOP 5 * FROM OrderDetails;"; string sqlOrderDetail = "SELECT * FROM OrderDetails WHERE OrderDetailID = @OrderDetailID;"; string sqlCustomerInsert = "INSERT INTO Customers (CustomerName) Values (@Cu... Add solution -
Best helpers
Ranking is empty