Topics
Started by
Posts
Last post
Hi, I need to create a report that is tab delimited. I can achieve this by setting my connection op…
11 replies
We have a peculiar problem with views. We created a view with check option. We tried to update a r…
8 replies
Hi When I run sp_helprotect for the UDF below, I get the following error: Server: Msg 170, Level 15…
2 replies
Hi, We have a problem with a query used very often. We want to calculate the last operation for a …
3 replies
select count(DISTINCT convert(nvarchar,DD.fk_intDocumentID)+ 'zzz' + convert(nvarchar,DD.fk_intUser…
4 replies
I know part of my answer is in these messages threads somewhere but lost specific thread. So here i…
14 replies
Hi, I've been trying to do some debugging of stored procedures in Query Analyzer. Previously, I've…
12 replies
How can I get the Number of rows on each table in a DB.
2 replies
Hi there, I got this really weird behavor of my sqlserver 2000. I used the DTS to transfter a large…
2 replies
I have a table in SQL Server 2000 Enteprise Edition. CREATE TABLE dbo.TESTTBL ( MYID NUMERIC(38), …
9 replies
Hello I am looking for a script that will search though the text of all sp's & replace a strin…
7 replies
Hi, I'm trying to use a trigger to make sure no duplicates records would be added to my table (usin…
1 replies
I want to delete from a "large" table (more than 1,000,000 records) with conditions. Even with cond…
1 replies
How can we read a text file and read it from T-SQL https://dbfriend.blogspot.com/
1 replies
Dear all, I am attempting to produce an output to a file. This file must be formatted with new line…
1 replies
Viewing 15 topics - 14,131 through 14,145 (of 17,082 total)
You must be logged in to create new topics.