Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged server

« Prev 1 Next »
SQL Server query sample using rank/dense_rank
0 507 posted 8 years ago by ManuelToledo
Insertar registros bloqueando mientras se realiza el proceso.
0 473 posted 8 years ago by systemergon
Alternativas para formato de datos en sql server
0 617 posted 8 years ago by systemergon
Drop store procedures
0 586 posted 10 years ago by ironcrema
Adding a linked server to MSSQL account - particularly a MYSQL server
0 536 posted 10 years ago by kidmizere
Función sql que devuelve una tabla. parametros ID, cadena, caracter_slit
0 623 posted 10 years ago by ironcrema
Extrae subcadena de cadena separado por caracter
0 562 posted 10 years ago by ironcrema
Agrega Llave Foránea
0 516 posted 10 years ago by ironcrema
Input: Month and year number Output: Last day of month
0 534 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 877 posted 12 years ago by denakitan
Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
0 660 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 1088 posted 12 years ago by derebus
Similar to "FIND_IN_SET" from MySQL.
0 667 posted 13 years ago by dotNetkow
0 474 posted 13 years ago by scholli
Search SQL Server field names and stored procedure text, based on a keyword.
1 840 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 704 posted 14 years ago by tobewan
0 477 posted 14 years ago by tobewan
0 615 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 556 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 563 posted 17 years ago by jomaweb
« Prev 1 Next »