Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

5 total

On This Page:

  1. 1 Case sensitivity in PostgreSQL
  2. 2 Find solved forum threads with Google
  3. 3 Disconnect Windows 2000 RDP session from command line
  4. 4 Selecting different parts of a DATETIME with MSSQL
  5. 5 Scripting schema updates in MSSQL #1

Case sensitivity in PostgreSQL

to databases sql select database tables table column columns query postgresql postgre psql rdbm names name lower upper case lowercase uppercase statement by chrelad on Sep 18, 2008
When I started using PostgreSQL, it seemed odd that when I created a table called Users with column names like userId, userPassword, etc. When I would select these items from the table, the column and table names would all be in lowercase. It's quite simple really, I wasn't using quotes :) Below is an example of how to maintain your case in PostgreSQL:

This will all come out lowercase
create table Users (
  userId integer unique not null,
  userFirstName varchar(50) not null,
  userLastName varchar(50) not null
);


Whereas this will come out as you expect it to
create table "Users" (
  "userId" integer unique not null,
  "userFirstName" varchar(50) not null,
  "userLastName" varchar(50) not null
);

Find solved forum threads with Google

to google search string hack query title forums forum by chrelad on Jul 19, 2008
A method of using google which allows for fast and accurate searching of forums and other websites for solved threads matching your criteria.

Just so everyone is aware, I just put the tag "hack" in the tag list so that those looking for google hacks might stumble on this. We'll see how that works out.
http://www.google.com/search?q=intitle:solved+intext:nvidia+5200
// This will find tons of solved issues regarding the NVidia 5200 graphics card

http://www.google.com/search?q=intitle:solved+intext:nvidia+5200+"no+screens+found"
// This should help you fix a problem with "No screens found" on an NVidia 5200 card

Disconnect Windows 2000 RDP session from command line

to remote windows command line console terminal desktop session query dos win 2000 2k rdp protocol disconnect connect active tsdiscon by chrelad on Nov 16, 2007
I use SSH to gain access to my Windows 2000 command line, so that will be reflected in the below steps.


Step #1: Connect to the server if you are not sitting at it
ssh username@win2000server -i privatekey

Step #2: Find out which sessions are currently active
query session

 SESSIONNAME       USERNAME                 ID  STATE   TYPE        DEVICE
>console                                     0  Conn    wdcon
 rdp-tcp                                 65536  Listen  rdpwd
 rdp-tcp#7         fakeuser                  1  Active  rdpwd

Step #3: We want to kill the connection with an ID of 1 (we can tell by the username and that it is active)
tsdiscon 1 /v

Disconnecting sessionID 1 from sessionname RDP-Tcp#7

That's it :) Easy eh?

Selecting different parts of a DATETIME with MSSQL

to time date sql timestamp mssql language query transact structured datetime parts part stamp only sub by chrelad on Nov 14, 2007
Thanks to this website for the information:

http://www.databasejournal.com/features/mssql/article.php/1442021

-- The syntax for pulling a certain part of a DATETIME is:
--
-- CONVERT(date_type[(length)],expression[,style])
--
-- The available styles are as follows:
--
-- NULL  Jun 24 2001 9:48PM
-- 1     06/24/01
-- 101   06/24/2001
-- 2     01.06.24
-- 104   24.06.2001
-- 108   21:48:00
-- 112   20010624
-- 121   2001-06-24 21:48:00.000

-- Some example usage:
SELECT CONVERT(DATETIME,GETDATE(),112) as date
-- Will output in YYYYMMDD format
SELECT CONVERT(DATETIME,client.birthday,101) as birthday
-- Will output in MM/DD/YYYY format

Scripting schema updates in MSSQL #1

to sql tsql database mssql schema update tables microsoft columns query scripting information_schema alter altering by chrelad on Aug 08, 2007 1 Comments
This SQL statement will alter a table only if a column in the table to be altered does NOT contain a column named 'FavoriteColorId'.

From: http://haacked.com/

IF NOT EXISTS
(
    SELECT * FROM [information_schema].[columns]
    WHERE    table_name   = 'Customer'
    AND      table_schema = 'dbo'
    AND      column_name  = 'FavoriteColorId'
)
BEGIN
    ALTER TABLE [dbo].[Customer]
    ADD FavoriteColorId int
5 total

On This Page:

  1. 1 Case sensitivity in PostgreSQL
  2. 2 Find solved forum threads with Google
  3. 3 Disconnect Windows 2000 RDP session from command line
  4. 4 Selecting different parts of a DATETIME with MSSQL
  5. 5 Scripting schema updates in MSSQL #1