RE: Invalid database names in SQL Server 2K
BOL - identifiers,delimited will give you a listing plus advice.
2003-07-10
SQLSaturday
RE: 'table could not be loaded' error in EM
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
RE: SQLServerAgentMail and Lotus Notes, not paging
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-10
RE: Output from dynamic sql
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
RE: vanishing databases and servers
no such joy i'm afraid. I'm actually working out of my apartment at the moment and it doesn't have a phone line. is there any way to fool it into thinking its connected
2003-07-08
RE: the update() function in a trigger
Okay, thanks. That helps me understand it better. But , if you are using it in a trigger that fires AFTER an INSERT or UPDATE, it's useless for the insert right?
2003-07-07
RE: the update() function in a trigger
No, I was saying that the INSERT INTO command will return true for update() for all columns, regardless of whether NULLS or empty strings are assigned. The following will return false for update() of col3: UPDATE Testing SET col1='a', col2='b', col4='d' WHERE .....
2003-07-07
RE: the update() function in a trigger
That means that if I have a table Testing with col1, col2, col3, col4, and I did an insert like so: INSERT INTO Testing(col1, col2, col3, col4) VALUES('a', 'b','','d') and the update() tests col3 then it will be false?
2003-07-07
RE: the update() function in a trigger
When you UPDATE the row but not SET that particular column to any value
2003-07-05
2003-07-05
Blogs
Our Contributions Towards a Stronger Open Source Future
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
Rebuilding a SQL Server Database Transaction Log
“Could you help me, we deleted the database’s transaction log file and now that...
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to...
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