Posted
by User
on Stack Overflow
See other posts from Stack Overflow
or by User
Published on 2010-05-04T01:40:55Z
Indexed on
2010/05/04
1:48 UTC
Read the original article
Hit count: 223
What is the best datatype for holding percent values ranging from 0.00% to 100.00%?
© Stack Overflow or respective owner
as seen on SQL Authority
- Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time.
My association with SQL Server Magazine has been quite long, I have written nearly…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hi,
I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager.
I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't…
>>> More
as seen on ASP-PHP.net
- Search for 'ASP-PHP.net'
Modification technique pour le site de l'article.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it.
We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error:
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections
What…
>>> 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'
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
