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 2454 posted 15 years ago by emregulcan

SQL SQL Template - Drop Column

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

0 1324 posted 15 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 1460 posted 15 years ago by edwinet

PHP Goede foutafhandeling MySQLi

0 1239 posted 15 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 1492 posted 15 years ago by ezerick

PHP SQL results pager HTML

0 1302 posted 15 years ago by kendsnyder

PHP secure input (xss, sql injection)

4 3151 posted 15 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 1702 posted 15 years ago by gtaking

ActionScript 3 AS3 SQL Date Today

0 1491 posted 15 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 2917 posted 15 years ago by brettville

Rails SQL log in Rails console

0 1923 posted 15 years ago by batamire

SQL Display the size of tables

1 1410 posted 15 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 1429 posted 15 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 1918 posted 15 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 1273 posted 15 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 2919 posted 15 years ago by Onfire60

SQL Postgres get table schema with columns

Get table schema with columns via sql.

0 1472 posted 15 years ago by djmornyc

SQL Get last date of a month

1 1541 posted 15 years ago by samwa

SQL get the first date of a month

1 1876 posted 15 years ago by samwa

SQL SQL Server - Find text in stored proc

0 1683 posted 15 years ago by SkyeBianca

PHP Goede foutafhandeling MySQL

0 1498 posted 15 years ago by Waldio

SQL Set Drupal site online

1 1470 posted 15 years ago by titosemi

SQL Set Drupal site offline

1 1287 posted 15 years ago by titosemi

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

0 1877 posted 15 years ago by staley412

SQL Import data into MySQL from a bcp output file

0 2507 posted 15 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 2993 posted 15 years ago by derebus

SQL Truncate DateTime

Truncates a DateTime value.

0 1226 posted 15 years ago by cdicarlo

SQL Padding character field with leading zeros

0 1294 posted 15 years ago by cdicarlo

C# Basic SQL access

1 1413 posted 15 years ago by brandonroath

Python SQLObject sql to python

0 1506 posted 15 years ago by metoikos