I want to use CASE statement to update some records in sql server 2005
Add a WHERE clause
sql-server
ClassNotFoundException – com.microsoft.jdbc.sqlserver.SQLServerDriver
I have a web development project using local install of Tomcat 7. I am trying to connect to SQL Server 2012 using Microsoft’s driver for jdbc (sqljdbc41.jar). The sqljdbc41.jar is in my application build path: and I am exporting it. Furthermore, in the Tomcat application directory lib folder I have also placed a copy of … Read more
SQL Server Installation – What is the Installation Media Folder?
I am installing SQL Server 2008. I have installed .NET framework 3.5. Then I got folder SQL Server 2008 and performed following steps- I clicked configuration Tools. Then I clicked SQL Server Installation Center. I clicked “Installation” hyperlink on left side. Then I clicked “New SQL server stand-alone installation or add features to an existing … Read more
MS SQL compare dates?
Should do what you need. Test Case Returns
MS SQL compare dates?
Should do what you need. Test Case Returns
Cannot open database “test” requested by the login. The login failed. Login failed for user ‘xyz\ASPNET’
Well, the error is pretty clear, no? You are trying to connect to your SQL Server with user “xyz/ASPNET” – that’s the account your ASP.NET app is running under. This account is not allowed to connect to SQL Server – either create a login on SQL Server for that account, or then specify another valid … Read more
How to create temp table using Create statement in SQL Server?
A temporary table can have 3 kinds, the # is the most used. This is a temp table that only exists in the current session. An equivalent of this is @, a declared table variable. This has a little less “functions” (like indexes etc) and is also only used for the current session. The ## is one that is the … Read more
Escape Character in SQL Server
To escape ‘ you simly need to put another before: ” As the second answer shows it’s possible to escape single quote like this: result will be If you’re concatenating SQL into a VARCHAR to execute (i.e. dynamic SQL), then I’d recommend parameterising the SQL. This has the benefit of helping guard against SQL injection … Read more
What is the Oracle equivalent of SQL Server’s IsNull() function?
coalesce is supported in both Oracle and SQL Server and serves essentially the same function as nvl and isnull. (There are some important differences, coalesce can take an arbitrary number of arguments, and returns the first non-null one. The return type for isnull matches the type of the first argument, that is not true for coalesce, at least on SQL Server.)
Count(*) vs Count(1) – SQL Server
There is no difference. Reason: Books on-line says “COUNT ( { [ [ ALL | DISTINCT ] expression ] | * } )“ “1” is a non-null expression: so it’s the same as COUNT(*). The optimizer recognizes it for what it is: trivial. The same as EXISTS (SELECT * … or EXISTS (SELECT 1 … Example: Same IO, same plan, … Read more