Viewing 6 posts - 31 through 36 (of 36 total)
Paul,
The problem is that from the info I obtained with the DBCC PAGE statement, it is impossible for me to know to which object the page is referring.
In other words,...
April 13, 2006 at 8:14 am
Vladan,
You can use the functions to fill variables which you then use in the select statement, like you mentioned in your first post.
Complicated or not, I believe that your code...
March 22, 2006 at 8:15 am
hi Bill
You could use a conversion (yeah, I know...) to obtain that result, like so:
select getdate(), convert( datetime, floor( convert( decimal(12, 4), getdate())))
March 22, 2006 at 7:59 am
hi Vladan,
Well, as you already stated, reusability is the main reason. Other than that I admit looking at you piece of code is easier to read, but I like to...
March 22, 2006 at 7:53 am
Hello,
You could make 4 seperate functions which take a date as input parameter (e.g. @date) from the code I pasted below. I hope this is what you need .
--input argument
declare...
March 22, 2006 at 7:04 am
Viewing 6 posts - 31 through 36 (of 36 total)