Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged server



« Prev 1 Next »
SQL Server query sample using rank/dense_rank
0 491 posted 8 years ago by ManuelToledo
Insertar registros bloqueando mientras se realiza el proceso.
0 452 posted 8 years ago by systemergon
Alternativas para formato de datos en sql server
0 599 posted 8 years ago by systemergon
Drop store procedures
0 567 posted 9 years ago by ironcrema
Adding a linked server to MSSQL account - particularly a MYSQL server
0 523 posted 10 years ago by kidmizere
Función sql que devuelve una tabla. parametros ID, cadena, caracter_slit
0 599 posted 10 years ago by ironcrema
Extrae subcadena de cadena separado por caracter
0 546 posted 10 years ago by ironcrema
Agrega Llave Foránea
0 499 posted 10 years ago by ironcrema
Input: Month and year number Output: Last day of month
0 513 posted 11 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 857 posted 11 years ago by denakitan
Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
0 637 posted 11 years ago by jstrawther
http://beyondrelational.com/ask/nakul/questions/10/how-to-remove-server-name-item-from-sql-server-management-studio.aspx
0 1052 posted 12 years ago by derebus
Similar to "FIND_IN_SET" from MySQL.
0 654 posted 13 years ago by dotNetkow
0 460 posted 13 years ago by scholli
Search SQL Server field names and stored procedure text, based on a keyword.
1 795 posted 13 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 680 posted 14 years ago by tobewan
0 456 posted 14 years ago by tobewan
0 592 posted 14 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 533 posted 15 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 542 posted 17 years ago by jomaweb
« Prev 1 Next »