sql - Read For Learn

How to parse XML data in SQL server table

There are many tutorial articles about xml parsing with TSQL. For example, http://www.sqlserver.info/syntax/parse-xml-with-sql-server/

Use ‘=’ or LIKE to compare strings in SQL?

To see the performance difference, try this: Comparing strings with ‘=’ is much faster.

SQL Server reports ‘Invalid column name’, but the column is present and the query works through management studio

I suspect that you have two tables with the same name. One is owned by the schema ‘dbo’ (dbo.PerfDiag), and the other is owned by the default schema of the account used to connect to SQL Server (something like userid.PerfDiag). When you have an unqualified reference to a schema object (such as a table) — one … Read more

MySQL Error 1264: out of range value for column

The value 3172978990 is greater than 2147483647 – the maximum value for INT – hence the error. MySQL integer types and their ranges are listed here. Also note that the (10) in INT(10) does not define the “size” of an integer. It specifies the display width of the column. This information is advisory only. To fix the error, change your datatype to VARCHAR. Phone and … Read more

SQL Insert Query Using C#

I assume you have a connection to your database and you can not do the insert parameters using c #. You are not adding the parameters in your query. It should look like: Updated:

“ORA-01438: value larger than specified precision allowed for this column” when inserting 3

You can’t update with a number greater than 1 for datatype number(2,2) is because, the first parameter is the total number of digits in the number and the second one (.i.e 2 here) is the number of digits in decimal part. I guess you can insert or update data < 1. i.e. 0.12, 0.95 etc. Please check NUMBER … Read more

How to run a SQL query on an Excel table?

There are many fine ways to get this done, which others have already suggestioned. Following along the “get Excel data via SQL track”, here are some pointers. Excel has the “Data Connection Wizard” which allows you to import or link from another data source or even within the very same Excel file. As part of Microsoft Office … Read more

missing FROM-clause entry for table

You typically only use an alias for a table name when you need to prefix a column with the table name due to duplicate column names in the joined tables and the table name is long or when the table is joined to itself. In your case you use an alias for VCustomer but only use it … Read more

How do I do multiple CASE WHEN conditions using SQL Server 2008?

There are two formats of case expression. You can do CASE with many WHEN as; Or a Simple CASE expression Or CASE within CASE as;

+ More