Topics
Started by
Posts
Last post
Hi friends, Here is an interresting problem (probably an exercise for Jonathan ) Given the followin…
3 replies
Hi, (probably a stupid question, but anyway) Is there any way to do a cascading DELETE, even if I d…
8 replies
Gurus pls help me out.. how can i find out the return type of a Stored procedure..like whether it r…
2 replies
Here is the data in my table. noname 1 kfd 2 vnj 3ksdk 4jfdjs 2cjsa 2jsd 3ajfd 4hfsdakj 3…
5 replies
Dear friends i am having wrong results with following query.because of variable i'm using. as u can…
8 replies
I want to migrate ALL jobs at my development server to my new production server. The total of jobs …
4 replies
Hi, I'd like to use a udf or a sproc to reduce repetition in a trigger. <code> IF EXISTS(SELE…
6 replies
I have a scheduled task which i want to run continually, but query a table periodically (e.g. every…
4 replies
-- Why does this work Declare @sql varchar(8000) Set @sql = 'Create Procedure #MyTempSP as Select…
3 replies
I have a trigger in SQL which fires a stored procedure whenever there is an update in the SQL table…
1 replies
I have a SP that uses a input dateTime paramater. Does anyone happen to know what the proper format…
9 replies
SELECT '01' as the_month,'2003' as the_year, isnull((SELECT SUM(num_units) from active_units_static…
12 replies
hi, i am writing a trigger CREATE TRIGGER Ztrig ON TZ FOR INSERT AS BEGIN INSERT TY VALUES (…
1 replies
I have created a trigger using SQL Query Analyser. For modification I open SQL Enterprises Manager …
2 replies
I am trying to get the time value in a 'hh:mm:ss am/pm' format from the getdate() function, can any…
11 replies
Viewing 15 topics - 13,981 through 13,995 (of 17,082 total)
You must be logged in to create new topics.