Check your default constraints
Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.
2018-09-17
3,529 reads
Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.
2018-09-17
3,529 reads
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.
2017-03-24 (first published: 2015-12-01)
6,342 reads
2015-06-04
1,636 reads
I'm having trouble re-establishing a relationship between two tables. I have a foreign key table - records and a primary key table table - center. The primary key being "clinicphone" - I'm not sure exactly what happened, but when I created the tables, and the relationship, a record in the "records" table could not be […]
2005-04-22
3 reads
as long as you are using some predefined date format from TSQL you couldn't cast it.But if you are not sure about the format cast it or better convert it. Because with the convert you can exactly control the date (and time) format of your input
2004-08-26
Hi everybody:I'm receaving password protected Excel files. Those files my app reads and dumps data into SQL tables. How to decrypt (I knew a password) or make Excel file without password. Those files are encrypted because we are getting them from enternet. RGDS Sam
2004-08-19
1 reads
2004-07-16
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