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

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 984 posted 9 years ago by ManuelToledo

SQL Insert bloqueando la tabla

Insertar registros bloqueando mientras se realiza el proceso.

server

0 996 posted 9 years ago by systemergon

SQL Formatos de datos en SQL

Alternativas para formato de datos en sql server

server

0 1229 posted 9 years ago by systemergon

SQL Drop store procedures by name contains

Drop store procedures

server

0 1177 posted 11 years ago by ironcrema

SQL Adding Linked Server to MSSQL

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

server

0 1111 posted 11 years ago by kidmizere

SQL Split SQL Server

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

server

0 1234 posted 11 years ago by ironcrema

SQL Extraer cadena segun caracter

Extrae subcadena de cadena separado por caracter

server

0 1077 posted 11 years ago by ironcrema

SQL Agregar LLave ForÃ¡nea

Agrega Llave ForÃ¡nea

server

0 967 posted 12 years ago by ironcrema

SQL Return last day of month

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

server

0 1009 posted 13 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 2197 posted 13 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 1146 posted 13 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 2520 posted 14 years ago by derebus

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

server

0 1498 posted 14 years ago by kashif21

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

server

0 1213 posted 14 years ago by dotNetkow

SQL Shrink all development databases

server

0 944 posted 14 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

server

0 1034 posted 14 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 1393 posted 14 years ago by axs221

SQL Find all Foreign Keys in a SQL Server DB

server

1 1720 posted 15 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 1210 posted 15 years ago by tobewan

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

server

0 999 posted 15 years ago by tobewan

SQL Grab Plesk FTP account passwords

server

0 957 posted 15 years ago by tobewan

SQL Change owner on sql server db.

server

0 1160 posted 16 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 1073 posted 16 years ago by gembry

SQL Selecting a Random Row In Microsoft SQL Server

server

0 1225 posted 16 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 1040 posted 19 years ago by jomaweb