Don Frazier

Don Frazier is a Senior Programmer at EDS. He has over 20 years experience in the Information Systems industry on platforms ranging from IBM mainframes to PCs. His experience ranges from IBM Assembler Language to C/C++ to Visual Basic and the .NET languages of C# and VB.NET. Microsoft certifications include MCSE, MCSD and MCDBA. Don’s current assignment is leading the development effort for a large personnel system. This system is web based with SQL Server data bases. When not hard at work creating software, Don enjoys mowing his yard, flying his stunt kite and juggling.

Technical Article

zPad() - add leading zeros to a number

This user-defined function converts a number to character format and adds leading zeroes to pad the field to a specified length.  useful for displaying SSNs or other numeric fields where the leading 0's are significant but the field is stored as numeric.To use:select dbo.zPad(, )make sure your length includes an extra column for the sign.  […]

You rated this post out of 5. Change rating

2002-12-05

375 reads

Technical Article

Convert a number to words

This is a handy function that converts a  number (integer) into its word format.  This might be handy if you need to print a check formatted number in words.  Currently it supports an integer but it would be almost nothing to convert to support a bigint or decimal.The components are1) a table named PlaceValue that […]

You rated this post out of 5. Change rating

2002-12-04

255 reads

Technical Article

PACK() user defined function

Convert a decimal number to IBM EBCDIC packed decimal format.  If for some reason you need to export a number to IBM systems in native format, you can define a SQL Server field as binary(8) and Pack() your decimal number into it.  Then IBM mainframes and COBOL/CICS systems can read the numbers from your data […]

5 (1)

You rated this post out of 5. Change rating

2002-12-04

464 reads

Blogs

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Humble Bundle of Java Books

By

I try to keep an eye on the Humble Bundle bundles for books. The...

How Redgate’s Test Data Manager Can Enhance Automated Testing

By

A brief overview of the benefits and challenges of automated testing and how Redgate’s...

Read the latest Blogs

Forums

Optional feature error

By GeorgeMayes

I have installed SQL Server Reporting Services 2019 on my Windows 10 machine, and...

SCOM alerts

By ramana3327

Hi, We are receiving alerts from SCOM regarding WMI health has errors. MP has...

Importing Data

By sathishkm

Hi All, I have an excel data that need to to import in SQL...

Visit the forum

Question of the Day

Updatable Views II

I have this view:

CREATE OR ALTER VIEW dbo.City 
AS
SELECT TOP 10 
 cn.CityNameID, cn.CityName
 FROM dbo.CityName AS cn
 WITH CHECK OPTION
GO
How can I modify the view to make it is updatable with this code?
INSERT City (CityName) VALUES ('Dillon')

See possible answers