Viewing 9 posts - 1 through 9 (of 9 total)
Hi,
In this case you have to create a TEMP table
declare @iStartID int,
@iEndID int,
@sqlcol as nvarchar(4000)
select @iStartID = 3, @iEndID = 8
August 2, 2004 at 5:55 pm
declare @sqlcol as nvarchar(4000)
select @sqlcol=''
select @sqlcol = @sqlcol + ' ' + COALESCE (rtrim(name), 'NULL') from country_master where id < 3
print @sqlcol
August 2, 2004 at 1:39 am
Hi,
What about this one...
declare @sqlcol as nvarchar(4000)
select @sqlcol=''
select @sqlcol = @sqlcol + ' ' + rtrim(Name ) from country_master where id < 3
print @sqlcol
August 2, 2004 at 12:44 am
Try this...
CREATE TABLE [dbo].[Table3] (
[table1_Col1] [char] (1000) NULL ,
[table1_Col1_new] [char] (1000) NULL
)
GO
----------
CREATE TRIGGER table2_update
ON table2
for update
AS
BEGIN
declare @OldCol as varchar(100)
declare @NewCol as varchar(100)
declare @Col as...
July 29, 2004 at 11:50 pm
Try this script...
select top 10 OD.*, rownumber
from
(
select temp1.productid productid,
temp1.ORDERID ORDERID,
count(*) rownumber
from
(
SELECT a1.*
FROM [order details] a1
join
[order...
July 28, 2004 at 10:28 pm
Do you have 'rs' tabel ot view in Northwind DB?
July 27, 2004 at 10:37 pm
Hi,
Have a look at Resetting the Suspect Status in BOL
Microsoft® SQL Server™ 2000 returns error 1105 and sets the status column of...
July 23, 2004 at 1:11 am
Hi Aaron. SQL Server is configured to use a physical pool of memory on the server, and it will allocate the majority of this memory pool to hold data pages...
July 22, 2004 at 1:16 am
Try this..
Declare @tbATable Table(ID Int Identity(1,1) Not Null,AName varChar(20),ADate DateTime)
declare @CurrentDate DateTime
set @CurrentDate = GetDate()
Insert @tbATable (AName,ADate) Values('A',@CurrentDate-4)
Insert @tbATable (AName,ADate) Values('A',@CurrentDate-3)
Insert @tbATable (AName,ADate) Values('A',@CurrentDate-2)
Insert...
July 20, 2004 at 11:49 pm
Viewing 9 posts - 1 through 9 (of 9 total)