No announcements
Found 2029353 threads
-
0 Votesset the value at DECLARE level
Declare @deptid int = 20.Answered | 1 Replies | 4496 Views | Created by NSG12 - Monday, June 29, 2009 7:59 PM | Last reply by Brad_Schulz - Monday, June 29, 2009 8:01 PM
-
1 Votes
declare variable and set value in sql
Hi Bhavika, The syntax to assign value to the variable is incorrect.Answered | 4 Replies | 3258 Views | Created by BC18 - Monday, August 27, 2012 11:48 AM | Last reply by BC18 - Monday, August 27, 2012 12:03 PM -
0 Votes
Declare multiple values to a varible
0 BEGIN SET @StringValue = LEFT(@StringInput, ISNULL(NULLIF(CHARINDEX(',', @StringInput) - 1, -1), ...Answered | 2 Replies | 792 Views | Created by SQL_Gun - Tuesday, October 21, 2014 11:09 PM | Last reply by Visakh16 - Wednesday, October 22, 2014 7:17 AM -
0 Votes
Declare multiple values in a variable
[Component] @SID varchar(125) ,@CID int AS BEGIN SET NOCOUNT ON; DECLARE @ConsumerID ...Answered | 6 Replies | 7158 Views | Created by SQL_Gun - Thursday, October 10, 2013 11:39 PM | Last reply by Dinesh Kumar Rajendran - Friday, October 11, 2013 5:26 AM -
0 Votes
Declaring and Setting Variables
Are you saying you wanted all the values from the table when no value or NULL passed to the variable?Answered | 2 Replies | 697 Views | Created by Brandon De Flon - Thursday, July 23, 2015 3:29 PM | Last reply by SQLGru - Thursday, July 23, 2015 3:59 PM -
1 Votes
must declare a scarlar value in a view
hi you can make the following trick to insert default value CREATE FUNCTION dbo.mytest ( @yrnum ...Answered | 5 Replies | 1824 Views | Created by Corlen - Wednesday, February 1, 2012 12:48 PM | Last reply by Kalman Toth - Wednesday, February 1, 2012 9:18 PM -
0 Votes
Declaring variables with values
I think ANSI standards apply to the select/update/insert/delete statements, not to declaration statements.Answered | 1 Replies | 4814 Views | Created by NashVegas - Wednesday, September 8, 2010 9:19 PM | Last reply by Naomi N - Wednesday, September 8, 2010 9:23 PM -
0 Votes
t-sql 2012 declare variable with multiple values
When I run the following sql: declare @RFSCode varchar(100) DECLARE @Account ...Answered | 7 Replies | 1358 Views | Created by midnight_car - Monday, September 28, 2015 6:29 PM | Last reply by Erland Sommarskog - Monday, September 28, 2015 10:10 PM -
0 Votes
must declare the scalar value @date
Thanks , I figured out it was the string structure around (+ @date as [date] ) that was wrong, corrected below declare @sql as nvarchar ...Answered | 4 Replies | 2439 Views | Created by I4QR1A - Monday, December 14, 2015 11:38 AM | Last reply by I4QR1A - Monday, December 14, 2015 2:16 PM -
0 Votes
Set value
As I declare "Set" to adjust value to the property, how can I use "Set" to adjust its value?Answered | 10 Replies | 519 Views | Created by Jackson_1990 - Tuesday, November 3, 2015 9:20 AM | Last reply by DA924 - Wednesday, November 4, 2015 1:48 AM -
4 Votes
How to set Window.DataContext declaratively in XAML
This has been awhile but the answers are incomplete: When the namespace is in a different assembly, you have to specify it using the assembly feature of the namespace ...Answered | 6 Replies | 38613 Views | Created by stratoblue - Tuesday, March 23, 2010 3:35 PM | Last reply by G1 - Tuesday, March 19, 2013 10:08 PM -
1 Votes
Must declare the scalar variable.
The declarative languages are orthogonal.Answered | 7 Replies | 27174 Views | Created by KamAbA - Thursday, October 3, 2013 11:51 AM | Last reply by Josh Ashwood - Tuesday, October 8, 2013 5:41 AM -
3 Votes
[VB.NET] Declared variable appearing not declared?!
I think instead of MOVING the declaration from the If to the Sub scope you COPIED the declaration so it still exists in both places.Answered | 3 Replies | 3602 Views | Created by Xakepa - Thursday, February 24, 2011 6:13 PM | Last reply by Andrew B. Painter - Thursday, February 24, 2011 7:10 PM -
2 Votes
Can I dynamically declare type of xml value
So in theory, you might not need to worry too much about the datatype when extracting from the XML, and set everything as VARCHAR or NVARCHAR with a suitable length.Answered | 3 Replies | 4418 Views | Created by Zefir - Wednesday, November 28, 2012 5:53 AM | Last reply by wBob - Wednesday, November 28, 2012 2:19 PM -
0 Votes
For Loop and declaring a record set
Also its possible to use GROUPING SETS to apply multiple levels of aggregation in the same ...Answered | 2 Replies | 660 Views | Created by Hey Kish - Tuesday, October 2, 2018 12:48 PM | Last reply by DIEGOCTN - Tuesday, October 2, 2018 12:57 PM -
4 Votes
Is it possible to set a method after it has been declared?
The biggest challenge is setting the properties of the abilities if they vary.Answered | 16 Replies | 1057 Views | Created by Noaml1 - Wednesday, May 29, 2013 6:36 PM | Last reply by CoolDadTx - Friday, May 31, 2013 2:02 PM -
0 Votes
Variable value not set?
Check the flow, DECLARE @validation_message NVARCHAR(200) SELECT @validation_message SET @validation_message='' SELECT @validation_message BEGIN ...Answered | 4 Replies | 1335 Views | Created by shiftbit - Wednesday, August 21, 2013 8:34 PM | Last reply by Sarat (SS) - Thursday, August 22, 2013 12:55 AM -
0 Votes
Must declare scalar value
I am unable to set global constructors as I am getting result from database using combo box.Answered | 14 Replies | 1026 Views | Created by _birdy - Sunday, August 13, 2017 6:18 AM | Last reply by BonnieB - Thursday, August 17, 2017 3:21 PM -
3 Votes
Use of DECLARE
In sql2008 you can declare in the way i showed you above..and sql2008 allows you to assign values while declaring as well like..Answered | 9 Replies | 2710 Views | Created by meridius10 - Monday, November 14, 2011 9:14 PM | Last reply by meridius10 - Wednesday, November 16, 2011 2:42 PM -
5 Votes
LIKE %(set of possible values)%
You can create a stored procedure with an input parameter for the values.Answered | 8 Replies | 2523 Views | Created by V08 - Thursday, August 18, 2011 3:05 PM | Last reply by Gert-Jan Strik - Thursday, August 18, 2011 5:19 PM - Items 1 to 20 of 2029353 Next ›
No announcements
