Login / Register

Share Snipplr

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

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 1318 posted 13 years ago by emregulcan

SQL SQL Template - Drop Column

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

0 482 posted 13 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 564 posted 13 years ago by edwinet

PHP Goede foutafhandeling MySQLi

0 451 posted 13 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 541 posted 13 years ago by ezerick

PHP SQL results pager HTML

0 506 posted 13 years ago by kendsnyder

PHP secure input (xss, sql injection)

4 855 posted 13 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 632 posted 13 years ago by gtaking

ActionScript 3 AS3 SQL Date Today

0 601 posted 13 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 1522 posted 13 years ago by brettville

Rails SQL log in Rails console

0 822 posted 13 years ago by batamire

SQL Display the size of tables

1 580 posted 13 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 563 posted 13 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 853 posted 13 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 447 posted 13 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 866 posted 13 years ago by Onfire60

SQL Postgres get table schema with columns

Get table schema with columns via sql.

0 556 posted 13 years ago by djmornyc

SQL Get last date of a month

1 642 posted 13 years ago by samwa

SQL get the first date of a month

1 711 posted 13 years ago by samwa

SQL SQL Server - Find text in stored proc

0 692 posted 13 years ago by SkyeBianca

PHP Goede foutafhandeling MySQL

0 624 posted 13 years ago by Waldio