2008-08-18 (first published: 2008-06-25)
1,716 reads
cdosys
2011-11-22 (first published: 2008-03-19)
5,699 reads
RE: SQL Server stops listening
Sounds like there's wax in the network card. Take an ear bud and give it a clean. Sorry, a VERY lame attempt at humour. It's late Cheers, Crispin
2003-05-22
1 reads
RE: Variable where clause
create procedure MySP @var varchar(20) = null as if @var = null Select * from news_items else Select * from news_items where division = @var Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-05-20
RE: cast varchar as datetime
Hi 5409045121009, I tried the function you mentioned, and modified it a little so that it gave me the whole string and it worked. CREATE FUNCTION MyStrip1(@v varchar(50)) RETURNS Varchar(50) AS BEGIN Declare @vv Varchar(50) Set @vv=Right(@v,DataLength(@v)) RETURN Left(@vv,DataLength(@vv)) END Problem though is that it is returning it as a varchar value. I need to […]
2003-05-16
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
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