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 -
SQL 2022-03-12 07:25:04
REMOVE DATE FROM DATE TIME SQL SERVER
First thing's first, if your dates are in varchar format change that, store dates as dates it will save you a lot of headaches and it is something that is best done sooner rather than later. The problem will only get worse. Secondly, once you have a date... Add solution -
SQL 2022-02-22 15:40:39
in memory sqllite
using System; using System.Data.SQLite; string cs = "Data Source=:memory:"; string stm = "SELECT SQLITE_VERSION()"; using var con = new SQLiteConnection(cs); con.Open(); using var cmd = new SQLiteCommand(stm, con); string version = ... Add solution -
SQL 2022-02-19 01:00:03
sql comparison operators
(Between) operator same as ">= <=" For example: Select * From Employees Where salary Between 4000 AND 6000; (NOT) operator excluding given For example: Select last_name, job_id From Employees Where "Not" job_id = 'ABC'; (IN)... Add solution -
SQL 2022-02-13 23:00:36
how to retrieve data from a sql server database in c#
public Person SomeMethod(string fName) { var con = ConfigurationManager.ConnectionStrings["Yourconnection"].ToString(); Person matchingPerson = new Person(); using (SqlConnection myConnection = new S... Add solution