Slika omota

Working with SQL Server text fields

Spremljeno u:
Izdano u:Active Server Developer's Journal vol. 4, no. 11 (Nov 2000), p. 12-14
Glavni autor: Disbrow, Steven W
Izdano:
Element K Journals
Teme:
Microsoft Corp
United States
US
World Wide Web
Servers
Structured Query Language-SQL
Systems development
Guidelines
Online pristup:Citation/Abstract
Full Text + Graphics
Full Text - PDF
Oznake: Dodaj oznaku
Bez oznaka, Budi prvi tko označuje ovaj zapis!

MARC

LEADER 00000nab a2200000uu 4500
001 206866006
003 UK-CbPIL
022 |a 1093-412X 
022 |a 1539-0330 
035 |a 206866006 
045 2 |b d20001101  |b d20001130 
084 |a 36507  |2 nlm 
100 1 |a Disbrow, Steven W 
245 1 |a Working with SQL Server text fields 
260 |b Element K Journals  |c Nov 2000 
513 |a Instructional 
520 3 |a   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. 
610 4 |a Microsoft Corp 
651 4 |a United States 
651 4 |a US 
653 |a World Wide Web 
653 |a Servers 
653 |a Structured Query Language-SQL 
653 |a Systems development 
653 |a Guidelines 
773 0 |t Active Server Developer's Journal  |g vol. 4, no. 11 (Nov 2000), p. 12-14 
786 0 |d ProQuest  |t Advanced Technologies & Aerospace Database 
856 4 1 |3 Citation/Abstract  |u https://www.proquest.com/docview/206866006/abstract/embedded/7BTGNMKEMPT1V9Z2?source=fedsrch 
856 4 0 |3 Full Text + Graphics  |u https://www.proquest.com/docview/206866006/fulltextwithgraphics/embedded/7BTGNMKEMPT1V9Z2?source=fedsrch 
856 4 0 |3 Full Text - PDF  |u https://www.proquest.com/docview/206866006/fulltextPDF/embedded/7BTGNMKEMPT1V9Z2?source=fedsrch