Topics
Started by
Posts
Last post
I've just started learning SQL Server 2000 with the aid of Books Online (the one that is available&…
11 replies
Hi SQL Gurus When you execute the following code it works perfectly: DECLARE @CursorVar CURSOR SET …
13 replies
Can anyone please help me with this sql. I get an error as [OLE/DB provider returned message: [Micr…
11 replies
Hello to the best sql fourm on the net I need a script that will allow me to insert into one column…
25 replies
I have a view that has horrible response time, plus I'm getting dups. When I add "Distinct" t…
23 replies
Please help. I'd like this to be achieved. exec dmi_sp_ftp 'inventory.txt', 'f:\d…
3 replies
I would like to change the format of a date in SQL so that it is a little bit cleaner whhen querrie…
7 replies
what is maximum number of records can a table hold in msaccess, if it has around 20 columns 5…
19 replies
Hi, Is there any performance penalty if I use RTrim() to trim a field? On a hand RTrim is a simple …
3 replies
wats the best way to copy heirarchical data in stored proc , for example there are 3 tables parent,…
3 replies
Please someone rescue me. I have a string like this: 'action=acct_zip&id=1B25B81JVJT&…
4 replies
Howzit, I'm trying to a do an insert into a table that contains an (non-identity) integer primary k…
4 replies
Hi guys, I have a trigger that sets a field in a table to the value of 3 other varchar fields conca…
4 replies
for queries that do an aggregate and lots of joins, what's a better idiom: 1. wrap joined/selected …
4 replies
I told somebody that it's no big deal creating some automation around performance tracing.... Then…
1 replies
Viewing 15 topics - 9,931 through 9,945 (of 17,082 total)
You must be logged in to create new topics.