The most persistent struggle in data processing has been to ensure clean data. There are many ways that data can be incorrect and a database must check, as best it can, that the data is correct. The CHECK constraint is ideally suited for this sort of work, and the checking routine can become quite complex when dealing with check digits in data.
2011-04-28
3,328 reads
A number of different processes that can be used to make sure your data validates against your business rules. This article discusses how you can use database "check constraints" to validate your data within the SQL Server database engine.
2009-04-10
2,542 reads
correct if it's a statement, hard to answer if it's question
2005-05-04
You probably didn't get much interest here, because this forum is for SQL Server 2005 (aka Yukon)!But it is true that the row size in SQL Server is limited to 8060 bytes. There are at least two common ways to work around this problem.The first way is to change larger fields (if there are any) […]
2004-09-16
Hello.If you still need a more detailed example then you may want to use the Build Query button in the Transform Data Task. This option will give you a GUI that beahves somewhat like MS Access.If you need more detailed than that then you may want to state specifically which step is giving you trouble.
2004-09-13
Check the reference to Microsoft ActiveX Data Objects and make certain you are using a library version which supports the stream object ( 2.5 or higher )
2004-07-07
Somewhere in your code you are using the RAISERROR command and you are not supplying the correct parameters to the error string. RAISERROR ('The level for job_id:%d should be between %d and %d.', 16, 1, @@JOB_ID, @@MIN_LVL, @@MAX_LVL)In the above example, the parameters @@JOB_ID, @@MIN_LVL, @@MAXLVL will be inserted into the error string 'The […]
2004-07-07
Yes, I'm sure. As a matter of fact the DDL for one table was generated from the other (obviously, I tried to simplify the situation). The column in question is defined as char(10) nullable. My theory is that the original table's database was created when the server was 7.0. I know that datalength behaves differently […]
2004-02-18
The First /2.0 is a computed FORMULA for the median so it has to be DECIMAL or FLOATThe Second is just a count of RECORDS(ROWS)!! so it can't be a record and a half then you use /2HTH
2004-02-16
Because of the OR, you'll probably find a UNION faster, as it can seek (instead of scan) on each of the two indexed columns. 3 seconds for inserting 63,000 rows seems pretty fast to me, though. With the query as written, you could certainly speed things up by using covering indexes, but then you write that […]
2004-02-10
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers