Viewing 15 posts - 136 through 150 (of 312 total)
Seenu,
you can aslo follow this link for more inputs.
1 - http://msdn.microsoft.com/en-us/library/ms151198.aspx
2 - http://databases.about.com/cs/sqlserver/a/aa041303a.htm
Cheers!
Sandy.
--
July 16, 2008 at 3:18 am
Hi Peter ,
you can get help from this link:
http://blogs.msdn.com/sqlclr/archive/2005/07/25/Vineet.aspx
And as per Endpoint Concept in SQL Server 2005, You can call a Stored Procedure in side the Webservice. not Webservice inside...
--
July 16, 2008 at 3:01 am
Yes, you can use this also.
declare @dob datetime,
@age int,
@day datetime
set @day...
--
July 16, 2008 at 2:43 am
Kimberly.Hahn (7/15/2008)
--------------------------------------------------------------------------------
The values for the rowcnt in sysindexes is not always accurate...
Ya, its correct...but updatestats make it possible if not updated..
you can also use other method too.
Cheers!
Sandy.
--
July 15, 2008 at 10:46 pm
Hi Pujari,
use this sample:
create table abc
(
id int,
dob datetime,
age as datepart(yy,getdate()) - datepart(yy, dob)
)
--
insert into abc
values (1, '01/01/1990')
--
select * from abc
--
drop table abc
Please let me know if you have any...
--
July 15, 2008 at 1:42 am
Hi Harsha,
As Steve already mentioned, how to create a procedure and pass the parameter. I can give a idea how can you make it.
just make a batch of query to...
--
July 15, 2008 at 1:16 am
Hi Karthik,
I would like to strongly agree with Gail Shaw suggestions with respect to splitting into 2 tables.
and as per you if any new investment type will add, That will...
--
July 15, 2008 at 12:41 am
nice article and very helpful too.
Cheers!
Sandy.
--
July 14, 2008 at 1:56 am
Hi Anil,
You can also use this code..
select rows as Total from sysindexes
where id = object_id('Temp') and indid < 2
Cheers!
Sandy.
--
July 14, 2008 at 1:45 am
Hi Jeff Moden & Matt,:)
After few hours of work, I am successfully complete the job..
As per requirement and your's suggestion, I created one batch file in my Development server and...
--
July 1, 2008 at 5:05 am
Matt, jeff..
Can you clear me more..
Can you suggest any of ways to achieve this..?
Cheers!
Sandy.
--
June 27, 2008 at 12:18 pm
Jeff Moden
------------------------------------------------------------------------
Validation of the text files should be done either during the creation of the text file, during the import of the text file, or, preferably, both.
And, yes... the copy...
--
June 27, 2008 at 12:09 pm
Hi MW,
Example: Lets say you want to donate certain items in your home.
Instead of having to put labels in each of them saying that it is free,
just put...
--
June 27, 2008 at 11:50 am
Hi eddy, Thanks man...
Can you clear me on this line...
Ps: you can also put a windows user/usergroup in a SQLServer group (db_datareader,..)
MW, Excellent...
Very clear on this...a real time example...although...
--
June 27, 2008 at 9:31 am
can anybody help me for this concepts??
Cheers!
Sandy.
--
June 26, 2008 at 10:57 pm
Viewing 15 posts - 136 through 150 (of 312 total)