What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-21 10:45:22
sql server decimal equivalent in c#
sql server decimal equivalent in c# Add solution -
Other 2021-11-21 07:37:25
how to hard drop database in postgres
DROP DATABASE base_de_datos; // SI SALE ESTE MESAJE DE ERROR HAGA LOS PASOS QUE ESTAN A CONTINUACION ERROR: database "base_de_datos" is being accessed by other users SQL state: 55006 Detail: There is 1 other session using the database. -------... Add solution -
SQL 2021-11-21 07:34:17
sql limit results returned
-- 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 2021-11-20 23:02:10
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
## ERROR 2002 (HY000): ## Can't connect to local MySQL server through socket #### Follow below steps and you good to go... #### sudo dpkg-reconfigure mysql-server-{version_number} ##version_number should be mysql version number installed ## Now try log... Add solution -
SQL 2021-11-20 01:08:07
sql server connection string
Standard Security Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword; Trusted Connection Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; Connection to a SQL Server instance The server/instance name synt... Add solution -
SQL 2021-11-19 12:19:11
sql convert string to date yyyymmddhhmmss
-- Oracle:TO_DATE(string, format) SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual; SELECT TO_DATE('05/06/2012 13:25:12', 'DD/MM/YYYY HH24:MI:SS') FROM dual; -- SQL Server: CONVERT(data_type, string, style). Cf source link for style codes. SELECT CONV... Add solution -
SQL 2021-11-19 02:00:09
what are all the different types of indexes in sql
"There are two types of Indexes in SQL Server 1. Clustered Index A clustered index defines the order in which data is physically stored in a table. Table data can be sorted in only way, therefore, there can be only one clustered index per table.... Add solution -
Other 2021-11-18 11:44:44
@DynamicInsert(value=true)@DynamicUpdate(value=true) used in hibernate
So after almost 2 month's wait I was finally able to derive this conclusion proposed as an answer to my own question with the help from various sources: 1.) When using dynamic-update, Hibernate has to generate the corresponding SQL string each time and t... Add solution -
SQL 2021-11-17 05:48:18
connect to azure sql database from python
import pyodbc server = '<server>.database.windows.net' database = '<database>' username = '<username>' password = '<password>' driver= '{ODBC Driver 17 for SQL Server}' with pyodbc.connect('DRIVER='+driver+';SERVER='+server+';P... Add solution
Best helpers
Ranking is empty