RE: Tough sql statement conversion
quote: I came up with the SQL statement like this but not returning exactly what is expected: What were you expecting vs. what were your results?
2003-08-01
1 reads
Analysis Services (SSAS)
RE: How can I show results while WHILE is running
Allen, Yep, I know they will appear in the Message window. That's what I want to happen. But they all appear at once, not as they occur in the WHILE statement. I ran it for one day, the results showed up in 4 minutes. I ran it for 10 days and never saw a result […]
2003-08-01
RE: How to Break a While ?????
you could also use BREAK declare @i int set @i = 0 while @i < 60 begin set @i = @i + 1 print @i if @i > 9 begin Print 'exited while statement' break end end
2003-07-30
RE: Query Analyzer and Recent File List
It appears to be a fixed number. There's registry key: HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQL Query Analyzer\Recent File List but playing with it has no effect. Cheers, - Mark
2003-07-30
1 reads
RE: Truncating transaction log
Thank you very much for your response!! But, Is there any GUI option to truncate transaction log (as in SQL Server 7) without setting the database options such as "Simple Rocovery model" etc,?
2003-07-29
RE: Getting day of week from datetime value
Select DATENAME(dw , Cast('2003-07-27 23:55:02.093' as DateTime)) Don't have to do the cast bit!
2003-07-28
RE: Change Tcp port
Yes you can change the port to any unused port. You can do this using the 'Server Network Utility'. A restart of the SQL Server will be required.
2003-07-26
1 reads
RE: Creating Extended SP using Visual Basic
Thanx all for keeping the thread live...it took sometime for me to come to conclusion....anyways i'd created a dll and called it using the following functions... *************************** DECLARE @object int DECLARE @hr int DECLARE @property varchar(255) DECLARE @return varchar(255) DECLARE @src varchar(255), @desc varchar(255) -- Create an object. EXEC @hr = sp_OACreate '{0839A7DC-8313-441D-BC73-C4A6D14B65D8}', @object OUT […]
2003-07-25
1 reads
RE: Bad practices
I'll follow mccork, our developer dbas always start with unicode, until I push back. Of course they also love Varchar(1) !!!! Worse they start at NVarChar(1). KlK, MCSE
2003-07-22
RE: Enterprise manager reacts slow
They both use the same controls. However once things are loaded in EM, they will be quicker in Computer Management. I suspect that the MMC for computer management might pre load some things, but AFAIK, these are the same snap ins. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-07-18
2 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers