Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

1 ... 4 5 6 7 8 ... 17
This is a method that can be used to take a connection string and a valid oledb command and perform a scalar. This returns an Integer/Int32 value.
0 4029 posted 13 years ago by nimblebits
One line to determine start of previous month
1 1839 posted 13 years ago by snoopmole
How to find a given column in a given database in MySQL
1 3024 posted 13 years ago by philsown
ver tablas que tiene un usario asiganadas por privilegio
0 5961 posted 13 years ago by thescorpion
Uso de Grant y Revoke de objetos masivos de distintos user
0 1736 posted 13 years ago by thescorpion
http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/
0 1685 posted 13 years ago by BrentS
Create a new database and its respective user with all privileges
0 1710 posted 13 years ago by claudiodev
Cuando se da el caso que tienes 2 servidores diferentes y el ServiceName de oracle es el mismo...En el momento de crear un dblink hay que especificar bien la cadena de coneccion para que se direccione al otro servidor y no escoja el serviceName del e...
0 1684 posted 13 years ago by thescorpion
Delete a defined number of rows from a db2 database table
0 1789 posted 13 years ago by claudiodev
Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle
0 1909 posted 13 years ago by thescorpion
SQL Server 2008 Date/Time Statements
0 1431 posted 13 years ago by msstar
Consular los tablespace y mostrar su tamaño , uso y espacio libre en Megabyte
0 6169 posted 13 years ago by thescorpion
SQL update examples using joins
1 1941 posted 13 years ago by ed_trench
Borrar archivos Log con Rman
0 2491 posted 14 years ago by thescorpion
find what profile values are set for a particular user
0 1856 posted 14 years ago by theonlyalterego
Input: Month and year number Output: Last day of month
0 1637 posted 14 years ago by sjmoorecouk
Function to prevent sql injection in Like queries, where the characters '_' and '%' can be dangerous.
0 3424 posted 14 years ago by TimoZachi
Example of SQL syntax to add a new column to an existing table, define a default value to the columns for the existing rows and also add a check constraint to limit the values that the column can hold.
0 3216 posted 14 years ago by denakitan
Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
0 1735 posted 14 years ago by jstrawther
Can be used when looking for values that are duplicates.
0 1495 posted 14 years ago by BrentS
in order to avoid the .zip madness when creating a new module, you can make it available in the backend by firing a simple SQL in your DB. (mod_media is the name of the folder that holds it)
0 1894 posted 14 years ago by iroybot
This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name
0 2573 posted 14 years ago by theonlyalterego
Can use second, Minute and many other from the url above
0 1705 posted 14 years ago by jsturtevant
Where clause to select multiple rows of unique values
0 1897 posted 14 years ago by the_construct
While django provides the django_admin.py cleanup script, if sessions get out of control sometimes you have to go lower level to get everything cleaned up. If the problem gets out of hand and you hit the resource limits of the machine, it is very dif...
0 4543 posted 14 years ago by magicrebirth
Query to find the most recent logins for a particular user ( find 1 years worth )
0 2057 posted 14 years ago by theonlyalterego
This code allows you to create an ID field value for inserts into a table that does not auto increment itself
0 1956 posted 14 years ago by ezerick
Searches for duplicate entries in the DataBase table
1 1580 posted 14 years ago by Neven
intfield has this format: YYYYMMDD
0 4332 posted 14 years ago by wnasich
0 2024 posted 14 years ago by danfsmith
1 ... 4 5 6 7 8 ... 17