Imagen de Portada

Working with SQL Server text fields

Guardado en:
Publicado en:Active Server Developer's Journal vol. 4, no. 11 (Nov 2000), p. 12-14
Autor principal: Disbrow, Steven W
Publicado:
Element K Journals
Materias:
Microsoft Corp
United States
US
World Wide Web
Servers
Structured Query Language-SQL
Systems development
Guidelines
Acceso en línea:Citation/Abstract
Full Text + Graphics
Full Text - PDF
Etiquetas: Agregar Etiqueta
Sin Etiquetas, Sea el primero en etiquetar este registro!
Resumen:  In the view defined here, we've converted the resume field from the text data type into a varchar that can be up to 8,000 characters in length. (Note that this trick won't work in earlier versions of SQL Server. They limit the varchar type to 255 characters. Version 7, however, puts the cap at 8,000 characters.) You can then select from the view instead of the table, and get back up to 8,000 characters of your data.
ISSN:1093-412X
1539-0330
Fuente:Advanced Technologies & Aerospace Database