Viewing 15 posts - 2,506 through 2,520 (of 2,894 total)
If your proc "is designed to do the same sort of thing as Access's cascade delete function", why not just set Delete Rule to Cascade for your relationship?
July 20, 2010 at 9:38 am
That is one of the ways you can do it without a cursor:
declare @iLastPersonId int
create table #t_person
(
person_id INT NOT NULL IDENTITY(1,1),
...
July 20, 2010 at 9:27 am
Can you explain a bit what you mean by idle table?
Actually triggers are raised on some action (update, insert or delete).
If you want to raise something when nothing happens...
July 20, 2010 at 9:02 am
To my knowledge, SQL2008 provides a better and more reliable way to check object dependency in SQL Server than in SQL2005 - it is new sys.sql_expression_dependencies. Some more details...
July 20, 2010 at 4:52 am
Jeff Moden (7/19/2010)
Eugene Elutin (7/19/2010)
Jeff Moden (7/15/2010)
Eugene Elutin (7/14/2010)
Julie Breutzmann (7/14/2010)
...What would be an efficient way to code this?
...
If you need high-performance heavy string manipulation functions write them as CLR...
July 19, 2010 at 5:35 pm
doobya (7/19/2010)
...I have been curious for years how other SQL developers solve these issues - when I ask them
they just look blank ...
Other SQL developers may be not generaly using...
July 19, 2010 at 2:48 pm
Simple answer:
There is no "more elegant way". You can script executing of sp_refreshsqlmodule for each UDF in your database and run this script after altering any view/table (please note...
July 19, 2010 at 10:58 am
Joe Celko (7/19/2010)
History. Sybase was written in C on UNIX decades ago. The use of ! and % in SQL is not standard and looks awful
"!=" it is...
July 19, 2010 at 10:21 am
Jeff Moden (7/15/2010)
Eugene Elutin (7/14/2010)
Julie Breutzmann (7/14/2010)
...What would be an efficient way to code this?
...
If you need high-performance heavy string manipulation functions write them as CLR functions in c#. T-SQL...
July 19, 2010 at 8:37 am
mthurber (7/19/2010)
Hi,I don't think it needs to be that complicated. Does this work:
SELECT * FROM Tbl1
WHERE TYPE = CASE @TYPE WHEN 1 THEN 1
WHEN 2 THEN 2
ELSE TYPE END
Regards,
Mike
If...
July 19, 2010 at 8:25 am
Praveen Goud Kotha (7/19/2010)
...Then what is the use of introducing both the operators...???
...
It is matter of preference...
July 19, 2010 at 8:16 am
funooni (7/19/2010)
...
Supplying the value value 19 to DATEPART function with the first option 'WEEK', it will return 3 which means this is the 3rd week of the month.
One more thing...
July 19, 2010 at 7:28 am
As you table design does look like flat-file and not a proper table of realtional database, I can guide you first how to design the table in relational database...
Your table...
July 19, 2010 at 7:01 am
Viewing 15 posts - 2,506 through 2,520 (of 2,894 total)