Viewing 15 posts - 2,041 through 2,055 (of 15,381 total)
Luis Cazares (11/25/2015)
Sean Lange (11/25/2015)
lnardozi 61862 (11/25/2015)
In the script, you're selecting into a variable. No matter how many rows there are, the variable only gets set once.
Not quite, the OP...
November 25, 2015 at 9:36 am
eut.kop (11/25/2015)
first of all excuse for my bad English!
I try to resume with a basilar example what I should reach.
-- table category
[id_categoria] [int] NOT NULL,
[categoria] [nvarchar](50) NULL
-- table film
[id_film]...
November 25, 2015 at 9:10 am
Minnu (11/25/2015)
using below trigger,
ALTER TRIGGER [dbo].[t_info] ON [dbo].unify_info
FOR update
AS
begin
declare @val1 varchar(100) declare @val2 varchar(100) declare @temp varchar(100)
set @temp='HHT_Report'
set @val1='SELECT ' +@temp+ ' FROM INSERTED'
set @val2='SELECT ' +@temp+ '...
November 25, 2015 at 8:21 am
lnardozi 61862 (11/25/2015)
In the script, you're selecting into a variable. No matter how many rows there are, the variable only gets set once.
Not quite, the OP is using a concatenation...
November 25, 2015 at 7:44 am
Mad-Dog (11/25/2015)
i've a table with lots of rows and i want only the rows from last quarter and current year.
i run this script and i have problem with the results...
November 25, 2015 at 7:37 am
John Mitchell-245523 (11/25/2015)
November 25, 2015 at 7:31 am
marc.heidemann (11/25/2015)
I have been creating a report that uses week numbers and noted that 01-01-2016 is coming up as week 1 of 2016
but when I checked a calendar online...
November 25, 2015 at 7:22 am
Phil Parkin (11/24/2015)
Sean Lange (11/23/2015)
Phil Parkin (11/23/2015)
cmc123 (11/23/2015)
can someone help me in writting a cursor with following update statements .This statement will updates each database in an instance of...
November 24, 2015 at 7:32 am
Phil Parkin (11/23/2015)
cmc123 (11/23/2015)
can someone help me in writting a cursor with following update statements .This statement will updates each database in an instance of SQL .
UPDATE dbo.Property
SET USERTXT1...
November 23, 2015 at 3:03 pm
cmc123 (11/23/2015)
can someone help me in writting a cursor with following update statements .This statement will updates each database in an instance of SQL .
UPDATE dbo.Property
SET USERTXT1 =
(SELECT...
November 23, 2015 at 3:02 pm
Looking a bit closer you could save yourself a LOT of headaches by breaking this into three triggers just to start. One each for INSERT, DELETE, UPDATE. At least that...
November 23, 2015 at 2:50 pm
The biggest issue with your trigger is that it is relying on scalar values. This is bug red flag because in sql server, triggers fire once per operation and scalar...
November 23, 2015 at 2:48 pm
Brandie Tarvin (11/23/2015)
Luis Cazares (11/23/2015)
Is it me or many people don't really understand error handling or why and how to use try...catch...?
It's not just you. Though, to be fair, Try...Catch...
November 23, 2015 at 9:13 am
baludw22 (11/23/2015)
November 23, 2015 at 8:27 am
smmkr17 (11/23/2015)
-- Create the body
set @body = cast( (
select td = dbtable + '</td><td>' + cast( entities as varchar(30) ) + '</td><td>' + cast(...
November 23, 2015 at 7:34 am
Viewing 15 posts - 2,041 through 2,055 (of 15,381 total)