Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

1 1670 posted 17 years ago by ginoplusio
show a table with data and his column name
2 2135 posted 17 years ago by ginoplusio
When you make a login remember to use CASE SENSITIVE on password and case insensitive on username
0 1792 posted 17 years ago by ginoplusio
This assumes that you have sqlcmd (comes with SQL Server client tools) installed and wish to execute every file ending in .sql within the given directory against the specified server and database using Windows Authentication.
2 2140 posted 17 years ago by hoffstein
0 1615 posted 17 years ago by sebus
Fields are tab delimited and need to match table schema. I've found the tab separator ASCII(009) preferable over using a comma. The second version can help remove double quotation marks around character fields. Don't forget the keyword LOC...
0 1965 posted 17 years ago by RICHARDP
You can use regular expressions within SQL. This can be quite powerful in selecting data that matches certain conditions. The following example shows a simple regular expression which selects only quarterly periods from a table containing years, quar...
0 4049 posted 17 years ago by webonomic
0 1696 posted 17 years ago by stavelin
This Oracle SQL snippet converts an Oracle SQL DATE to a STRING in the form CCYYMMDD.
0 2682 posted 17 years ago by retry
0 3674 posted 17 years ago by webonomic
If you ever need to build a comma delimited list out of a column in SQL you can easily do this using the COALESCE function.
0 1450 posted 17 years ago by mcbutterbuns
0 1547 posted 17 years ago by benpjohnson
Using Proc SQL summarize the table sashelp.shoes grouping on
0 3743 posted 17 years ago by webonomic
To grant all privileges to a user from any location login to the mysql shell and run the following queries.
3 1852 posted 18 years ago by cbrant
To reset the MySQL root password, login to the mysql shell and run the following commands.
1 1626 posted 18 years ago by cbrant
0 1621 posted 18 years ago by webonomic
https://www.chrisjmendez.com/2008/03/23/mysql-commands-i-wish-i-could-remember/
9 1949 posted 18 years ago by chrisaiv
This is the SoftPRO library needed by the GUI Collector main file.
0 1221 posted 18 years ago by stagger
This is the main file. You also need the libraries posted here for the program to work.
0 1181 posted 18 years ago by stagger
0 1466 posted 18 years ago by stagger
4 2032 posted 18 years ago by wolfie