.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

If else statements, evaluations and variables!

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :Sql Server

Hello folks,

Trying my hand at a slightly more complicated statement that I am used to (Selects,updates,inserts and deletes).

This is what I'm trying todo:

declare @cap int, @count int
select @cap = regcap from tblLicenceControl where RegCode='GGGGG-GGGQQ-QQHCH-VHGVC'
select @count= RegCount from tblLicenceControl where RegCode='GGGGG-GGGQQ-QQHCH-VHGVC'
if(@count) < (@cap)
	print 'You can register'
	print 'You can't register'

I can't get it to hit the 'You can register' statement. Is this because the else is always run?

FYI, count is null at this stage and cap is 1.

Can I even do this or is this not possible in SQL.

Thanks for any assistance.


View Complete Post

More Related Resource Links

Temporary tables in SQL Server vs. table variables

When writing T-SQL code, you often need a table in which to store data temporarily when it comes time to execute that code. You have four table options: normal tables, local temporary tables, global temporary tables and table variables. I'll discuss the differences between using temporary tables in SQL Server versus table variables.

ListView DataPager with SQL-Statements that already return only paged data.



As far as I understand the ListView-Control and the DataPager-Control, they work like this: The ListView gets its datarows from its data source, then the DataPager causes the ListView to display only a subset of those rows.

So what, when I want to use custom databinding for the ListView, that *already* gets the certain subset from SQL-Server (for better performance). Can I and how can I use the DataPager then?

Thanx, S.

Session and Application Variables


I have a web application in which i need to logout the user if he clicks the logout button or even if he closes his browser window. On Logout button click, i am doing session.Abandon(), but how to go about his browser window close.

Can anybody help with a code sample.

Can IronPython use dynamic variables?


I am building a small application that can

1. Dynamically load 2 text boxes on a web form

2. Build a logic on those textboxes in IronPython to sum them and return the result.

3. I have already built a IPY script that does some opearions on a static text boxes. How to build a script on the dynamic textboxes?

Windows With C++: X64 Debugging With Pseudo Variables And Format Specifiers


This month we explain how pseudo variables and format specifiers provide a wealth of information for use in debugging.

Kenny Kerr

MSDN Magazine December 2008

Multiple update statements per row in Gridview Edit


I want to set up a gridview that will display data like this

WeekEndingDate Project Category Sun Mon Tues Wed Thu Fri Sat
8/14/2010      proj1   test     2   1   2    3   2   1   0
8/21/2010      proj1   test     0   2   2    2   2   1   0
8/28/2010      proj1   test     0   1  

ASP.NET MVC 2 - I have a serious concern about the management of session variables.


I have a serious concern about the management of session variables.
I state that I have Windows Web Server 2008.
Currently values in the controller and call a session variable like this:
I have an action in as:
System.Web.HttpContext.Current.Session ['name'] = id_userlogged;

CSS Variables


HI Folks,

Does ASP.Net support CSS variables ?

I cannot write an @variables at rule in the css file. No such at-rule is supported.

Any help highly appreciated.

Thanks in advance,


Defining session variables...



This is a pretty basic question.

I have some code where I need to define a session variable  however it's coming back as Nothing when the code is executed. Here's the code:

' Default Currency

REQCURR = Request.Querystring("p_DCURR")
'If not explicitly specified, try to get it from session

If (REQCURR = "") Then

     If (Session("REQCURR") <> "") Then
          REQCURR = Session("REQCURR")

          'Here is the session variable I'm trying to define:
          Session("REQCAD") = 0
          REQCURR = ""
     End If

End If


So, for some reason that Session("REQCAD") = 0 has no value instead of having a value of 0.

Any thoughts?


BinaryFormatter, SortedSet base class and a few instance variables.

/* This example successfully serializes and deserializes the SortedSet<string> base contents, but all the instance variables show up uninitialized. Here's the output: n1: 0 n2: 0 str: s == "String 1" s == "String 2" s == "String 3" Any ideas? */ using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Runtime.Serialization.Formatters.Binary; using System.Runtime.Serialization; using System.IO; [Serializable] public class MyObject : SortedSet<string> {     public MyObject() : base() { }     protected MyObject(SerializationInfo info, StreamingContext context)         : base(info, context)     {     }     public int n1 = 0;     public int n2 = 0;     public String str = null; } namespace BasicBinarySerializationInheritanceFromSortedSet {     class BasicBinarySerializationInheritenaceFromSortedSetTest     {         static void Main(string[] args)         {             {                 MyObject obj = new MyObject();   &nb

Multiple statements in SSCE 3.5 SP2?

Hi all, I'm just wondering whether it's possible at all to execute multiple statements & multiple heterogeneous statements using the semicolon (";") separator.  SSCE balks at it right now if I issue via ADO.NET command text similar to the following (line separator is your typical \r\n): insert into Foo (id, name) values (1, 'foo1'); insert into Bar (id, name) values (1, 'bar1'); update Goo g set g.name = 'Goo1', g.fooId = 1, g.barId = 1 where id = 1; SQL Server Management Studio executes it just fine, which led me to believe that I could do it via ADO.NET. Can someone who knows please clarify?  What do I have to do in order to batch commands to ADO.NET? Thanks, Matthew

Enumerating Variables & Arguments in Rehosted Designer

I'm trying to enumerate the variables and arguments of a workflow after I load it into my rehosted designer.  I see that I can use ActivityMetadata.GetArgumentsWithReflection() and ActivityMetadata.GetVariablesWithReflection() but those require that I have ActivityMetadata to start with.  So the real question is, how do I get the ActivityMetadata once I've done MyWorkflowDesigner.Load(XamlPath);?Thanks in advance.ChuckChuck Berg | Consulting Engineer | Corporate IT - Station Casinos, Inc.

How to use variables in WCF as return in WCF GET properties?

Hi everyone,   I'm currently working on a project wherein i need to call a WCF web service. The web service has get_<method name> properties. those properties are working fine if the property has assigned a value within them. for example:   public String Description { get { return "Hello from SVC!!"; } }   ^ above will work fine when i call it on my client app.   but if i use a variable value as a return. it will not return the value of the variable (empty/blank). for example:   public class MYSVC : IMYSVC { private String varDescription; public void SetValue(String Description) { varDescription = "Test"; } public String Description { get { return varDescription; } }   ^above will not work. it will only return none.   Did i miss something? also just in case here's how a call those properties in the interface (fyi):       String Description    {        [OperationContract]        get;    }  

Need help to pass variables to Look UP

HI Guys we are using ssis 2008 I want to pass  the variables to look up for that I used partial cache Modify Sql statement when I click the parameters button I got an error  system runtime interopservices comexception what can I do to pass the variables start date and end date date ranges   Thanks in advance  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend