What do you want to save?
Add Code snippet
New code examples in category SQL
-
Awgiedawgie 2022-03-18 05:45:27
oracle sql trigger after insert
-- SQL Server (update my_table2 after insert on my_table1) CREATE TRIGGER trigger_name ON my_table1 FOR INSERT AS BEGIN UPDATE my_table2 SET my_col_date = getdate() FROM my_table1 END -- Oracle (insert into log table after update on my_table) CREATE ... Add solution -
Krish 2022-03-18 03:30:17
search all database tables for a value sqlserver
DECLARE @SearchStr nvarchar(100) SET @SearchStr = '## YOUR STRING HERE ##' -- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved. -- Purpose: To search all columns of all tables for a given search string -- Written by: Naraya... Add solution -
Awgiedawgie 2022-03-17 20:55:07
sql comand for removing data from table
select '123'+'123' as result; Add solution -
Phoenix Logan 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