Viewing 2 posts - 1,411 through 1,413 (of 1,413 total)
Use a computed field. Something like:
CREATE TABLE foobar
(
a int IDENTITY(1,1)
, b char(3)
, c AS (b + REPLICATE('0', 4 - LEN(CONVERT(varchar(4), a))) +...
--Chris Hedgate http://www.hedgate.net/Contributor to the Best of SQL Server Central volumesArticles: http://www.sqlservercentral.com/columnists/chedgate/
July 17, 2001 at 7:22 am
#417115
Are SQL Mail and SQL Agent Mail sharing the same profile, or are they using different (named) profiles?
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
July 16, 2001 at 8:59 am
#417087