What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-03 00:00:02
real world example of nosql
One example is analytics. Lets say you want to build the next Google Analytics. You figure out you want to track IP Address, Browser & Device type. Later you, however, finds out you might want to track Browser Size as well. Since analytics databases ... Add solution -
SQL 2022-03-02 15:30:16
check mysql status on commandline
$ systemctl status mysql ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql; generated) Active: active (running) since Tue 2021-05-18 13:34:02 CEST; 12s ago Docs: man:systemd-sysv-gene... Add solution -
SQL 2022-02-27 06:20:05
how to check sql server agent job history
-In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance. -Expand SQL Server Agent, and then expand Jobs. -Right-click a job, and then click View History. -In the Log File Viewer, view the job history. -... Add solution -
SQL 2022-02-26 23:35:10
excel export from sql using python
import pandas as pd import xlsxwriter import pyodbc conn = pyodbc.connect('Driver={SQL Server}; Server=ServerIP; uid=UID; pwd=Password; Trusted_Connection=No;') with pd.ExcelWriter("Output.xlsx", engine="xlsxwriter", options = {'str... Add solution -
PHP 2022-02-23 04:00:09
php pdo error handling
$database -> errorInfo()[0] # SQLSTATE error code (a five characters alphanumeric identifier defined in the ANSI SQL standard). $database -> errorInfo()[1] # Driver-specific error code. $database -> errorInfo()[2] # Driver-specific error message. Add solution -
SQL 2022-02-19 10:45:06
sql server trigger after insert, update specific column
-- SQL Server (update my_table after update on my_table) CREATE TRIGGER trigger_name ON my_table AFTER UPDATE AS IF UPDATE (col_name) -- Optional, for particular column BEGIN UPDATE my_table SET my_col_date = getdate() FROM my_table END; -- Oracle (i... Add solution
Best helpers
Ranking is empty