What do you want to save?
Add Code snippet
New code examples
-
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-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-15 23:55:05
sql get list of domains and the tables that use them
--Queries an sde-schema geodatabase in SQL Server DECLARE @DOMAIN_NAME NVARCHAR(MAX); SET @DOMAIN_NAME = 'Material'; DECLARE @CLASS_DEFS TABLE ( Name nvarchar(max), Definition XML ) --Insert records to temporary record set INSERT INTO @CLASS_... Add solution -
PHP 2022-02-02 18:30:50
showing database table in php
$connection = mysql_connect('localhost', 'root', ''); //The Blank string is the password mysql_select_db('hrmwaitrose'); $query = "SELECT * FROM employee"; //You don't need a ; like you do in SQL $result = mysql_query($query); echo "<t... Add solution -
Other 2022-01-30 01:16:33
What is view in DBMS
Views : Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables, present in the database. A View can either have all the row... Add solution -
SQL 2021-11-19 16:32:22
mysql query return excel file
#Before exectue query in sql run following command: sudo chmod 755 -R /var/lib/mysql/ #run query in mysql SELECT ... FROM ... WHERE ... INTO OUTFILE 'file.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'; #Then Ope... Add solution
Best helpers
Ranking is empty