Up until about two months ago, I thought it was totally silly and had very little use... But, one, I hope "clever" <g>, of them did spring to mind. I've been writing a doc management system which is to have very tight security, etc, etc. The customers can write their own custom reports which can […]
2003-05-18
A temporarily solution could following code change be: select @cnt = count(*) from #a, fh where ... if @cnt between 1 and 4 begin set @SQLCacheProblem = '1' set rowcount 1 end while @cnt > 0 begin update fh set ... select @dbc=@@RowCount, @dbe=@@Error if @dbe<>0 begin ... return end if @SQLCacheProblem <> '1' set […]
2003-05-18
1 reads
quote: Might be a good idea to handle leap years here .. It's not obvious to me how this does not handle leap years. If your birthday is leap day, and it's not a leap year, then on February 28 it would not have been your birthday yet, and on March 1 it would have […]
2003-05-16
Brian will be writing a monthly column for us on SQL Security, definitely a hot topic these days! He starts off by discussing the need for a built in db_executor role and how to grant permissions manually to achieve the same effect. Terrific concept, as granting table access can lead to bad things! If there is a security topic you'd like to see more info on, post a note to the article or email us at articles@sqlservercentral.com.
2003-05-16
36,053 reads
If the following thread doesn't answer your questions, please provide more information as to what you are trying to achieve. http://qa.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12236&FORUM_ID=5&CAT_ID=1&Topic_Title=Config+Sql+Mail%2E%2E&Forum_Title=Administration
2003-05-15
I've used Notes. It is more of a document management system that an RDBMS. If you are storing documents then, obviously Notes is the way to go. Incidently I know someone who has a Notes front end to a SQL database. The only thing I have against Access is that it can cause locking problems […]
2003-05-15
1 reads
Probably depends on what you're working with. OpenXML is a pretty valuable construct. I don't use For XML as much, but I do mostly desktop stuff, not web, so maybe it makes more sense there. I think it's nice to have the option. I'd like to be able to store XML docs and query them […]
2003-05-14
Thanks for the help! I will use this guidance to try to solve the problem ... if you have time and wouldn't mind - I am not yet clear on how to create/name the cursor and populate the @TestNameVariable ... the beginning/surrounding code... THX again. quote: You'll have to build a dynamic sql statement in […]
2003-05-14
Check SQL Server errorlog to see whether you have an entry "SQL server listening on TCP, Shared Memory, Named Pipes.". Select * from sysprocesses to verify which protocol your users connect to SQL Server.
2003-05-14
1 reads
quote: Not happy with Sybase? Curiosity impels me to ask, why not? It's more of a case of having used SQL since 6.5 and having experience with SQL7 and SQL2000 since their first release going back to SyBase seems a big step back. Add to this that the server has been installed as case sensitive. […]
2003-05-14
By Steve Jones
Often I see running totals that are written in SQL using a variety of...
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
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