tagged [exists]

PL/pgSQL checking if a row exists

PL/pgSQL checking if a row exists I'm writing a function in PL/pgSQL, and I'm looking for the simplest way to check if a row exists. Right now I'm SELECTing an `integer` into a `boolean`, which doesn'...

SQL Server: IF EXISTS ; ELSE

SQL Server: IF EXISTS ; ELSE I have a tableA: Also TableB Now I want to populate col = code of table B if there exists ID = 2 in tableA. for multiple values , get max value. else populate it with '123...

14 Mar at 12:23

SELECT * WHERE NOT EXISTS

SELECT * WHERE NOT EXISTS I think I'm going down the right path with this one... Please bear with me as my SQL isn't the greatest I'm trying to query a database to select everything from one table whe...

2 Oct at 08:45

What's different between Contains and Exists in List<T>?

What's different between Contains and Exists in List? I want to know what's different between `Contains` and `Exists` in `List` ? They can both determine whether an element is in the `List`. But what'...

31 Jul at 08:22

Servicestack OrmLite "where exists" subquery

Servicestack OrmLite "where exists" subquery No matter how hard I tried I couldn't make it work and I'm not sure if it is possible. I want to select all clients who have at least one order. The first ...

MySQL > Table doesn't exist. But it does (or it should)

MySQL > Table doesn't exist. But it does (or it should) I changed the datadir of a MySQL installation and all the bases moved correctly except for one. I can connect and `USE` the database. `SHOW TABL...

25 Nov at 11:12

SQL - IF EXISTS UPDATE ELSE INSERT INTO

SQL - IF EXISTS UPDATE ELSE INSERT INTO What I'm trying to do is `INSERT` subscribers in my database, but `IF EXISTS` it should `UPDATE` the row, `ELSE INSERT INTO` a new row. Ofcourse I connect to th...

13 Mar at 11:22

C# File.Exists returns false, file does exist

C# File.Exists returns false, file does exist Using VS 15, C# with .Net 4.5.2 The computer is on an AD network, with the ad name "AD". This problem happens with AD normal-user rights, AD admin rights,...

23 Mar at 16:13

How to wait until File.Exists?

How to wait until File.Exists? I have an app, listening for the *.log file in a chosen folder. I used `FileSystemWatcher`. But there is a problem. The other app responsible for making that file takes ...

16 Nov at 13:44

How can I check if an element exists in the visible DOM?

How can I check if an element exists in the visible DOM? How do you test an element for existence without the use of the `getElementById` method? I have set up a [live demo](http://jsbin.com/apawi5/3)...