Okay,
clearly if one is to find a record that doesn't exist in a database then the check can not be done inside the sql reader itself.
Update to my query...
How does one loop through a list to check against a db?
Hi
I am trying to check where an item in my array list exists in the database.
The list would have already been created at an earlier stage.
Now that some items may have been removed from the database, I wish to check the list against that database before removing the items, from the list...
Probably various ways of doing this and reasons why some ways are better than others.
I am probably not going about things the best way but owing to my limited experience, it is what it is and any help would be much appreciated.
I have pulled data from a sql database, put into a...
I am trying to set a array of elements to a certain style and for various reasons I need to do this in JavaScript.
Can anyone tell me what might be wrong with the loop below? I am not too experienced with arrays or loops but am sure I just need a subtle alteration to the code.
Thank you in...
I worked it out, thanks anyway.
DECLARE @YEAR as varchar(4);
DECLARE @MONTH as varchar(4);
SET @MONTH = MONTH(DATEADD(M,1,GETDATE()));
SET @YEAR =
CASE @MONTH
WHEN '1' THEN CONVERT(INT,(YEAR(GETDATE()))) + 1
ELSE YEAR(GETDATE())
END;
Hi,
I am struggling to understand what is wrong with the following...
DECLARE @YEAR as varchar(4);
DECLARE @MONTH as varchar(4);
SET @MONTH = MONTH(DATEADD(M,1,GETDATE()));
CASE @YEAR
WHEN @MONTH == '12' THEN '2011';
ELSE YEAR(GETDATE());
END
I receive the following error...
First post on here, hello everyone;
hopefully I am in the right place to find some help.
I have an issue relating somewhat to sessions, password management and SQL Server database using a ASP.NET & VB.NET.
The problem is as follows...
I want to change my password to my SQL database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.