Answer to this and all mapping of types can be found here.

[SQL-CLR Type Mapping][1]

Chart, stolen from that page:

![enter image description here][2]

---

Updated 1/7/2013 - there&#39;s a more recent version, .not so colorful here: 
[SQL Server Data Type Mappings][2]

[2]: http://msdn.microsoft.com/en-us/library/cc716729.aspx


  [1]: http://msdn.microsoft.com/en-us/library/bb386947.aspx
  [2]: http://i.stack.imgur.com/HKZCS.gif

That would be float.

See [Mapping CLR Parameter Data][1].


  [1]: http://msdn.microsoft.com/en-us/library/ms131092.aspx

Float is the sql type you are looking for.

float matches best. real is only 32 bits in precision, so essentially useless.

See: http://msdn.microsoft.com/en-us/library/ms173773.aspx


&quot;The synonym for double precision is float(53).&quot; Default value of n is 53.

From page http://msdn.microsoft.com/en-us/library/ms173773.aspx

Google didn&#39;t turn up anything that seemed relevant.

I have a bunch of existing, working C++ code, and I&#39;d like to use python to crawl through it and figure out relationships between classes, etc.

EDIT: Just wanted to point out: I don&#39;t think I need or want to parse every bit of C++; I just need something smart enough to pick up on class, function and member variable declarations, and to skip over function definitions. 

Is there a good Python library that can parse C++?

How can you show/reveal hidden characters in NetBeans?  In other editors, if this feature is turned on, a space might be shown as a small centered dot, and a tab as a right arrow.  (This feature is useful to see if a file uses tabs or spaces for indentation, among other things.)

How to show/reveal hidden or invisible characters in NetBeans?

Is it money, float, real, decimal, _________ ?

Which sql server data type best represents a double in C#?

<p>Is it money, float, real, decimal, _________ ?</p>


I want to hide the base public property(a data member) in my derived class:
    

    class Program
    {
        static void Main(string[] args)
        {
            b obj = new b();
            obj.item1 = 4;// should show an error but it doent ???
        }
    }

    class a
    {
        public int item1 {get; set;}
        public int item2 { get; set; }
    }

    class b : a
    {
        new private int item1;
    }

    class c : a
    {
       
    }

 i have  member as public because i want the member to be inherited in c class , but want to hide the member in b class , how can i do this ?

dont i have an option to selectively inherite the variable i want in my base class ??? thats really bad , i think ms should provide us with an option (may be a modifier) to perform this


----------


**Edit:**


I found the answer myself (i heard lots of them telling this is not possible in c#, but you can kind of do it)

I am including the code in case it is useful

    class Program
    {
        static void Main(string[] args)
        {
            b obj = new b();
            obj.item1 = 4; // shows an error  : )
        }
    }

    class a
    {
        public int item1 { get; set; }
        public int item2 { get; set; }
    }

    class b : a
    {
        new public static int item1
        {
            get;
            private set;
        }
    }

How can I hide a base class public property in the derived class

I have a collection of objects that I need to write to a binary file.  

I need the bytes in the file to be compact, so I can&#39;t use `BinaryFormatter`.  `BinaryFormatter` throws in all sorts of info for deserialization needs.

If I try 

    byte[] myBytes = (byte[]) myObject 

I get a runtime exception.

I need this to be fast so I&#39;d rather not be copying arrays of bytes around.  I&#39;d just like the cast `byte[] myBytes = (byte[]) myObject` to work!

&lt;edit&gt; OK just to be clear, I cannot have *any* metadata in the output file.  Just the object bytes.  Packed object-to-object.  Based on answers received, it looks like I&#39;ll be writing low-level `Buffer.BlockCopy` code.  Perhaps using unsafe code.  

How to convert an object to a byte array in C#

How do I get multi-line text on a WPF Button using only C#? I have seen examples of using `&lt;LineBreak/&gt;` in XAML, but my buttons are created completely programmatically in C#. The number and labels on the buttons correspond to values in the domain model, so I don&#39;t think I can use XAML to specify this.

I have tried the naive approach below, but it does not work.

    Button b = new Button();
    b.Content = &quot;Two\nLines&quot;;

or

    b.Content = &quot;Two\r\nLines&quot;;

In either case, all i see is the first line (&quot;Two&quot;) of the text.


Multiline Text in a WPF Button

I have a .Net Windows service. I want to create an installer to install that windows service.

Basically, it has to do the following:

 1. Pack `installutil.exe` (Is it required?) 
 2. Run `installutil.exe` MyService.exe 
 3. Start MyService

Also, I want to provide an uninstaller which runs the following command:

    installutil.exe /u MyService.exe

How to do these using Inno Setup?

Inno Setup for Windows service?

Suppose I had a string:

    string str = &quot;1111222233334444&quot;; 

How can I break this string into chunks of some size?

e.g.,  breaking this into sizes of 4 would return strings:

    &quot;1111&quot;
    &quot;2222&quot;
    &quot;3333&quot;
    &quot;4444&quot;


Splitting a string into chunks of a certain size

Let us suppose the following table (e.g. a result of several inner join statements):

    id | column_1 | column_2
    ------------------------
     1 |  1       | 
     2 |  2       | 2
     3 |          | 3

Which you could for example get from the following statement:

    select a.id, t1.column_1, t2.column_2
    from a
    left join t1 on a.id = t1.id
    left join t2 on a.id = t2.id

Now, if i&#39;d like to sum up t1.column\_1 and t2.column\_2 as follows

    select 
        a.id, 
        t1.column_1, 
        t2.column_2,
        (t1.column_1 + t2.column_2) as cumulated
    from a
    left join t1 on a.id = t1.id
    left join t2 on a.id = t2.id
    
The result will look as follows:

    id | column_1 | column_2 | cumulated
    ------------------------------------
     1 |  1       | NULL     | NULL
     2 |  2       | 2        | 4
     3 |  NULL    | 3        | NULL
     
My question basically is: is there a way to typecast NULL into 0 in order to do some math? 

I have tried `CONVERT(t1.column_1, SIGNED)` and `CAST(t1.column_1 as SIGNED)`, but a `NULL` stays a `NULL`.

MySQL: Typecasting NULL to 0

Say I have records with **ID** `3,4,7,9` 

I want to be able to go from one to another by navigation via next/previous links. 

The problem is, that I don&#39;t know **how to fetch record with nearest higher ID**.

So when I have a record with **ID** `4`, I need to be able to fetch next existing record, which would be `7`. 

**The query would probably look something like**

    SELECT * FROM foo WHERE id = 4 OFFSET 1

**How can I fetch next/previous record without fetching the whole result set and manually iterating?**

I&#39;m using MySQL 5.

How to get next/previous record in MySQL?

I&#39;m in the business of making website and applications that are *not* mission critical -&gt; eg. banking software, space flight, intensive care monitoring application, etc. You get the idea.

So, with that massive disclaimer, is it bad using the NOLOCK hint in some Sql statement? A number of years ago, it was suggested by a fellow Sql Administrator that I should use NOLOCK if I&#39;m happy with a &quot;dirty read&quot; which will give me a bit more performance out of my system because each read doesn&#39;t lock the table/row/whatever.

I was also told that it&#39;s a great solution if I&#39;m experiencing dead-locks. So, I started following that thought for a few years until a Sql guru was helping me with some random code and noticed all the NOLOCKS in my sql code. I was politely scolded and he tried to explain it to me (why it&#39;s not a good thing) and I sorta got lost. I felt that the essence of his explanation was &#39;it&#39;s a band-aid solution to a more serious problem .. especially if you&#39;re experiencing deadlocking. As such, fix the root of the problem&#39;. 

I did some googling recently about it and came across [this post][1].

So, can some sql db guru sensei&#39;s please enlighten me? 


  [1]: http://blogs.msdn.com/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

Is the NOLOCK (Sql Server hint) bad practice?

I&#39;m using a stored procedure in MySQL, with a CASE statement.

In the ELSE clause of the CASE ( equivalent to default: ) I want to select and return an empty result set, thus avoiding to throw an SQL error by not handling the ELSE case, and instead return an empty result set as if a regular query would have returned no rows.

So far I&#39;ve managed to do so using something like:  
&lt;code&gt;Select NULL From users Where False&lt;/code&gt;

But I have to name an existing table, like &#39;users&#39; in this example.
It works, but I would prefer a way that doesn&#39;t break if eventually the table name used is renamed or dropped.

I&#39;ve tried `Select NULL Where False` but it doesn&#39;t work.

Using `Select NULL` does not return an empty set, but one row with a column named NULL and with a NULL value.



How to select an empty result set?

So Oracle has NULLS FIRST, which I can use to have null values sorted at the top followed by my column value in descending order:

    ORDER BY date_sent NULLS FIRST

What is comparable in SQL Server?  There are these alternatives, assuming the date values are NULL or in the past:

    ORDER BY ISNULL(date_sent, GETDATE()) DESC
    ORDER BY (CASE WHEN t.setinactive IS NULL THEN 1 ELSE 2 END), t.setinactive DESC
    ORDER BY -CAST(date_sent as int) ASC

Any others?

SQL Server equivalent to Oracle&#39;s NULLS FIRST?

I have this function in SQL Server to replace single quotes.

But when I insert a single quote it throws an error on `Replace(@strip,&#39;&#39;&#39;,&#39;&#39;))`:

    Create Function [dbo].[fn_stripsingleQuote]
        (@strStrip varchar(Max))
        returns varchar
    as
    begin
        declare @CleanString varchar(Max)
        SET @var=(Replace(@strip,&#39;&#39;,&#39;&#39;))

        return @var
    end


Replace single quotes in SQL Server

How to list row count of each table in the database. Some equivalent of 

    select count(*) from table1
    select count(*) from table2
    ...
    select count(*) from tableN

I will post a solution but other approaches are welcome

Query to list number of records in each table in a database

I need a query in sql to get total columns in a table.Can anybody help?

To get total number of columns in a table in sql

I found one question answered with the `Row_Number()` function in the where clause. When I tried one query, I was getting the following error:

&gt;&quot;Msg 4108, Level 15, State 1, Line 1 
Windowed functions can only appear in the SELECT or ORDER BY clauses.&quot;

Here is the query I tried. If somebody knows how to solve this, please let me know.

    SELECT employee_id 
    FROM V_EMPLOYEE 
    WHERE row_number() OVER ( ORDER BY employee_id ) &gt; 0 
    ORDER BY Employee_ID

SQL Row_Number() function in Where Clause

Is there a better way of doing a query like this:

    SELECT COUNT(*) 
    FROM (SELECT DISTINCT DocumentId, DocumentSessionId
          FROM DocumentOutputItems) AS internalQuery

I need to count the number of distinct items from this table but the distinct is over two columns.

My query works fine but I was wondering if I can get the final result using just one query (without using a sub-query)

Counting DISTINCT over multiple columns

Consider the need to create a resultset of dates. We&#39;ve got start and end dates, and we&#39;d like to generate a list of dates in between.

    DECLARE  @Start datetime
             ,@End  datetime
    DECLARE @AllDates table
            (@Date datetime)

    SELECT @Start = &#39;Mar 1 2009&#39;, @End = &#39;Aug 1 2009&#39;
    
    --need to fill @AllDates. Trying to avoid looping. 
    -- Surely if a better solution exists.

Consider the current implementation with a `WHILE` loop:

    DECLARE @dCounter datetime
    SELECT @dCounter = @Start
    WHILE @dCounter &lt;= @End
    BEGIN
     INSERT INTO @AllDates VALUES (@dCounter)
     SELECT @dCounter=@dCounter+1 
    END

**Question:** How would you create a set of dates that are within a user-defined range using T-SQL? Assume SQL 2005+. If your answer is using SQL 2008 features, please mark as such.

Generate a resultset of incrementing dates in TSQL

I have a double in Java and I want to check if it is `NaN`.
What is the best way to do this?

How do you test to see if a double is equal to NaN?

I need to round a double to nearest five. I can&#39;t find a way to do it with the Math.Round function. How can I do this?

What I want:

    70 = 70
    73.5 = 75
    72 = 70
    75.9 = 75
    69 = 70

and so on..

Is there an easy way to do this?

Round to nearest five

What is the biggest &quot;no-floating&quot; integer that can be stored in an IEEE 754 double type without losing precision ?

biggest integer that can be stored in a double

I want to round up double value in two decimal places in c# how can i do that?

    double inputValue = 48.485;

after round up

    inputValue = 48.49;


###Related: https://stackoverflow.com/questions/164926/c-sharp-how-do-i-round-a-decimal-value-to-2-decimal-places-for-output-on-a-pa

Round double in two decimal places in C#?

I have code to calculate the percentage difference between 2 numbers - `(oldNum - newNum) / oldNum * 100;` - where both of the numbers are `double`s. I expected to have to add some sort of checking / exception handling in case oldNum is 0. However, when I did a test run with values of 0.0 for both oldNum and newNum, execution continued as if nothing had happened and no error was thrown. Running this code with `int`s would definitely cause an arithmetic division-by-zero exception. Why does Java ignore it when it comes to `double`s?


Content Type	Original Author	Original Content on Stackoverflow
Question	MetaGuru	View Question on Stackoverflow
Solution 1 - C#	David	View Answer on Stackoverflow
Solution 2 - C#	D'Arcy Rittich	View Answer on Stackoverflow
Solution 3 - C#	Otávio Décio	View Answer on Stackoverflow
Solution 4 - C#	Philippe Leybaert	View Answer on Stackoverflow
Solution 5 - C#	Michal Dobrodenka	View Answer on Stackoverflow

Which sql server data type best represents a double in C#?

C# Problem Overview

C# Solutions

Solution 1 - C#

Solution 2 - C#

Solution 3 - C#

Solution 4 - C#

Solution 5 - C#

How to show/reveal hidden or invisible characters in NetBeans?

Is there a good Python library that can parse C++?

Attributions