Viewing 15 posts - 76 through 90 (of 323 total)
Johann Montfort (11/28/2008)
the thing is that @BuildID is returning a value, since there is a row at the moment, for example 30023. However I am loosing that value then
@BuildID...
November 28, 2008 at 4:26 am
Johann Montfort (11/28/2008)
I am trying to do a Select from a table, which has active rows and if it returns any results, I want to get the ID returned...
November 28, 2008 at 4:10 am
hjo (11/28/2008)
When multiple tables are updated in a single transaction, is there any way to tie those changes together with a unique transaction "ID" of some sort?
To clarify...
November 28, 2008 at 3:34 am
problem is length of datatype (char / varchar), just increase the length of the datatype and then try it.
November 28, 2008 at 3:30 am
s_vijay_ss (11/28/2008)
Hai friendsthis is vijay,i have doubt ,is it possible install sql 2000 on vista?please tell me procedure how to install
SQL 2000...
November 28, 2008 at 3:26 am
sushanth11 (11/24/2008)
I have developed an application which uses the system dsn for connection to sql server database. The application works fine when the user logges on using the...
November 25, 2008 at 1:00 am
mohinidba (11/24/2008)
November 25, 2008 at 12:00 am
Patrick Ige (11/24/2008)
If Exists (Select * From table WHERE a=@a and b=@b)
update table
set
a= @a,
b=@b
from table...
November 24, 2008 at 11:54 pm
balakrishna.gubba (11/24/2008)
We cannot go for transactional replication (I am assuming that for transactional replication the databases have to have the same schema). The reason...
November 24, 2008 at 11:46 pm
sridhar_18ind (11/24/2008)
Message
Executed as user: . Error reading data from file. Pos: 26295227674, Byte required: 0, Byte Read: 0 RESTORE DATABASE is terminating...
November 24, 2008 at 11:40 pm
golbano0o (11/24/2008)
November 24, 2008 at 11:31 pm
onlo (11/24/2008)
I have already setup a SQL 2005 with sp2 + hot-fix thus have 9.00.3054 SQL Server and Analysis Services.
However, today, my friend told me I should upgrade my...
November 24, 2008 at 11:22 pm
Kiran Kumar MP (11/24/2008)
----------------------------------------
Date 1M 2m 3m...
November 24, 2008 at 11:14 pm
above link is good for your query, it may effect performance issue for large volume of data.
November 24, 2008 at 10:59 pm
Mr J (11/24/2008)
CREATE TABLE test AS
(SELECT A, MAX(B)
FROM ...
November 24, 2008 at 10:55 pm
Viewing 15 posts - 76 through 90 (of 323 total)