Get flash to fully experience Pearltrees
One of the key goals when building applications is to make sure the data you enter into the database meets all your business rules. Data validation is a critical part of your application to ensure your data meets the requirements developed by your business analysts. There are a number of different processes that can be used to make sure your data validates against your business rules. Data validate rules can be enforced within your application code in the application layer; or data can be validated by the database engine.
Up until this point, I’ve covered how to manipulate data stored in physical tables. Now I’ll introduce you to querying data represented by virtual tables. These virtual tables are SQL constructs known as views. Unlike conventional physical tables, views don’t contain data. A view is merely a stored SQL statement that, when executed, generates a result set. When you query a view, you’re really querying the result set of a previously defined query.
I am trying to store long text so I gave the field in question the TEXT datatype. But it only lets me store 1023 characters. I was expecting (but not quite needing) 2,147,483,647 characters when using the TEXT datatype. Can some one point out what I am missing. Great forum, my first post, ahhh.... I will continue to search the forum for my answer.
Ok guys - I don't understand why you guys are giving up on this topic. I to was looking for a way to store huge amounts of text into a single sql 7 column. I went through alot of grief to get my solution solved. I know there are others ways to do it, but think why did Microsoft include ntext and text as datatypes in sql 7? Do you think they were making it up - NO Here is my solution and I hope it helps:
Learn the basics of writing stored procedures, monitor stored procedure activity using the Profiler utility, and learn from several real-world stored procedure programming issues. Ken Henderson also touches on many of the nuances and quirks in Transact-SQL, and how to use them to your advantage and/or how to work around them as appropriate. This sample chapter is excerpted from The Guru's Guide to SQL Server Stored Procedures, XML, and HTML .
Introduce to SQL View SQL View is a virtual table which is used to encapsulate a complex queries. After creating SQL view, you can treat a view as a table and manipulate data on it with only some restrictions. When the data in table changes, the data in view which is dependent on table changes also. View does not occupied the physical space as table does.