[Help]
     
Sections
     
     
     
     
Home  > Articles/Tutorials > Code Snips > TSQL

TSQL
    TSQL Code Snip: Searching for Locations within a Radius of a Zipcode
Hits Today: 0 Total: 8341Updated: 8/17/2005Reviews: 2
Add to Favorites
In a previous article we provided a code snippet in ASP on how to conduct a search based on two criteria from the user, a postal code, and a miles for searching within a radius. In this article we provide the same functionality, but all within TSQL.
    Code Snip: TSQL Search and Replace Text Field
Hits Today: 0 Total: 25940Updated: 8/14/2005Reviews: 3
Add to Favorites
In this SQL code snippet we go over a method to do a search and replace on text fields within a SQL database. This code came in particularly handy when converting over from DNN 1.x to DNN 2.x where the portal directories changed from a long hex based GUID...
    Randomize a Resultset in SQL
Hits Today: 0 Total: 6315Updated: 3/22/2005Reviews: 4
Add to Favorites
WWWCoderIn this article we provide a small code snippet on how to return records from a table in SQL in a random order.
    SQL Server Professional: T-SQL Coding Standards
Hits Today: 0 Total: 3614Updated: 2/9/2005Reviews: 1
Add to Favorites
MSDNPinnacle columnist Brian Walker shares his tips and standards for composing and formatting T-SQL code.
    Code Snip: Using Cursors in TSQL
Hits Today: 0 Total: 24125Updated: 2/3/2005Reviews: 12
Add to Favorites
WWWCoderIn this article we will show how to iterate through a recordset in TSQL using cursors. In this example, we will select some records and then insert the ID into a related table.

     
     
     
     

 

 

     
     

 


 


Digg This
 


DotNetNuke Platinum Benefactor

 


 


Digg This
 


DotNetNuke Platinum Benefactor

     

     

     
Copyright 20010 - Santry Technology Solutions, Box 172, Girard, PA 16417, (814) 774-0970
Privacy Statement | Terms Of Use