Topics
Started by
Posts
Last post
I have a stored procedure as shown below -- I am trying to calculate a percent per row for a group …
2 replies
I am trying to get a string literal of comma seperated values to be parsed as a list of values by t…
2 replies
Does anyone know how to do this dynamically in QA? In PL-SQL it's 'set heading off' John Zacharkan…
3 replies
Is there a way to store NULL in a datetime column? I've tried but It defaults to Jan 01, 1900. Than…
2 replies
Is there a way to store NULL in a datetime column? I've tried but It defaults to Jan 01, 1900. Than…
4 replies
Hi. I have an VB exe that executes procs from a SQL DB via bcp to dump the query results into text …
4 replies
Hello - me again.... I'm unable to access the INSERTED or DELETE tables from inside an trigger that…
5 replies
Hello all, I have a stored procedure that takes four input parameters: CREATE PROCEDURE proc_FreeTe…
7 replies
Hi, here is my query: select Name + Surname as Fullname where Fullname > "Paul" order by Fullnam…
4 replies
hi, my query must return the "last" n record, but "select bottom" not exists; is there another way …
2 replies
Hello, I have a query that uses grouping in which the results show a teacher's first name and last …
1 replies
Hi ! When trying to run the script I always get 'Access Denied'. DECLARE @DOSCOMMAND VARCHAR(4000) …
7 replies
Does anyone have any inside knowledge on what goes on 'behind the scenes' with OPENXML used with sp…
5 replies
Here goes. What I need to do is extract stored procedure comments. SELECT text FROM SYSCOMMENTS s…
3 replies
Recently I have been writing queries using OPENXML to do inserts, updates, and deletes, as it lets …
1 replies
Viewing 15 topics - 16,081 through 16,095 (of 17,082 total)
You must be logged in to create new topics.