Dymanic URL Mapping in Dotnet - VB Code

by rlynch April 21, 2010 06:01
The wonderfull world of SEO tends to frown on query string arguments and will actually almost penalize you for using them. Due to that it is often preferable to change your urls to have a more SEO friendly look. e.g. http://lynchtek.com/examples.aspx?id=30989&cat=sql is not as user fri... [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

asp.net | CSS | DotNet Utilities | SQL Server

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed

How to Format a DateTime field in SQL to a ShortTime format hh:mm am/pm

by rlynch November 01, 2009 07:09
Script to create a UDF (user defined function) that formats a datetime field into a shorttime string. [More]

Currently rated 4.3 by 3 people

  • Currently 4.333333/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

SQL Server

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed

Intersect and Except - SQL Clauses

by rlynch October 24, 2009 16:03
The following script shows the difference between the intersect and except clauses in a hello world type example. Intersect shows the rows in the first query that exist in the second query while the except only shows the rows that don't exist in the second query. The... [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

SQL Server

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed

SQLSEVER transactions and Savepoints

by rlynch October 24, 2009 07:14
This is a quick and dirty "Hello World" example of how to use savepoints in a SQL Server transaction to Roll back a transaction to a specific point.   create table t3(ids int) go truncate table t3 insert into t3 values(0) begin tran abc wi... [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

SQL Server

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed

Installing SSIS Packages

by rlynch July 12, 2009 02:59
Avoiding problems running ssis packages in job steps [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

SQL Server | ssis

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed

Creating a webservice to provide sequential numbers formatted with leading 0's

by rlynch February 19, 2009 03:42
In this tutorial we will look at how to create a SOAP webservice with Visual Studio.Net that serves up sequential numbers to the caller. One of the biggest challenges to this is maintaining state between calls and potentially reboots. In a simple situation you could preserve this data in an applic... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

asp.net | dot.net application development | SQL Server | Web Services

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed

Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen | Modified by Mooglegiant

Calendar

<<  September 2010  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar