Topics
Started by
Posts
Last post
Hi, The part which is broken is the constraint. The constraint doesn't exist at first and the whol…
1 replies
Hi, I have a trigger that I want to fire when the eight (8) column is updated. BOL suggest to use C…
5 replies
Hi all! I just found out that with the numeric datatype you can use negative numbers too! Well, I o…
2 replies
Hello all, With some previous help from the group I have arrived at a SP that is doing what I want …
6 replies
We have imported tables from Excel and Access and now want to insert date from temporary import tab…
1 replies
I am having trouble setting precision and scale dynamically in a function: SET @RETURNIT = CAST(0.1…
1 replies
Hello, I thought I had this down but some times the data the view returns is not correct or more to…
2 replies
Hi Folks, I have a stored procedure that has 5 arguments. Any combination of these arguments could …
2 replies
Does anyone know a neat way to suppress repeating fields in a select statement? I.e. If a table con…
3 replies
I have read that derived is a performance hog and i have heard everwhere that temp tables are to be…
7 replies
I have the following updatetrigger with a print statement in it but the message never appears. Any …
1 replies
1)I have many SQL statement in my stored procedure, if a statement crash I want rollback all statem…
11 replies
Hi everybody! I have a table with 2 columns. Both integer. And I want to create a view with this 2 …
3 replies
We are encountering a peculiar problem regarding the usage of aggregate functions in combination wi…
2 replies
Can anyone tell me why this wouldn't work: select distinct ACCOUNTNO From ContSupp Where accountno …
10 replies
Viewing 15 topics - 16,501 through 16,515 (of 17,082 total)
You must be logged in to create new topics.