Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged server

« Prev 1 Next »
SQL Server query sample using rank/dense_rank
0 511 posted 8 years ago by ManuelToledo
Insertar registros bloqueando mientras se realiza el proceso.
0 476 posted 8 years ago by systemergon
Alternativas para formato de datos en sql server
0 618 posted 8 years ago by systemergon
Drop store procedures
0 590 posted 10 years ago by ironcrema
Adding a linked server to MSSQL account - particularly a MYSQL server
0 540 posted 10 years ago by kidmizere
Función sql que devuelve una tabla. parametros ID, cadena, caracter_slit
0 626 posted 10 years ago by ironcrema
Extrae subcadena de cadena separado por caracter
0 568 posted 10 years ago by ironcrema
Agrega Llave Foránea
0 521 posted 10 years ago by ironcrema
Input: Month and year number Output: Last day of month
0 536 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 879 posted 12 years ago by denakitan
Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
0 662 posted 12 years ago by jstrawther
http://beyondrelational.com/ask/nakul/questions/10/how-to-remove-server-name-item-from-sql-server-management-studio.aspx
0 1089 posted 12 years ago by derebus
Similar to "FIND_IN_SET" from MySQL.
0 670 posted 13 years ago by dotNetkow
0 477 posted 13 years ago by scholli
Search SQL Server field names and stored procedure text, based on a keyword.
1 843 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 708 posted 14 years ago by tobewan
0 478 posted 14 years ago by tobewan
0 617 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 562 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 566 posted 17 years ago by jomaweb
« Prev 1 Next »