David Burrows

Forum Replies Created

Viewing 15 posts - 2,911 through 2,925 (of 3,543 total)

RE: Bypassing Triggers

Good article, learn something new every day.
quote:
If we execute the following statement, what trigger(s) will fire and how many times will...

November 25, 2003 at 7:31 am

#483536
RE: return a subset from a query

If you are using an ADO recordset it has paging abilities.

November 25, 2003 at 5:48 am

#483522
RE: Import and export data

I agree with phillcart's postings, I transfer 7GB (46 tables) daily from a 3rd party database using ODBC and DTS is the fastest method. I create one DTS package per...

November 25, 2003 at 5:30 am

#483520
RE: Invalid column
Could use exec to insert column
```
exec ('alter TABLE #temptable add TEMPCOL int identity (1,1) NOT NULL ') 
```
but GRN's solution is better.
November 25, 2003 at 5:10 am

#483518
RE: Can't figure out recursion without dyanmic SQL
If table is as described and GROUP is sequential (no gaps) then you can use two temp tables as follows
```
DECLARE @group int,@max int 

SET @group...
```
November 24, 2003 at 6:45 am

#483329
RE: How to import a .sql file with DTS

quote:
Incorrect syntax near ' '.
Just remembered, isql gives this error for unicode files. Try...

November 21, 2003 at 6:44 am

#483072
RE: DTS Lookups - Type Mismatch error

quote:
many a mickel mucks a muckel sic!
It's one of those obscure scottish (and I'm...

November 21, 2003 at 6:38 am

#483070
RE: DTS Lookups - Type Mismatch error

Auch Mench, Frank.
Are you referring to the quote or the dialogue in the other thread?

November 21, 2003 at 6:25 am

#483068
RE: DTS Lookups - Type Mismatch error
Could be. DTSLookups will return empty variant if no data. To protect against error use
```
If IsEmpty(arrAddresses) Then

...

else

..

End If

 
```
November 21, 2003 at 6:02 am

#483055
RE: Running Query batches in stored procedure

quote:
At the end of the script, the original writer needed to return all column values except one.

November 20, 2003 at 7:54 am

#482863

RE: Get SQL Server Case Sencetive

sp_helpsort

 select (value & 0x1) from master.dbo.syscurconfigs where config = 1125

will return 1 if 'case insensitive'

November 20, 2003 at 7:02 am

#482848

RE: Running Query batches in stored procedure

Why do it?

What is it about the system that requires you to do it?

The proc can only be run once unless you are dropping and creating the table each time!!...

November 20, 2003 at 6:37 am

#482843

RE: Running Query batches in stored procedure

create proc customersproc as 

exec ('alter table customers add sname varchar(50)') 

exec ('select sname from customers') 

go

Works but would not advocate it.

November 20, 2003 at 6:23 am

#482839

RE: How to import a .sql file with DTS

The script is executing but

quote:
1> 2> Msg 170, Level 15, State 1, Server CEDE, Line 1

November 19, 2003 at 8:07 am

#482653

RE: How to import a .sql file with DTS

Replace filename with the name of the .sql file, eg if the file you want to execute is called test.sql in the temp directory of your c: drive then would...

November 19, 2003 at 7:34 am

#482636

Viewing 15 posts - 2,911 through 2,925 (of 3,543 total)