Topics
Started by
Posts
Last post
Hello, I need to have a store procedure with input parameter CostomerID, and according this paramet…
10 replies
Hi, In a bit of a hurry for this one. Has anybody tried to execute an Oracle Stored procedure , wit…
3 replies
I'm writing an ASP page for a project and it requires multiple queries. However, I'm trying to comb…
58 replies
Group: I have a query that is summing up two values (nSpeed and nTotal), but I want the query to no…
7 replies
I'm trying to use a scroll cursor inside a user defined function as follows: ----------------------…
6 replies
Is there a way to mimic Oracle's FOR EACH ROW functionality in SQL Server? I have a DTS that …
2 replies
Hi All, I am trying to populate a bunch of tables with some default values. Each table has an ident…
5 replies
How can one use values from an EXEC (or sp_executeSQL) that is known to be a SELECT (or, if needed,…
8 replies
I have good one: There is a table t1 with columns C1 and C2. The result from t1 is as under: 1 1 1 …
7 replies
This shows you all of your PKs in a database. Couldn't find anything else on this (thanks to …
5 replies
Hello, I'm having a problem with a inline table function : CREATE FUNCTION dbo.udf_func (@id int) R…
9 replies
I have an area on our website where users can customize what data fields they want to see displayed…
31 replies
I would like to implement paging functionality from the sql. I have found many articles in the net …
1 replies
hi, we have triggers attached to several. everytime there is a change or Replication need to …
1 replies
Hey, I need to run a sql script if a certain condition holds (if a specific table exists). This scr…
5 replies
Viewing 15 topics - 10,096 through 10,110 (of 17,082 total)
You must be logged in to create new topics.