ISNumeric is buggy in SQL Server?
When I do
ISNUMERIC('0E1') = 1, it returns true. Can anyone explain how SQL server qualifies 'E' as numeric?
Is this the right way to check numbers in SQL? Sorry I am new to T-SQL.
I have VS2012 Ultimate installed. In the Installed products it states I have SQL Server Data Tools 11.1. When I go to SQL Server 2012 and click on the SQL Server Data Tools Menu option, VS2010 starts
I have 2 databases on the same SQL Server. Is it possible to have one in PST and the other in EST?
A reliable coder friend told me that Python's current multi-threading implementation is seriously buggy - enough to avoid using altogether. What can said about this rumor?
About SQL Server 2012 SMO 1. What types / methods / properties are added to v188.8.131.52 (2012) compared to v10.0.0.0 (2008)? 2. Should I use app.config to set assembly binding redirection to allow users
Is it possible to store Subversion meta data in SQL Server? We want a SQL Server based Subversion.
The reserve column is a varchar, to perform sums on it I want to cast it to a deciaml. But the SQL below gives me an error select cast(Reserve as decimal) from MyReserves Error converting data type v
i just installed sql server 2008 r2 and SQL Server Management Studio. After installation i found that the SQL Server Management Studio has not been installed. i wanted to install SQL Server Management
This question already has an answer here: CAST and IsNumeric 9 answers Why does the following Query in SQL return true?? I expected it to be false as it cannot be converted into an int or numer
Does a JOIN query under SQL Server always spawn an new thread? In general how does SQL Server control thread spawning? Thanks, -peter
What's the best free tool that can compare sql server database objects and/or data?
To log on to the SQL Server, I have to log on to the remote server (Windows 2003) and open the Management Studio and type the SQL Server address and Domain/Name, Password. This is been setup for secur
When I attempt to make a connection from my console app to my sqlExpress. I get the following error: The user is not associated with a trusted SQL Server connection. I have: Switched users Switche
I have a SQL Server project in VS 2010 that references an assembly in a SQL Server 2008 database. If I drop and recreate the assembly in the database with a new version, how can I refresh Visual Studi
Can SQL Server replicate TO SQL Server Compact Edition? To put this in some relevant context, I'm considering the implications of using SQL Server CE as a near line edge cache instead of querying &
How can I Convert the SQL Server 2008 to SQL Server 2005 I need the Data of the database and not only the structure using the generate script
i am developing an application that reads and writes data remotely on an SQL Server, the application is ment to run on an android devices. i know that i have to make a java server that uses socket con
Are there any issues backing up a database from SQL Server 2008, and then importing it into SQL Server 2005? I had upgraded to SQL Server 2008, but 2008 seems to be too problematic so now I want to do
What is the best way to access sql server from python is it DB-API ? Also could someone provide a such code using the DB-API how to connect to sql server from python and excute query ?
How can I use C# to stop SQL Server?
I have SQL Server 2008 Express on my pc, and I want to install SQL Server 2012 instead. Do I have to uninstall SQL Server 2008 Express first? Do I have to backup my databases first? Same question abou
If I install Multiple instances of SQl Server Express Edition (2005) on same DB server, will there be any licensing issue? DB is used by web sites. Since SQL Server Express Edition is free, but I don
My question is, why segment is important for SQL Server and is it enhance the SQL Server performance? If it is enhance the performance of SQL server, how? Please give the suitable example. Thanks in
How do I rename a database in Server Explorer on Visual Studio 2008? I changed the filename using Rename on the context menu, but that just changed the filename, not the name in SQL Server (2005 Expre
I changed my database from SQL Server 2005 to SQL Server 2008 and now I'm having this error message. The site was working perfectly before changing the database Server Error in '/' Application. Compil
ISNUMERIC returns 1 when the input expression evaluates to a valid numeric data type; otherwise it returns 0 (MSDN reference). So why is the output of this query 1? select ISNUMERIC('5d9')
Why would the following query return Error converting data type varchar to bigint? Doesn't IsNumeric make the CAST safe? I've tried every numeric datatype in the cast and get the same Error convert
what are some of the cases that will cause a SQL Server 2005 cursor to deallocate prematurely?
When in 'SQL Server Configuration Manager' I see, under 'SQL Server Services', 2 items that look like SQL Server's: SQL Server (sqlexpress) SQL Server (mssqlserver) Does that mean I have 2 versions
How can I Filter only my calls to Shared SQL Server using a shared login account when debugging? I am using SQL Profiler and was curious if anybody knows the Column Filters I can use to focus only to
So I just spent 5 hours troubleshooting a problem which turned out to be due not only to the old unreliable ISNUMERIC but it looks like my problem only appears when the UDF in which ISNUMERIC is decla
I have a requirement to use Sql replication from a sql server 2005 instance to a Sql 2000 instance over a vpn. The vpn is permanent between the 2 sites and there are only a few tables that need replic
Do visual studio 2010 include already Sql Server instance, or I need to install Sql Server developer edition to develop an application that need a Sql Server db. If it installs a Sql Server express ed
We have 2 databases and we need data to be transferred from db 1 to db 2. How can I do that (in SYBASE there are proxy tables) in SQL Server?
I'm having problems trying to get IsNumeric to work properly with Request.QueryString. The server is Windows 2008 R2 / IIS7.5 My code could not be any simpler: <%@ LANGUAGE=VBScript %> <% Re
I am using SQL Server 2008 Enterprise. I am using the following statement in SQL Server Management Studio as a part of a store procedure, and there is following error (compile error when I press F5 to
We have a SQL Server 2008 Enterprise database with two different schemas, a locked one that we maintain and an open one that we allow outside development teams to add to and modify for their own needs
I have code that works for querying data from a SQL Server CE table and populating a generic list with it. That can be seen here: But a comment there indicates I should trade in my horse-and-buggy fo
I am learning SQL Server by exercising some problems. In one of that problems I have 4 database tables: ORDERS, SHIPMENTS, WHFICHES and ATTACHMENTS One of them is hold attachment references to other t
I have a couple of columns in my application that need to encrypted for security reasons. How is this possible with SQL Server 2008? Also, would I need to always manually decrypt them or will it happe
I've been googling for hours now. I installed: SQL Server Compact Edition version 4.0 SQL Server 2005 Management Studio I could connect to SQL Server CE with 2005, but had no Data Import Wizard to
Is there any way to return query work progress from SQL Server? For example I have stored procedure that returns n rows. And I need to know how many time is it lost to finish. Thanks.
i am getting the following error: Incorrect syntax near 'cast', expected 'AS'. on this line: use SalesDWH go if (select isnumeric(result))=1 begin select max(cast(result) as decimal(10,2)) from test
If I have a VIEW with a bunch of INNER JOINs but I query against that VIEW SELECTing only columns that come from the main table, will SQL Server ignore the unnecessary joins in the VIEW while executin
I have Installed Microsoft® SQL Server® 2014 Express , but I can't find SQL Server Services to run it in the SQL Server Configuration Manager, so I can't connect to SQL server. It's a problem becau
In SQL Server, the query SELECT custid, country, region, city FROM Sales.Customers WHERE region = N'WA' what is the meaning of 'N' in the where clause ? I remove it, get same result. Thanks.
What is a good method of writing reports using PHP and SQL Server? Is there a third party vendor that supports SQL Server?
Could you please tell me if there is any equivalent of Access' DISTINCTROW for SQL Server?
How can I populate jquery grid from SQL server?