Forum Replies Created
Viewing 15 posts - 1 through 15 (of 25 total)
-
RE: Problem with fixed-length column query from Oracle from SQL server
Enthusiast Thx 4 ur suggestion,
But I think it's the problem with SQL server "OPENQUERY" Which try to map each constant column with length 32. It generates same error "[MSDAORA].A'. The...
-
RE: Switch to Another User’s Login using T/SQL
Dear noeld ,
Thx 4 Ur valuable Suggation!!!
But Still i m facing same Problem like earlier!!! Follwing...
-
RE: How to use statistics calculation in sql server 2000?
Dear All,
THX,
I have found stddev().... but not 'Correlation'.
-
RE: You cannot create a Local sql Server as a Link server
Old Hand Thx,
Though it does not solve my posted problem, but help me to think about add link server through TSQL...
-
RE: You cannot create a Local sql Server as a Link server
THX !!!
genius Newbie !!!
The Problem is solved......
It Is Working now
100000** 4 u
--Muntasir
-
RE: Alternative way to get the tables row count
ok
Thanks to u ALL
-
RE: Alternative way to get the tables row count
Hi,
It is working like as below:
dbcc updateusage ('Mydatabase','MYTABLE') WITH COUNT_ROWS
-
RE: partitioning table @ sql server 2000
hi Daljit S. Saini,
Then it seems to be hazy...
Because, What would be my insert,delete,modify statement...
i have to check the range of...
-
RE: What is the Best Way for Comparing Datetime value in SQLSERVER 2000?
Then why not 121( "yyyy-mm-dd") ?
Does it make any prob if i use 121 insteed of (style 112)
Is the any significant dif btn them?
-
RE: What is the Best Way for Comparing Datetime value in SQLSERVER 2000?
hi Kenneth Wilhelmsson ,
you are right , but i am facing problem about this date time format,Let clear the scenario, my application is running...
-
RE: What is the Best Way for Comparing Datetime value in SQLSERVER 2000?
Hi,
alzdba..sorry i was failed to catch your voice...
What do u mean by:
"- I'd say this is not what I'd call a UDF."
"remember a UDF works at row-level "
I would be...
-
RE: How to Execute quary in store procedure
thx winash!
you r right...
now i m doing it as follows:
create procedure mype
as
create table #mytable
( itemcode varchar(15),
...
-
RE: Is it possible to change sql server 2000 machine’s date from QA.
THXits is working
-
RE: How to pass parameters into inline UDF from a sub query
Rawhide
i think u have'nt got my point..
i have not any problem in returning part but problem in param part
got...
-
RE: How Create a store procedure from another store procedure
What about the "table valued function" ?
can u clear it little bit?
Viewing 15 posts - 1 through 15 (of 25 total)