Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged server



« Prev 1 Next »
  1. FAV

    SQL Server query sample using rank/dense_rank

    SQL Server query sample using rank/dense_rank
    SQL 4 views posted 4 years ago by ManuelToledo
  2. FAV

    Insert bloqueando la tabla

    Insertar registros bloqueando mientras se realiza el proceso.
    SQL 2 views posted 4 years ago by systemergon
  3. FAV

    Formatos de datos en SQL

    Alternativas para formato de datos en sql server
    SQL 2 views posted 4 years ago by systemergon
  4. FAV

    Drop store procedures by name contains

    Drop store procedures
    SQL 2 views posted 5 years ago by ironcrema
  5. FAV

    Adding Linked Server to MSSQL

    Adding a linked server to MSSQL account - particularly a MYSQL server
    SQL 0 views posted 5 years ago by kidmizere
  6. FAV

    Split SQL Server

    Función sql que devuelve una tabla. parametros ID, cadena, caracter_slit
    SQL 5 views posted 6 years ago by ironcrema
  7. FAV

    Extraer cadena segun caracter

    Extrae subcadena de cadena separado por caracter
    SQL 1 views posted 6 years ago by ironcrema
  8. FAV

    Agregar LLave Foránea

    Agrega Llave Foránea
    SQL 2 views posted 6 years ago by ironcrema
  9. FAV

    Return last day of month

    Input: Month and year number Output: Last day of month
    SQL 5 views posted 7 years ago by sjmoorecouk
  10. FAV

    SQL - SQL Server - Add Column with Default Value and Check Constraint

    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.
    SQL 3 views posted 7 years ago by denakitan
  11. FAV

    Search DDL (stored procedures, functions, etc) for keywords

    Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
    SQL 5 views posted 7 years ago by jstrawther
  12. FAV

    How to clear the history list from the \"servername\" field of SSMS Connect-to-server dialog box?

    http://beyondrelational.com/ask/nakul/questions/10/how-to-remove-server-name-item-from-sql-server-management-studio.aspx
    SQL 5 views posted 8 years ago by derebus
  13. FAV

    SQL SERVER – Useful DateTime Functions to Find Specific Dates

    SQL 5 views posted 8 years ago by kashif21
  14. FAV

    Specify order of rows returned in MS SQL Server

    Similar to "FIND_IN_SET" from MySQL.
    SQL 2 views posted 9 years ago by dotNetkow
  15. FAV

    Shrink all development databases

    SQL 1 views posted 9 years ago by scholli
  16. FAV

    SQL Server 2008 Truncate Transaction Log

    SQL 3 views posted 9 years ago by scholli
  17. FAV

    Search SQL Server field names and stored procedure text

    Search SQL Server field names and stored procedure text, based on a keyword.
    SQL saved by 3 people 2 views posted 9 years ago by axs221
  18. FAV

    Find all Foreign Keys in a SQL Server DB

    SQL saved by 2 people 2 views posted 9 years ago by ezerick
  19. FAV

    Find all databases and login credentials

    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:
    SQL saved by 4 people 2 views posted 10 years ago by tobewan
  20. FAV

    Get Plesk FTP account passwords w/o logging into MySQL

    SQL 1 views posted 10 years ago by tobewan
  21. FAV

    Grab Plesk FTP account passwords

    SQL 0 views posted 10 years ago by tobewan
  22. FAV

    Change owner on sql server db.

    SQL 0 views posted 10 years ago by d020
  23. FAV

    Getting Count's with a UNION of two tables

    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.
    SQL 1 views posted 11 years ago by gembry
  24. FAV

    Selecting a Random Row In Microsoft SQL Server

    SQL 2 views posted 11 years ago by jordantbro
  25. FAV

    comprobar registros identicos de dos consultas

    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...
    SQL 0 views posted 13 years ago by jomaweb
« Prev 1 Next »