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)