¡@

Home 

c# Programming Glossary: mssql

C# How to get SQL Server installation path programatically?

http://stackoverflow.com/questions/1165576/c-sharp-how-to-get-sql-server-installation-path-programatically

in sqlServerKey.GetSubKeyNames if subKeyName.StartsWith MSSQL. using RegistryKey instanceKey sqlServerKey.OpenSubKey subKeyName.. instanceKey.GetValue .ToString if instanceName MSSQLSERVER say string path instanceKey.OpenSubKey @ Setup .GetValue..

Cyrillic encoding in C#

http://stackoverflow.com/questions/12013659/cyrillic-encoding-in-c-sharp

encoding in C# I have a bunch of Cyrillic like text in a MSSQL database and need to convert it to Cyrillic in C#. So... áîò..

What represents a double in sql server?

http://stackoverflow.com/questions/1209181/what-represents-a-double-in-sql-server

type which is more like a 128 bit floating point number. MSSQL float does not have exactly the same precision as the 64 bit.. be more equivalent in SQL to the real float 24 type in MSSQL than float float 53 . In your specific use case... All you need.. Float 24 or decimal 8 5 will best fit your needs in MSSQL and using float in C# is good enough you don't need double...

Speed up update of 185k rows in SQL Server 2008?

http://stackoverflow.com/questions/12292644/speed-up-update-of-185k-rows-in-sql-server-2008

file in seconds. What would be the best way to update MSSQL table with that data What I've tried Easiest way read binary.. Combine 200 update queries and send them at once to the MSSQL. In this case update takes 8 to 10 hrs. Combine 500 queries..

Programmatically generate script for all objects in a database

http://stackoverflow.com/questions/1695738/programmatically-generate-script-for-all-objects-in-a-database

one file for all objects. The Generate Scripts function of MSSQL typically does not consider references and dependencies to determine..

NHibernate Code Generation

http://stackoverflow.com/questions/1703254/nhibernate-code-generation

recommend I guess my criteria is that they must work with MSSQL 2008 and tools that are currently being developed would be good..

IndexOutOfRangeException on Queryable.Single

http://stackoverflow.com/questions/208533/indexoutofrangeexception-on-queryable-single

a POCO object with LINQ to SQL attributes mapping it to an MSSQL table mapping is verified as correct . The stacktrace is as..

Serialize a nullable int

http://stackoverflow.com/questions/244953/serialize-a-nullable-int

ID element at all primarily because when I use OPENXML in MSSQL it returns a 0 instead of null for an element that looks like..

Algorithm to avoid SQL injection on MSSQL Server from C# code?

http://stackoverflow.com/questions/249567/algorithm-to-avoid-sql-injection-on-mssql-server-from-c-sharp-code

to avoid SQL injection on MSSQL Server from C# code What would be the best way to avoid SQL..

Split large text string into variable length strings without breaking words and keeping linebreaks and spaces

http://stackoverflow.com/questions/2815021/split-large-text-string-into-variable-length-strings-without-breaking-words-and

The blue dog Line 6 dug under the fence. All this in C# or MSSQL is it possible c# string split words share improve this question..

Check if a SQL table exists

http://stackoverflow.com/questions/464474/check-if-a-sql-table-exists

bool exists try ANSI SQL way. Works in PostgreSQL MSSQL MySQL. var cmd new OdbcCommand select case when exists select..

How to pass table value parameters to stored procedure from .net code

http://stackoverflow.com/questions/5595353/how-to-pass-table-value-parameters-to-stored-procedure-from-net-code

sqlcommand share improve this question Looks like the MSSQL Tips article Table Value Parameters in SQL Server 2008 and .NET..

How to COUNT rows within EntityFramework without loading contents?

http://stackoverflow.com/questions/890381/how-to-count-rows-within-entityframework-without-loading-contents

part I don't get is that CASE_2 never access the DB server MSSQL . var truck context.Truck.FirstOrDefault t t.ID truckID if truck..

ExecuteReader requires an open and available Connection. The connection's current state is Connecting

http://stackoverflow.com/questions/9705637/executereader-requires-an-open-and-available-connection-the-connections-curren

current state is Connecting When attempting to connect to MSSQL database via ASP.NET online I will get the following when two..

C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

http://stackoverflow.com/questions/992189/c-sharp-linq-to-sql-how-to-express-convert-as-int

How to express &ldquo CONVERT &hellip AS INT &rdquo In MSSQL you can convert a string into an integer like this CONVERT INT..