<div>
Here you go. I have a question for you. If I create a stored procedure, is there a Select Case (like in VB.Net) in TSQL that would allow me to do the same thing?<br />
<br />
Select Case @InputValue<br />
&nbsp;Case &quot;1000&quot;<br />
&nbsp; &nbsp;Return &quot;1000&quot;<br />
&nbsp;Case &quot;1001&quot;<br />
&nbsp; &nbsp;Return &quot;1001&quot;<br />
&nbsp;Case &quot;1002&quot;<br />
&nbsp; &nbsp;Return &quot;1002&quot;<br />
&nbsp;Case &quot;1003&quot;<br />
&nbsp; &nbsp;Return &quot;1003&quot;<br />
&nbsp;Case Else<br />
&nbsp; &nbsp;Return &quot;1000&quot;<br />
End Select
</div>


Here you go. I have a question for you. If I create a stored procedure, is there a Select Case (like in VB.Net) in TSQL that would allow me to do the same thing?

Select Case @InputValue
 Case "1000"
   Return "1000"
 Case "1001"
   Return "1001"
 Case "1002"
   Return "1002"
 Case "1003"
   Return "1003"
 Case Else
   Return "1000"
End Select

<div>
Hi,<br />
<br />
No.<br />
<br />
The case that is T-SQL is for use inside queries, not a control flow structure.<br />
<br />
Cheers<br />
&nbsp; David<br />
<br />
PS Thanks for the grade and the points
</div>


Hi,

No.

The case that is T-SQL is for use inside queries, not a control flow structure.

Cheers
  David

PS Thanks for the grade and the points

<div>
<div class="content wysiwyg-content">
One of the great features I like about Intersystems Cache is the ability to only allow specific values for a column. For example, if I have an Integer type column, I can specify to only allow the following values:<br />
<br />
1000<br />
1001<br />
1002<br />
1003<br />
<br />
That column would only allow those values. Is this possible with SQL Server 2008?<br />
<br />
Thanks
</div>
</div>


One of the great features I like about Intersystems Cache is the ability to only allow specific values for a column. For example, if I have an Integer type column, I can specify to only allow the following values:

1000
1001
1002
1003

That column would only allow those values. Is this possible with SQL Server 2008?

Thanks

Can SQL Server 2008 do this? Allow only specific values..

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.