What do you want to save?
Add Code snippet
New code examples
-
Java 2022-03-12 15:25:10
create statement in jdbc
Connection = Helps our java project connect to database Statement = Helps to write and execute SQL query ResultSet = A DataStructure where the data from query result stored +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ After s... Add solution -
Javascript 2022-03-06 18:40:21
connecting to the database
I USE JDCB I use CONNECTION database to make connection I create STATEMENT than I use statement to create query And run the query and get the RESULT SET Connection = import java.sql.Connection; Driver manager = import java.sql.DriverManager; Connection... Add solution -
TypeScript 2022-02-01 06:16:51
test coverage techniques
1-Statement Coverage: It verifies that each line of source code has been executed and tested 2-Decision Coverage: It ensures that every decision in the source code is executed and tested 3-Path Coverage: It ensures that every possible route through a gi... Add solution -
SQL 2022-01-23 05:07:03
mysql trigger example
-- The following statement creates an AFTER UPDATE trigger on the sales table: DELIMITER $$ CREATE TRIGGER after_sales_update AFTER UPDATE ON sales FOR EACH ROW BEGIN IF OLD.quantity <> new.quantity THEN INSERT INTO SalesChanges(salesI... Add solution -
Python 2021-11-20 16:07:18
continue in python
The continue statement in Python returns the control to the beginning of the while loop. The continue statement rejects all the remaining statements in the current iteration of the loop and moves the control back to the top of the loop. The continue s... Add solution -
Java 2021-11-14 08:08:20
WAP in Java to insert a record from a form to table.
import java.io.DataInputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.Statement; public class ExPrepareStatement { public static void main(String[] args) { try{ Class.forName(&... Add solution -
Python 2021-10-26 04:20:11
python break continue
The continue statement in Python returns the control to the beginning of the while loop. The continue statement rejects all the remaining statements in the current iteration of the loop and moves the control back to the top of the loop. The continue s... Add solution -
TypeScript 2021-10-09 19:23:04
if not exists in sql
At first glance your original attempt seems pretty close. I'm assuming that clockDate is a DateTime fields so try this: IF (NOT EXISTS(SELECT * FROM Clock WHERE cast(clockDate as date) = '08/10/2012') AND userName = 'test') BEGIN INSERT INTO C... Add solution
Best helpers
Nick Vaccaro
+5
Ivan T.
+5
Bianco
+5
Nikola
+5
Graffito
+5
Mari Yoongi
+5
Tyr
+5
Christophrrb
+5
Vary
+5
Mushi.f
+5
Euan
+5
Ryan Friend
+5
Millemila
+5
Soumee
+5
Gftern
+5
Davesmiths
+5
Vocaro
+5
Vbence
+5
Del Findley
+5