Topics
Started by
Posts
Last post
I am trying to work with @@ERROR and am having problems with a simple statement <below> -- Be…
7 replies
How can you run queries in batches inside stored procedure since you can not use the GO batch comma…
19 replies
guys i have table emp( empno(pk), ename, job, sal) how can i declare a pl/sql table of employee nam…
2 replies
Does anyone have a script which will select the top x rows from every user table in a database? Th…
6 replies
create proc extractdata as begin tran if exists (select * from dbo.sysobjects where id = object_id(…
6 replies
I have a database aaa and i'm taking a full backup daily at 12 Am(I'm overwriting to the existing m…
2 replies
hi guys, how would i write the following sql statments using pl/sql table? SELECT to_char (orderdat…
1 replies
I have created a View with a clustered index. The View contains about 4.5 million rows. It works gr…
7 replies
Hello, Can anyone advise on the best way to create a file from running a SQL Statement that does no…
3 replies
Hello, I was wondering if anyone could help me with an SQL Statement that will always return a numb…
12 replies
I'm trying to send an email with a query but I need to send a parameter in the query. exec mast…
3 replies
is there anyway to insert the results from a stored procedure into a table/temptable without first …
12 replies
Is there a way I can get select 1+1 as two, two+1 as three without having a sub query like …
6 replies
Greetings. I have this select which dies when I add the ELSE part of the CASE in. The 3 fields bein…
2 replies
Are both sql statements below functionally the same thing? Is one better than the other? -- cut he…
1 replies
Viewing 15 topics - 14,176 through 14,190 (of 17,082 total)
You must be logged in to create new topics.