Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

form regex email curl url http login css mysql database ajax javascript js sql class php header redirect table ie data dropdown sort list object date phone number format svn command resize image file textmate plugin path math actionscript event mail link window debug template Bash java search html post mac error xhtml page google wordpress server rails browser python script replace style array forms backup flash video ruby DOM xml category unix osx download simple c code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

« Prev 1 ... 7 8 9 10 11 ... 17 Next »

SQL sql Raiserror with parameters

You can see details on http://msdn.microsoft.com/en-us/library/ms178592.aspx , but I try to explain how you throw error with "uniqueidentifier" type parameters. I convert uniqueidentifier to string (nvarchar(50)) and set a variable. "%s" is equal...

0 1698 posted 14 years ago by emregulcan

SQL SQL Template - Drop Column

My Drop Column.sql This template drops a columns of the table.

0 722 posted 14 years ago by edwinet

SQL SQL Template - Add Column

My Add Column Varchar.sql This template adds a new varchar column to the table.

0 802 posted 14 years ago by edwinet

PHP Goede foutafhandeling MySQLi

0 697 posted 14 years ago by Waldio

SQL Find Duplicate Rows in Table

Field1 + Field2 + Field3 should create 1 entry for each unique row in the DB. In an employee table, this would be FirstName + LastName + EmployeeNumber

1 793 posted 14 years ago by ezerick

PHP SQL results pager HTML

0 724 posted 14 years ago by kendsnyder

PHP secure input (xss, sql injection)

4 1191 posted 14 years ago by takel

MySQL Create a table with a dynamic name

the following code can be used to create a table with a dynamic name

0 894 posted 14 years ago by gtaking

ActionScript 3 AS3 SQL Date Today

0 829 posted 14 years ago by jaredyeo

VB.NET Use OLEDB To Read An Excel File

Doesn't do any validation, you would want to check if a

0 1903 posted 14 years ago by brettville

Rails SQL log in Rails console

0 1137 posted 14 years ago by batamire

SQL Display the size of tables

1 798 posted 14 years ago by samwa

MySQL Find All SlideDeck Slides from the wp_posts Table

This SQL query will find all the SlideDeck related entries in your WordPress database.

0 794 posted 14 years ago by Jamie

SQL Search SQL Server field names and stored procedure text

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

1 1152 posted 14 years ago by axs221

SQL SQL Trim Function

Today I need Trim() function in sql, but in Sql 2005 there is no function. Because of that I wrote this user (scalar) fuction. It's very basic; -First; it's Right Trim (RTrim()) string - And then Left Trim (LTrim())

0 689 posted 14 years ago by emregulcan

SQL Drupal 6 - Fix Menu links you can\'t delete by reseting them to delete via SQL

Used the first sql statement to find your menu item. (Replace menu-% with the name of your menu eg. "primary-links" . Then using the menu item id fix the items you want to regain the good old delete button on the menu item.

0 1153 posted 14 years ago by Onfire60

SQL Postgres get table schema with columns

Get table schema with columns via sql.

0 783 posted 14 years ago by djmornyc

SQL Get last date of a month

1 860 posted 14 years ago by samwa

SQL get the first date of a month

1 973 posted 14 years ago by samwa

SQL SQL Server - Find text in stored proc

0 958 posted 14 years ago by SkyeBianca

PHP Goede foutafhandeling MySQL

0 878 posted 14 years ago by Waldio

SQL Set Drupal site online

1 762 posted 14 years ago by titosemi

SQL Set Drupal site offline

1 706 posted 14 years ago by titosemi

SQL Error Script (Find All Errors in a database connection)

0 977 posted 14 years ago by staley412

SQL Import data into MySQL from a bcp output file

0 1522 posted 14 years ago by eddequincey

SQL Export Data From SQL Server to Microsoft Excel Datasheet

How to Export Data From SQL Server to Microsoft Excel Datasheet

0 1157 posted 14 years ago by derebus

SQL Truncate DateTime

Truncates a DateTime value.

0 614 posted 14 years ago by cdicarlo

SQL Padding character field with leading zeros

0 686 posted 14 years ago by cdicarlo

C# Basic SQL access

1 715 posted 14 years ago by brandonroath

Python SQLObject sql to python

0 870 posted 14 years ago by metoikos