Topics
Started by
Posts
Last post
Query to delete, all the records from a table before half an hour,… Delete * from table where condi…
8 replies
Hi, I want to reada textfile which will further on be used in a mail sent from the database. To re…
3 replies
Hello Am running this query: SELECT T_ShipmentLines.ShipmentLineID, T_ShipmentLines.OrderID, T_…
4 replies
AOA i have a table test with data type int. There is only one column val1 in test. values in val1 a…
6 replies
Hi all, I am a newbie in SQL scripts, appreciate if anyone can help. I have a table "SALEITEM", whi…
18 replies
Hi, i'm trying to retrieve data from 3 tables. They are Table1: Station Sample Data : StationCode…
7 replies
I am creating a new table with a foreign key into another table that already has records (over 960,…
2 replies
Ok, I some stored procedures that occasionally take a long time to run. It's not something I've be…
8 replies
I am new to XML but amazed by its great potential. Now I am using it in create a stored procedure t…
3 replies
I have a self reference table Id is the primary key and the FK is going to Parent Id. I basically…
1 replies
Hi, I have couple of stored procedures which gets the data from a view that is formed by a number o…
14 replies
hi members, I have a cursor and in the declaration of the cursor there is a join and I want to stop…
7 replies
Hello am using the following query: SELECTDISTINCT T_OrderHeader.OrderID, T_…
6 replies
SET QUOTED_IDENTIFIER ON im setting this on in a stored proc, java code executes the stored proc...…
2 replies
I've been a bit lazy and haven't kept track of some changes I've made. (I almost miss the old Ingre…
5 replies
Viewing 15 topics - 9,091 through 9,105 (of 12,230 total)
You must be logged in to create new topics.