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

SQL Insert bloqueando la tabla

Insertar registros bloqueando mientras se realiza el proceso.

server

0 1002 posted 9 years ago by systemergon

SQL Formatos de datos en SQL

Alternativas para formato de datos en sql server

server

0 1245 posted 9 years ago by systemergon

SQL Drop store procedures by name contains

Drop store procedures

server

0 1186 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 1120 posted 11 years ago by kidmizere

SQL Split SQL Server

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

server

0 1243 posted 11 years ago by ironcrema

SQL Extraer cadena segun caracter

Extrae subcadena de cadena separado por caracter

server

0 1086 posted 11 years ago by ironcrema

SQL Agregar LLave ForÃ¡nea

Agrega Llave ForÃ¡nea

server

0 971 posted 12 years ago by ironcrema

SQL Return last day of month

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

server

0 1012 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 2254 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 1152 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 2589 posted 14 years ago by derebus

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

server

0 1509 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 1214 posted 14 years ago by dotNetkow

SQL Shrink all development databases

server

0 954 posted 14 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

server

0 1044 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 1398 posted 14 years ago by axs221

SQL Find all Foreign Keys in a SQL Server DB

server

1 1749 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 1211 posted 15 years ago by tobewan

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

server

0 1005 posted 15 years ago by tobewan

SQL Grab Plesk FTP account passwords

server

0 961 posted 15 years ago by tobewan

SQL Change owner on sql server db.

server

0 1164 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 1085 posted 16 years ago by gembry

SQL Selecting a Random Row In Microsoft SQL Server

server

0 1238 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 1046 posted 19 years ago by jomaweb