Hello,
I created a view in SQL Server Express 2005 that contained CASE END
statements.
I use this view in a .NET 2005 project, which works fine on my machine.
When I deploy my project to a machine that is running SQL Server 200, I get
the following error:
The Query Designer does not support the CASE SQL contruct.
Any way around this'
TIA,
Amber"amber" <amber@.discussions.microsoft.com> wrote in message
news:C5E9214E-628F-4CC3-8CC4-4DD7A5347999@.microsoft.com...
> Hello,
> I created a view in SQL Server Express 2005 that contained CASE END
> statements.
> I use this view in a .NET 2005 project, which works fine on my machine.
> When I deploy my project to a machine that is running SQL Server 200, I
> get
> the following error:
> The Query Designer does not support the CASE SQL contruct.
> Any way around this'
> TIA,
> Amber
>
If you could include the CASE statement that you used, and any other
relevant DDL we could be more helpful.
Rick Sawtell|||Which SQL 200x? :) 2000 or 2005?
The way around this: don't use the Query Designer. Script it and run the
code in Query Analyzer.
amber wrote:
> Hello,
> I created a view in SQL Server Express 2005 that contained CASE END
> statements.
> I use this view in a .NET 2005 project, which works fine on my machine.
> When I deploy my project to a machine that is running SQL Server 200, I ge
t
> the following error:
> The Query Designer does not support the CASE SQL contruct.
> Any way around this'
> TIA,
> Amber
>|||"amber" wrote:
> The Query Designer does not support the CASE SQL contruct.
> Any way around this'
> TIA,
> Amber
>
Yes. Learn to write SQL instead of using the Query Designer. The designer is
a crutch that will do you know favours in the long run. If you want to use
anything more than very basic stuff then you must avoid it.
David Portas
SQL Server MVP
--
Showing posts with label express. Show all posts
Showing posts with label express. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
Case sensitive variables SQL Express
Hi,
I suddenly ran into a serious problem. We installed a new SQL Express 2005
SP1 on a different server and now it seems to be case sensitive with the
variables in stored procedures:
----
ALTER PROCEDURE [dbo].[GetUserID] (@.UserName varchar(50))
AS
BEGIN
DECLARE @.ret bigint;
SET NOCOUNT ON;
SELECT @.ret = UserID FROM Users WHERE UserName Like @.Username;
RETURN ISNULL(@.ret,-1);
END
----
It fails on the @.Username which is declared as @.UserName
This did not happen on our other SQL Express server. It does not have SP1
either.
Please help!!
DavidHi David,
Most likely your problem is related to different instance collation on the
different servers. All identifiers for variables, GOTO labels and temp
tables are in the default collation of the instance. Probably your new
instance of SQL Server Express is installed with a case sensitive collation.
Here is how to change it if needed:
http://msdn2.microsoft.com/en-us/library/ms179254.aspx
HTH,
Plamen Ratchev
http://www.SQLStudio.com
I suddenly ran into a serious problem. We installed a new SQL Express 2005
SP1 on a different server and now it seems to be case sensitive with the
variables in stored procedures:
----
ALTER PROCEDURE [dbo].[GetUserID] (@.UserName varchar(50))
AS
BEGIN
DECLARE @.ret bigint;
SET NOCOUNT ON;
SELECT @.ret = UserID FROM Users WHERE UserName Like @.Username;
RETURN ISNULL(@.ret,-1);
END
----
It fails on the @.Username which is declared as @.UserName
This did not happen on our other SQL Express server. It does not have SP1
either.
Please help!!
DavidHi David,
Most likely your problem is related to different instance collation on the
different servers. All identifiers for variables, GOTO labels and temp
tables are in the default collation of the instance. Probably your new
instance of SQL Server Express is installed with a case sensitive collation.
Here is how to change it if needed:
http://msdn2.microsoft.com/en-us/library/ms179254.aspx
HTH,
Plamen Ratchev
http://www.SQLStudio.com
Case sensitive variables SQL Express
Hi,
I suddenly ran into a serious problem. We installed a new SQL Express 2005
SP1 on a different server and now it seems to be case sensitive with the
variables in stored procedures:
----
ALTER PROCEDURE [dbo].[GetUserID] (@.UserName varchar(50))
AS
BEGIN
DECLARE @.ret bigint;
SET NOCOUNT ON;
SELECT @.ret = UserID FROM Users WHERE UserName Like @.Username;
RETURN ISNULL(@.ret,-1);
END
----
It fails on the @.Username which is declared as @.UserName
This did not happen on our other SQL Express server. It does not have SP1
either.
Please help!!
DavidHi David,
Most likely your problem is related to different instance collation on the
different servers. All identifiers for variables, GOTO labels and temp
tables are in the default collation of the instance. Probably your new
instance of SQL Server Express is installed with a case sensitive collation.
Here is how to change it if needed:
http://msdn2.microsoft.com/en-us/library/ms179254.aspx
HTH,
Plamen Ratchev
http://www.SQLStudio.com
I suddenly ran into a serious problem. We installed a new SQL Express 2005
SP1 on a different server and now it seems to be case sensitive with the
variables in stored procedures:
----
ALTER PROCEDURE [dbo].[GetUserID] (@.UserName varchar(50))
AS
BEGIN
DECLARE @.ret bigint;
SET NOCOUNT ON;
SELECT @.ret = UserID FROM Users WHERE UserName Like @.Username;
RETURN ISNULL(@.ret,-1);
END
----
It fails on the @.Username which is declared as @.UserName
This did not happen on our other SQL Express server. It does not have SP1
either.
Please help!!
DavidHi David,
Most likely your problem is related to different instance collation on the
different servers. All identifiers for variables, GOTO labels and temp
tables are in the default collation of the instance. Probably your new
instance of SQL Server Express is installed with a case sensitive collation.
Here is how to change it if needed:
http://msdn2.microsoft.com/en-us/library/ms179254.aspx
HTH,
Plamen Ratchev
http://www.SQLStudio.com
Thursday, February 16, 2012
Capacity of SQL Server 2005 Express Edition
I am just starting to build my apps in asp.net 2.0. I have build apss in v. 1.x before using sql server 2000. However, before i make the shift, I would like to know the advantages and disadvantages of using the sql server 2005 express edition then using the sql server 2000.
for example;
+ How many data can it store?
+ How many concurrent users it supports.
+ Advantages and disadvantages of using sql server 2005 express ed.
+ Any other relevant information that developers should know / beware / watch out for when using sql server 2005 express edition.
Note: I am not asking about the actual SQL Server 2005 but the express edition!
Regards and thanks in advance
Microsoft'sSQL Server home page is a good place to start your research. TheEditions link will bring you the theSQL Server 2005 Features Comparison table which will answer most of your questions.
Tuesday, February 14, 2012
Can't use Virtual PC for VS 2005 Pro with SQL Server Express
I am unable to successfully complete an install of Visual Studio 2005 with SQL Server 2005 Express on a Virtual PC 2004 image, which seems to be a pretty reasonable expectation. The installation completes successfully all of the way through in a Windows XP Pro SP2 image, but at the end the installation program informs you that SQL Server Express has failed to install, with no other explanation. No setup log files give any information as to why the installation failed. Then I see in the fine print for SQL Server Express downloads that "There is no support in this release for Virtual Server, Virtual PC". (http://download.microsoft.com/download/c/c/6/cc66b572-a402-4c6a-8233-b9c7d05840c7/RequirementsSQLEXP2005.htm)
Is this indeed the case that we essentially cannot run the full VS 2005 installation in Virtual PC? Is there no workaround for this problem?
Express is certainly supported on Virtual PC and Virtual Server. It's hard to say for sure at this late date but I'm going to blame a bug in VS that was fixed by RTM.
Is this indeed the case that we essentially cannot run the full VS 2005 installation in Virtual PC? Is there no workaround for this problem?
Express is certainly supported on Virtual PC and Virtual Server. It's hard to say for sure at this late date but I'm going to blame a bug in VS that was fixed by RTM.
Can't use Virtual PC for VS 2005 Pro with SQL Server Express
I am unable to successfully complete an install of Visual Studio 2005 with SQL Server 2005 Express on a Virtual PC 2004 image, which seems to be a pretty reasonable expectation. The installation completes successfully all of the way through in a Windows XP Pro SP2 image, but at the end the installation program informs you that SQL Server Express has failed to install, with no other explanation. No setup log files give any information as to why the installation failed. Then I see in the fine print for SQL Server Express downloads that "There is no support in this release for Virtual Server, Virtual PC". (http://download.microsoft.com/download/c/c/6/cc66b572-a402-4c6a-8233-b9c7d05840c7/RequirementsSQLEXP2005.htm)
Is this indeed the case that we essentially cannot run the full VS 2005 installation in Virtual PC? Is there no workaround for this problem?
Express is certainly supported on Virtual PC and Virtual Server. It's hard to say for sure at this late date but I'm going to blame a bug in VS that was fixed by RTM.
Is this indeed the case that we essentially cannot run the full VS 2005 installation in Virtual PC? Is there no workaround for this problem?
Express is certainly supported on Virtual PC and Virtual Server. It's hard to say for sure at this late date but I'm going to blame a bug in VS that was fixed by RTM.
Can't use SQL Express in VS2005
When I try to add a new database to App_Data in a VS2005sp1 project I get "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user interface".
I have SQL2005sp2 and SQL Express on the system, both services are running, and an instance of the latter called SQLExpress which I can use through SQL Server Management Studio. sp_configure user instances enabled is set to 1. The SQL Server Instance Name in Options | Database Tools | Data Connections is set to SQLExpress ...
I have no idea how to proceed .. any ideas anyone?
Thanks
John
Most causes of this error are solved by deleting the folder where we store the SQL Express User Instance system files, which is C:\Documents and Settings\<username>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS. You may need to reboot your computer after this, so just eliminate any concerns and reboot.
The once cause that this will not resolve is if you are working thorugh remote desktop. There is bug in windows that results in the remote login not have certain permissions. The problem is explained in http://support.microsoft.com/Default.aspx?id=896613 and you will need to call Microsoft Support to obtain the Hotfix for the problem.
Hopefully this helps.
Mike
|||Thanks, Mike
That was it. Problem now solved.
John
|||I had the following trouble.- Installed MSSQLEXPRESS
- Installed Visual Studio 2005
- Uninstalled MSSQLEXPRESS
- Installed MSSQLEXPRESS
->the bloody error started appearing.
The suggested method worked perfectly!!
I killed the folder, restarted Studio, now can connect to the databases.
Cheers,
Valekm
Friday, February 10, 2012
Can''t understand how to connect SQL SERVER EXPRESS 2005
I can't understand how I configure SQLServerExpress2005 in my computer. I use Visual Studio 2005. How I connect the database from it? I can't configure SQL. Please help me..
Do you just want to scroll through the objects within the database or do you want to make a call to the database from your code ? Is the database server attached oder a user instance ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||to connect to Database from Application change the connection string. Refer
http://www.connectionstrings.com/?carrier=sqlserver2005
If you have installed SQLServer Management Studio Express you can connection to database. This is the tool comes with the express to do all the managemnt works in SQL Server
Madhu
Can''t understand how to connect SQL SERVER EXPRESS 2005
I can't understand how I configure SQLServerExpress2005 in my computer. I use Visual Studio 2005. How I connect the database from it? I can't configure SQL. Please help me..
Do you just want to scroll through the objects within the database or do you want to make a call to the database from your code ? Is the database server attached oder a user instance ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||to connect to Database from Application change the connection string. Refer
http://www.connectionstrings.com/?carrier=sqlserver2005
If you have installed SQLServer Management Studio Express you can connection to database. This is the tool comes with the express to do all the managemnt works in SQL Server
Madhu
Can''t understand how to connect SQL SERVER EXPRESS 2005
I can't understand how I configure SQLServerExpress2005 in my computer. I use Visual Studio 2005. How I connect the database from it? I can't configure SQL. Please help me..
Do you just want to scroll through the objects within the database or do you want to make a call to the database from your code ? Is the database server attached oder a user instance ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||to connect to Database from Application change the connection string. Refer
http://www.connectionstrings.com/?carrier=sqlserver2005
If you have installed SQLServer Management Studio Express you can connection to database. This is the tool comes with the express to do all the managemnt works in SQL Server
Madhu
Subscribe to:
Posts (Atom)