Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged server



« Prev 1 Next »
SQL Server query sample using rank/dense_rank
0 879 posted 9 years ago by ManuelToledo
Insertar registros bloqueando mientras se realiza el proceso.
0 847 posted 9 years ago by systemergon
Alternativas para formato de datos en sql server
0 1043 posted 9 years ago by systemergon
Drop store procedures
0 987 posted 11 years ago by ironcrema
Adding a linked server to MSSQL account - particularly a MYSQL server
0 959 posted 11 years ago by kidmizere
Función sql que devuelve una tabla. parametros ID, cadena, caracter_slit
0 1043 posted 11 years ago by ironcrema
Extrae subcadena de cadena separado por caracter
0 915 posted 11 years ago by ironcrema
Agrega Llave Foránea
0 865 posted 11 years ago by ironcrema
Input: Month and year number Output: Last day of month
0 910 posted 12 years ago by sjmoorecouk
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 1340 posted 13 years ago by denakitan
Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
0 1058 posted 13 years ago by jstrawther
http://beyondrelational.com/ask/nakul/questions/10/how-to-remove-server-name-item-from-sql-server-management-studio.aspx
0 1597 posted 14 years ago by derebus
Similar to "FIND_IN_SET" from MySQL.
0 1073 posted 14 years ago by dotNetkow
0 865 posted 14 years ago by scholli
Search SQL Server field names and stored procedure text, based on a keyword.
1 1291 posted 14 years ago by axs221
If you need to list all of the MySQL databases managed by Plesk along with their corresponding domains and login credentials, you can use this query:
1 1120 posted 15 years ago by tobewan
0 869 posted 15 years ago by tobewan
0 1031 posted 16 years ago by d020
I was having the hardest time getting this to work. It's a collection of various items. For whatever reason, I needed to include the CASE statement due to NULL's coming back. If this helps you out... go for it.
0 924 posted 16 years ago by gembry
Esta consulta nos permite comprobar si los registros obtenidos por dos consultas o vistas que operan de diferente forma son los mismos en ambos casos. Conviene adaptar las partes de la consulta de manera que se obtengan los resultados de nuestras dos...
0 938 posted 19 years ago by jomaweb
« Prev 1 Next »