Viewing 15 posts - 106 through 120 (of 3,221 total)
Use the DATEDIFF functions ...
for example
SELECT DATEDIFF ( datepart , startdate , enddate )
This will return the number of days difference.
SELECT DATEDIFF(d,'2013-04-05 10:45:41.013','2013-04-07 14:45:41.013')
returns 2 days
This returns the...
April 7, 2013 at 2:05 pm
bigshopmall (4/4/2013)
select mvalue,RequiredValue = case when ISNUMERIC(left(mvalue,1))=1 then SUBSTRING(mvalue,1,CHARINDEX(' ',mvalue)-1)
...
April 5, 2013 at 11:33 am
Knew two - guessed the 3rd .... but wondering how many of those answering the question actually use the Resource Governor ?
April 5, 2013 at 5:55 am
I would suggest you start your upgrade task using the Upgrade Advisor
here is a link that will assist you in starting your upgrade
http://msdn.microsoft.com/en-us/library/ms144256(v=sql.90).aspx
The above reference starts with assistance in upgrading...
April 3, 2013 at 6:13 am
Without sample table definition(s), and sample data it is difficult to make a recommendation.
That said, I would recommend that you look at the MERGE statement.
For example:
[ WITH <common_table_expression> [,...n] ]
MERGE...
March 31, 2013 at 8:26 am
Very, very good question + nice question ... made me aware of the subtle elements of using tables as parameters, and thanks
March 23, 2013 at 8:22 pm
Revenant (3/22/2013)
Thanks,...
March 22, 2013 at 3:30 pm
Can I brag, can I boast ..... can I pat myself on my own back ... wether I can or can not .. I will
My one hundreth QOD has been...
March 18, 2013 at 4:48 pm
Nice question - had to think long and hard for the correct answer
March 14, 2013 at 8:09 pm
You could get a good idea of what needs to be done for the upgrade by running the UPGRADE ADVISOR available at:
http://www.microsoft.com/en-us/download/details.aspx?id=11455
March 14, 2013 at 5:35 am
Nice question .. learned something from it ... thanks
March 12, 2013 at 8:25 pm
Without actual test data all I can suggested is that you look up the REPLACE function.
It is used in this manner:
REPLACE(<old_text>, <start_num>, <num_chars>, <new_text>)
If you would provide some sample data,...
March 12, 2013 at 8:10 pm
Rauf Miah
Your request sounds very much like home work. I am not adverse to helping a student, but first post what you have attempted, and the error message returned...
March 11, 2013 at 8:09 pm
If I understand what you desire to do correctly, this should do the job.
CREATE TABLE T(COMCOD nchar(4), ACTCODE nvarchar(6), ACTDESC nvarchar(250),
PRIMARY KEY (ACTCODE))
...
March 11, 2013 at 7:56 pm
Viewing 15 posts - 106 through 120 (of 3,221 total)