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 1661 posted 14 years ago by emregulcan

SQL SQL Template - Drop Column

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

0 689 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 767 posted 14 years ago by edwinet

PHP Goede foutafhandeling MySQLi

0 659 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 759 posted 14 years ago by ezerick

PHP SQL results pager HTML

0 698 posted 14 years ago by kendsnyder

PHP secure input (xss, sql injection)

4 1145 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 847 posted 14 years ago by gtaking

ActionScript 3 AS3 SQL Date Today

0 787 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 1840 posted 14 years ago by brettville

Rails SQL log in Rails console

0 1094 posted 14 years ago by batamire

SQL Display the size of tables

1 771 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 759 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 1108 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 665 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 1114 posted 14 years ago by Onfire60

SQL Postgres get table schema with columns

Get table schema with columns via sql.

0 747 posted 14 years ago by djmornyc

SQL Get last date of a month

1 834 posted 14 years ago by samwa

SQL get the first date of a month

1 933 posted 14 years ago by samwa

SQL SQL Server - Find text in stored proc

0 923 posted 14 years ago by SkyeBianca

PHP Goede foutafhandeling MySQL

0 842 posted 14 years ago by Waldio

SQL Set Drupal site online

1 726 posted 14 years ago by titosemi

SQL Set Drupal site offline

1 674 posted 14 years ago by titosemi

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

0 943 posted 14 years ago by staley412

SQL Import data into MySQL from a bcp output file

0 1474 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 1119 posted 14 years ago by derebus

SQL Truncate DateTime

Truncates a DateTime value.

0 579 posted 14 years ago by cdicarlo

SQL Padding character field with leading zeros

0 653 posted 14 years ago by cdicarlo

C# Basic SQL access

1 686 posted 14 years ago by brandonroath

Python SQLObject sql to python

0 833 posted 14 years ago by metoikos