•  »
  • tagged group by

1-3 of 3 Hubssort by Hot Best Latest

Seven Deadly SQL Sins Part III68

Seven Deadly SQL Sins Part III

by hot dorkage

published 3 years ago

continued from part two This is the third in a series of four excerpts from the MySQL presentation I have given live on a number of occasions. It was inspired Arjen Lentz' outline entitled The Deadly Sins...

1 comment    data math programming
VIEWS IN PL/SQL60

VIEWS IN PL/SQL

by soniacharan

published 8 months ago

A view is an object that contains no data of its own.Views are easy to use and implement as they are not tables. View definition is stored in data dictionary. Hence the changes are automatically reflected in the views.

0 comments    data create tables
sql scripts54

sql scripts

by techno geek

published 2 years ago

CREATE FUNCTION FN_HEXTOBINARY (@HEX VARCHAR(8)) RETURNS VARCHAR(255) AS BEGIN DECLARE @BASE TINYINT DECLARE @string VARCHAR(255) DECLARE @return VARCHAR(255) DECLARE @div INT ...

0 comments    sql sql server sql tutorial
working