-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Howdy,
I am using Visual Studio 2010 and am playing around with the Database Projects.
I am creating a DataGenerationPlan to insert data into a simple table, in which one of the column datatypes is XML.
Out of the box, the generation plan uses the Regular Expression generator and generates something…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have an addresses table with ZIP code field which has type VARCHAR.
I need to select all addresses form this table using ZIP codes range.
If I used next code:
select * from address where cast(zip as bigint) between 90210 and 90220
I get an error on fields where ZIP code cann't be cast as bigint…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I need to store three items as an array in a single column and be able to quickly/easily modify that data in later functions.
[---YOU CAN SKIP THIS PART IF YOU TRUST ME--]
To be clear, I love and use x_ref tables all the time but an x_ref doesn't work here because this is not a one-to-many relationship…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Howdy,
I am using Visual Studio 2010 and am playing around with the Database Projects.
I am creating a DataGenerationPlan to insert data into a simple table, in which one of the column datatypes is XML.
Out of the box, the generation plan uses the Regular Expression generator and generates something…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
The database development standards in our organization state the varchar fields should not allow null values. They should have a default value of an empty string (""). I know this makes querying and concatenation easier, but today, one of my coworkers questioned me about why that standard only existed…
>>> More
