Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

sql page server Oracle mysql csv database wordpress error php code drupal date replace script security search xml function text order textmate update file query data list table excel backup customer load login ASP codeigniter magento simple user windows convert joomla math find copy json Business directory number path images Online log links template link Development api twitter best web format object cache mail email html javascript actionscript apache color download service android animation browser aspnet ajax array c forms

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged server

« Prev 1 Next »

SQL SQL Server query sample using rank/dense_rank

SQL Server query sample using rank/dense_rank

server

0 1710 posted 10 years ago by ManuelToledo

SQL Insert bloqueando la tabla

Insertar registros bloqueando mientras se realiza el proceso.

server

0 1706 posted 10 years ago by systemergon

SQL Formatos de datos en SQL

Alternativas para formato de datos en sql server

server

0 2176 posted 10 years ago by systemergon

SQL Drop store procedures by name contains

Drop store procedures

server

0 1979 posted 12 years ago by ironcrema

SQL Adding Linked Server to MSSQL

Adding a linked server to MSSQL account - particularly a MYSQL server

server

0 1914 posted 12 years ago by kidmizere

SQL Split SQL Server

FunciÃ³n sql que devuelve una tabla. parametros ID, cadena, caracter_slit

server

0 2057 posted 12 years ago by ironcrema

SQL Extraer cadena segun caracter

Extrae subcadena de cadena separado por caracter

server

0 1772 posted 12 years ago by ironcrema

SQL Agregar LLave ForÃ¡nea

Agrega Llave ForÃ¡nea

server

0 1729 posted 13 years ago by ironcrema

SQL Return last day of month

Input: Month and year number Output: Last day of month

server

0 1661 posted 14 years ago by sjmoorecouk

SQL 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.

server

0 3243 posted 14 years ago by denakitan

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

Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.

server

0 1762 posted 14 years ago by jstrawther

SQL 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

server

0 3710 posted 15 years ago by derebus

SQL SQL SERVER â€“ Useful DateTime Functions to Find Specific Dates

server

0 2390 posted 15 years ago by kashif21

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

server

0 1946 posted 15 years ago by dotNetkow

SQL Shrink all development databases

server

0 1626 posted 15 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

server

0 1730 posted 15 years ago by scholli

SQL Search SQL Server field names and stored procedure text

Search SQL Server field names and stored procedure text, based on a keyword.

server

1 2178 posted 15 years ago by axs221

SQL Find all Foreign Keys in a SQL Server DB

server

1 2692 posted 16 years ago by ezerick

SQL 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:

server

1 1941 posted 16 years ago by tobewan

SQL Get Plesk FTP account passwords w/o logging into MySQL

server

0 1702 posted 16 years ago by tobewan

SQL Grab Plesk FTP account passwords

server

0 1639 posted 16 years ago by tobewan

SQL Change owner on sql server db.

server

0 1857 posted 17 years ago by d020

SQL 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.

server

0 1810 posted 17 years ago by gembry

SQL Selecting a Random Row In Microsoft SQL Server

server

0 2032 posted 17 years ago by jordantbro

SQL 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...

server

0 1693 posted 20 years ago by jomaweb