Topics
Started by
Posts
Last post
There is a table UDF in the script section of this site that I have used in times past. It can take…
1 replies
WAREHOUSE acts as an inventory. The Trigger should update the WAREHOUSE.ItemQty column. After testi…
3 replies
whats the correct way to write this i keep getting this error: Msg 205, Level 16, State 1, Line 1 A…
8 replies
I need to run an update statement from a sql server in a primary location that will update tables i…
3 replies
Hello, I'm having problems achieving this: I have a list of purchases by client. Something like: T…
2 replies
I have a table or you can say a result of query is like that A B _______ a x1 a x2 a …
2 replies
Hi, I created a database user and assigned required permissions. Then I created a database with the…
1 replies
Hi people. I need sql to log activity happening in our database, particularly when requests are mad…
5 replies
DECLARE nId NUMBER; BEGIN INSERT INTO TABLE A ( name, age ) VALUES ( 'X', 12 …
1 replies
Hi all, I'm trying to send a sql statement using sp_send_dbmail procedure. Result should be attache…
2 replies
Hi, I have below Select statement ... with 3 columns (DOC, PRODTYPE and TERM). In TERM field, there…
3 replies
Hello everyone. I hope everyone is doing good. Of course I am posting here due to an issue, so I …
6 replies
Hi, I have a question on database views. I created a view on a table "with encryption" and "with sc…
3 replies
We are executing a stored Procedure which inserts a record in the other server .Added the other ser…
1 replies
We built a table that contains a fiels called Check_Total. This holds the value of a check. We conv…
6 replies
Viewing 15 topics - 8,296 through 8,310 (of 12,230 total)
You must be logged in to create new topics.