Round *UP* to the nearest 100 in SQL Server
The following should work. After reading your question, I’m not exactly sure what you want 100 to return. For this 100 returns 100. This gives the following results:
sql-server
Why do table names in SQL Server start with “dbo”?
dbo is the default schema in SQL Server. You can create your own schemas to allow you to better manage your object namespace.
Difference between database and schema
A database is the main container, it contains the data and log files, and all the schemas within it. You always back up a database, it is a discrete unit on its own. Schemas are like folders within a database, and are mainly used to group logical objects together, which leads to ease of setting … Read more
Bulk load data conversion error (truncation)
It’s picking up the commas within the comments field as delimiters, because the delimiters are not consistent. The best solution is to insure that all fields are wrapped with double quotes and set FIELDTERMINATOR to ‘”,”‘. Alternately, replace the commas with something unlikely to be in the comments (like ~) and set FIELDTERMINATOR = ‘~’.
Microsoft OLE DB Provider for SQL Server error ‘80004005’
If it is an Express instance, it is most likely not a default instance, but rather a named instance. So you probably meant: Otherwise you’ll need to show us the server properties in SQL Server Configuration Manager on that machine in order for us to be able to tell you how to correct your connection … Read more
Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
Getting rid of Integrated Security=true worked for me.
PHP Fatal error: Call to undefined function mssql_connect()
I have just tried to install that extension on my dev server. First, make sure that the extension is correctly enabled. Your phpinfo() output doesn’t seem complete. If you do not get that section in your phpinfo(). Make sure that you are using the right version. There are both non-thread-safe and thread-safe versions of the … Read more
TSQL PIVOT MULTIPLE COLUMNS
Since you want to pivot multiple columns of data, I would first suggest unpivoting the result, score and grade columns so you don’t have multiple columns but you will have multiple rows. Depending on your version of SQL Server you can use the UNPIVOT function or CROSS APPLY. The syntax to unpivot the data will be similar to: See SQL Fiddle … Read more
MSSQL Error ‘The underlying provider failed on Open’
I had this error and found a few solutions: Looking at your connection string, it looks valid. I found this blog post, the problem here is that they were using Integrated Security. If you are running on IIS, your IIS user needs access to the database. If you are using Entity Framework with Transactions, Entity Framework automatically opens and … Read more
Conversion of a datetime2 data type to a datetime data type results out-of-range value
This can happen if you do not assign a value to a DateTime field when the field does not accept NULL values. That fixed it for me!