Topics
Started by
Posts
Last post
Hi everybody, I have to do a search & replace into a bunch of text type fields - in order to u…
10 replies
Greetings once again. I am working on some sql to be used in a report. I have a transaction table …
5 replies
By: villersk
Hi , I have 2 columns where some rows have -ve numbers and some rows have +ve number...I need to su…
2 replies
IF OBJECT_ID('TempDB..#Question','U') IS NOT NULL DROP TABLE #Question IF OBJECT_ID('TempDB..#Answe…
2 replies
By: dt293
I have a sql statement that outputs numbers to 2 decimal places. When I execute the same sql statem…
2 replies
Hi, I'm trying to create an XML output file with some hierarchy using a a SELECT...FOR XML clause,…
1 replies
By: LutzM
Hi. I didn't realize that if you add a row to the underlying table while a forward only cursor is r…
18 replies
The following statement will show you information about your instance and the file space used. how …
1 replies
Okasy I have been racking my brain to understand why this will not use the 'use' cammond in the fir…
5 replies
By: ps.
Interesting problem here. There is an application that insert/updates/deletes from a table but is v…
5 replies
By: ps.
Hi Guys I have got a range of numbers which are actually the number of tests done by the doctors ov…
8 replies
I was surprised to learn from one of my colleagues that using value1 = value3 ran faster than value…
6 replies
Hi, I have a store proc that execs 2 others before it builds the temporary table that I want to use…
14 replies
How To Enable or Disable ALL Triggers on a Single Database?
7 replies
Hi , I want to insert a new column , check while inserting values. For example : I have a table…
5 replies
Viewing 15 topics - 6,301 through 6,315 (of 12,230 total)
You must be logged in to create new topics.