Topics
Started by
Posts
Last post
Hopefully I can explain this and the answer is easy for the gurus. I have a table that has data arr…
2 replies
I saw a script as DELETE FROM #tmp_searched_table1 FROM #tmp_searched_table1 tsd, table_2 dta W…
6 replies
Hi Below query is returning all rows of left table and matching rows of right table: Select b.Col1…
3 replies
Hello, I tried to implement an insert trigger on an order entry table and a lock was subsequently i…
17 replies
Dear all, I have following doubts , 1) Can we pass a table name to procedure in sql2000? if yes ple…
9 replies
Hi Guys, I need to update the POST_CODE feild of a table by converting all the data records in the …
2 replies
Hi All, Can I print the results of a table directly to an email message. If yes, how ? Otherwise, w…
1 replies
This is what is currently happening (ridiculous): Export data from database, T, using a gui that p…
3 replies
CREATE TABLE [dbo].[Borrowers008]( [AUTOID] [int] IDENTITY(10001,1) NOT NULL, [MemberID] [varchar…
6 replies
I have a table that stores date time info. I have starting time and ending time. IN the table it st…
2 replies
I need your help!!!!!!!!!!!!! I have variables @a1,@a2,@a3 I'll be assigning the values to these va…
6 replies
tableA(empid(PK),empno,last,first,jobno,jobname) I have inserted data into tableA except for jobno…
10 replies
Hi all Is it good practice to use an AND clause on the INNER JOIN statement or is it best to have i…
3 replies
I have an existing table where i have add1, add2, add3 as columns. Now i want to add all the 3 into…
13 replies
I am trying to query a remote database using the 4part name for the server.dbase.owner.object but g…
5 replies
Viewing 15 topics - 3,691 through 3,705 (of 17,082 total)
You must be logged in to create new topics.