Viewing 15 posts - 5,206 through 5,220 (of 5,356 total)
quote:
What you could do is write your GUI so that your main user interface is in a bald HTML file and that...
May 22, 2003 at 3:56 am
quote:
I take it that you are talking about a web application?[{quote]
GUI is displayed in Browser
quote:
May 22, 2003 at 3:33 am
I'm thinking of implementing centralised validation of input at a database level for protecting against sql injection. I do not trust this only be done at application level.
Nested stored...
May 22, 2003 at 2:56 am
quote:
This is how it's pronounced if you're a finance director being asked to pay of ORACLE.
May 22, 2003 at 2:17 am
Hi ytao,
although Len's solution works, if you're just just looking for last day of month an year based on the given date what about
SELECT day(dateadd(d,-day(@date),dateadd(m,1,@date)))
Works also for YEAR(...)
It should be...
May 22, 2003 at 2:11 am
Hi,
have you tried the T-SQL Debugger from within VB?
Cheers,
Frank
May 22, 2003 at 1:11 am
Well, status in my model db is 0.
Good luck!
Cheers,
Frank
May 22, 2003 at 12:46 am
When you take a db offline without an error, the entry for status is - in my case - 1077936640 which is the sum of cleanly shutdown, offline and autoshrink....
May 21, 2003 at 8:30 am
quote:
If you submit the date to SQL Server in the format YYYYMMDD (with no separators), then SQL Server will correctly interpret the...
May 21, 2003 at 6:44 am
Hi,
this will work
declare @date1 varchar(10)
declare @date2 datetime
select @date1 = '01.01.2003'
set @date2 = convert(datetime,@date1,103)
print @date2
Cheers,
Frank
May 21, 2003 at 5:26 am
Hi,
autoincrement is something that happens in INSERT actions. Do you want a calculated ongoing index for your SELECT statement?
Cheers,
Frank
May 21, 2003 at 5:07 am
Hi,
here is a snippet of a jsp page I built just for fun to test java?!? and SQL Server.
www_assetlist is a view on the SQL Server.
<%
...
May 21, 2003 at 3:04 am
Positive,
date modified changes when an autogrow occurs.
Cheers,
Frank
May 21, 2003 at 2:39 am
Well, at first sight I thought SELECT DISTINCT @dataset might cause the problem, but at quick test has proven me wrong.
Have you tried putting in some @@error check in...
May 21, 2003 at 2:05 am
Hi,
do you mean MAX(datefield)?
or datepart(dd,datefield)?
or a combination like SELECT datepart(dd,max(datefield)) from table?
Cheers,
Frank
May 21, 2003 at 1:35 am
Viewing 15 posts - 5,206 through 5,220 (of 5,356 total)