Welcome To Snipplr
Everyone's Recent Snippets Tagged sql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
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
797
posted 11 years ago by nimblebits
http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/
0
520
posted 11 years ago by BrentS
Create a new database and its respective user with all privileges
0
546
posted 11 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
496
posted 11 years ago by thescorpion
Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle
0
723
posted 11 years ago by thescorpion
Consular los tablespace y mostrar su tamaño , uso y espacio libre en Megabyte
0
4672
posted 11 years ago by thescorpion
Function to prevent sql injection in Like queries, where the characters '_' and '%' can be dangerous.
0
871
posted 11 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
872
posted 11 years ago by denakitan
Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
0
656
posted 12 years ago by jstrawther
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
562
posted 12 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
933
posted 12 years ago by theonlyalterego
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
1045
posted 12 years ago by magicrebirth
Query to find the most recent logins for a particular user ( find 1 years worth )
0
803
posted 12 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
672
posted 12 years ago by ezerick