All Questions

Filter by
Sorted by
Tagged with
0
votes
3answers
466 views

Comparing the values of two columns with different datatypes

I have two columns in a table which need to be compared against the data.The problem that I am facing is that each of the columns have different datatypes: float and datetime2. EventID EventStartDate ...
3
votes
0answers
76 views

why some one will use approximate data types for sales

I was messing around with Kartris online shop and I was reading this definition for a product version(you have basic information of a product in one table and many versions of products wich can have ...
1
vote
1answer
404 views

What is the best SQL Server field type to cast to when storing a UNC path stored in a sql_variant field?

What is the best choice of field type to cast to when storing a UNC path in a sql_variant in Microsoft SQL Server 2008? It appears that I could store up to 4000 characters according to Microsoft ...
4
votes
1answer
19k views

Standard data types for email address, telephone number , first name, rixh text editor, etc

I want to build a database for our system using Sql Server 2008 R2. but i need to know what are the best data types for storing these info:- Email address Telephone number with extension, such as +44 ...
2
votes
2answers
935 views

Database events that will cause deletion of index

In SQL server if we try to change a data type of a column having index ,then it deletes the indexes associated with that column and changes the data type . I was not aware of it and was faced problem ...
1
vote
1answer
986 views

Suppressing the removal of leading zeros in numeric data

I initially declared the data type of the columns for some of the tables I am working on as NUMERIC. Because of that, leading zeros are being removed. Is there anyway to suppress this behavior? I ...
3
votes
1answer
119k views

Float datatype with 2 digits after decimal point

In SQL server float datatype does not display trailing zeros after decimal point declare @num as float set @num=5.20 select @num will dispaly only 5.2 But i want it to display as 5.20 After a ...
9
votes
1answer
20k views

Datatype bigger than bigint

I want to use dataype which can hold more than 19 digits. So is there any datatype available which can hold larger than 19 digits?