I agree exactly what ChrisLeonard said and if I could, I would have said the same thing. Thanks for expressing my feelings in a discussion based way... Regards, Hans! Edited by - hanslindgren on 07/15/2003 05:54:30 AM
2003-07-15
Hi Dale, quote: Check this out. I found this on Citeseer. Used that site a lot for my Masters: thanks again! Seems to be a good site. Now I only need a good pocket dictionary Cheers, Frank
2003-07-15
1 reads
2003-07-14
1 reads
Make sure that you have updated the Stored Proc with your own SMTP server name and that you can access that server accross your network by pinging it by name as well as by IP address. CDONTS/CDOSYS does not report an error if the server is not found - the messaage just vanishes into the […]
2003-07-14
You might try bol (bools online) for the topics "sp_executesql" and "Using sp_executesql". The object (e.g., table) names need to be fully qualified in order for SQL Server to reuse a cached execution plan. Also, the execution of the query is very much like (maybe it's the same except for permissions) as calling a nested […]
2003-07-11
1 reads
2003-07-11
SET ROWCOUNT your_number_of_row. causes SQL Server to stop processing the query after the specified number of rows are returned. or Using TOP and PERCENT to limit the number of rows returned in the result set.
2003-07-10
BOL - identifiers,delimited will give you a listing plus advice.
2003-07-10
quote: Yes you are right a5, when you see the tables from the EM, it may not show the tables in the Task pad view if the table does not have an index. This behavior is corrected in SP2 Aah, that's was the reason it went away Good to know for the future, thanks! Cheers, […]
2003-07-10
Try this declare @sqlstring nvarchar(1000), @table_name varchar(25), @cntout as int set @table_name = 'tableA' set @sqlstring = 'select @cntout = count(*) from ' + @table_name exec sp_executesql @sqlstring, N'@cntout as int OUTPUT', @cntout = @cntout OUTPUT PRINT @cntout
2003-07-10
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers