Cuando requerimos hacer consultas que devuelvan todos los registros y al mismo tiempo si se desea filtrar por algunos campos se filtra por los parÃ¡metros devueltos ej. en el WHERE (U.UnidadAplicativaId = @UnidadAplicativaId OR @UnidadAplicativaId...

0 544 posted 8 years ago by systemergon

SQL Get rows coutn of all datatables of one database

This lite fiuntion is a simple organizator rowcount for all datatables for one single database.

0 587 posted 8 years ago by achavesm302

SQL Migrate a Wordpress

Moving a wordpress site for local dev, to staging, to production? This SQL snippet has done the job more often than not. It may not be 100% full proof but it has saved my butt hundreds of times. Please, if you know other tables or enhancements share...

0 750 posted 8 years ago by brownrl

SQL Get all procedures from Oracle packages

This only shows public procedures, not the privates one declares only in packages body.

0 571 posted 9 years ago by Igeco

SQL Jacaard Index, Similarity based on Tag System

This piece of sql is used to find the similarity of one item to other items based on a 3 table tag system, cities, cities_tags, tags. It works in sQlite and MySQL. Use this code to get the idea of how you would make a "item" has "related items" based...

0 652 posted 9 years ago by brownrl

SQL A light implementation of Session table in Mysql 5.6 using memory engine

caching session variables in Mysql using memory engine for fast client response. note: please test before use, then use at your own risk.

0 1108 posted 9 years ago by prgrmmraben

SQL Calculate Relative Time Ago

Here you may find some useful snippets for calculating relative time for different purposes: to get info from a column within certain date, like the latest 7 days, to get time interval etc.

0 710 posted 9 years ago by apphp-snippets

SQL SQL Server Data Types

Data types and ranges for Microsoft Access, MySQL and SQL Server.

0 465 posted 9 years ago by chrispantelis

SQL New SQL Record = Populate TimeStamp Field with GetDate() Function

New SQL Record = Populate TimeStamp Field with GetDate() Function

0 708 posted 9 years ago by chrispantelis

SQL Create Table Based on Another Table

If you want to make a copy of the table including all of the data, then leave out the WHERE clause.

0 568 posted 9 years ago by chrispantelis

SQL Parse xml in SQL

Parse xml (passed as a parameter) in SQL