Snipplr

(SQL) Reseting the seed of column identity in sql sever using stored procedures - PalCoder

Fri, 14 Jun 2013 23:55:49 GMT

using this code in a stored procedure you can reset the seed of the identity column in sql server database

(SQL) CASE statement to transpose rows in to columns - mprabhuram

Thu, 13 Jun 2013 02:45:46 GMT

This SQL would help you to transpose a rows into columns in SQL

(SQL) Cognomi italiani - zitter

Wed, 12 Jun 2013 07:11:14 GMT

lista cognomi italiani

(SQL) SQL to list Italian names - zitter

Wed, 12 Jun 2013 06:52:39 GMT

SQL to list and generate common italian names

(SQL) numberOfPurchase - dimkalinux

Sat, 01 Jun 2013 00:30:59 GMT

(SQL) Get Only Time in SQL - keidash

Thu, 30 May 2013 20:59:04 GMT

How to get onlye the time in SQL

(SQL) Oracle Reset a Sequence - geekzspot

Sat, 25 May 2013 06:46:09 GMT

Without DROP and reCREATEing it so as to preserve any GRANTs perhaps? We ALTER it to increment by negative its current value to get it to 0

(SQL) Bulk insert/upload microsoft sql server (csv) - dego89

Fri, 17 May 2013 04:03:48 GMT

Bulk upload a CSV into Microsoft SQL Server

(SQL) Oracle SQL Spool Schema Name in Filename - geekzspot

Wed, 15 May 2013 08:13:30 GMT

Capture the name of the current Schema (aka User or Account) as part of the SPOOL Output filename

(SQL) Oracle Schema DB Stats - geekzspot

Wed, 15 May 2013 05:34:45 GMT

Run DB Stats for your Schema

(SQL) Oracle Automatic DB Stats - geekzspot

Wed, 15 May 2013 05:32:53 GMT

Since Oracle 11g statistics are gathered automatically by default. You check the status for yourself:

(SQL) Oracle DB Stats - geekzspot

Wed, 15 May 2013 03:53:11 GMT

Run Oracle Database Statistics for the whole database

(SQL) Oracle Show my GRANTs and Privileges for an Object - geekzspot

Wed, 15 May 2013 02:33:14 GMT

-- See what GRANTs and Privileges I have on an object, such as a Table, View, Sequence, Stored Procedure

(SQL) Oracle Database Parameters - geekzspot

Sat, 11 May 2013 05:08:56 GMT

See database settings. Client will override Database.

(SQL) Oracle Client Date Timestamp versus Database Server Date Timestamp - geekzspot

Fri, 10 May 2013 08:19:53 GMT

Maybe your Client ins in one Time Zone, and your Database Server is in an0ther?

(SQL) Convert Oracle Timestamp from one Time Zone to another - geekzspot

Fri, 10 May 2013 07:21:16 GMT

Convert Oracle TIMESTAMP Column from one Timezone to another. Here we convert UTC (aka GMT) to MDT (Mountain Time Zone of North America)

(SQL) Oracle Table Rows - geekzspot

Fri, 10 May 2013 02:23:23 GMT

Get the Number of Rows in all your Tables. Run DB Stats for more accuracy!

(SQL) Show Oracle Parameter value - geekzspot

Wed, 08 May 2013 02:59:55 GMT

Here for example we show the default NLS_LENGTH_SEMNATICS Parameter

(SQL) Oracle Change Data Type for all Columns - geekzspot

Wed, 08 May 2013 02:42:05 GMT

You might want to change all VARCHARs from BYTE to CHAR?

(SQL) Oracle change Column Datatype - geekzspot

Tue, 07 May 2013 13:06:15 GMT

Maybe you want to change BYTE to CHAR? Maybe you want to go BIGGER?