RE: Comments and Bugs on New Design
FYI: The replies counter in forums is not correct. It goes from 0 to 2. Is there a way to Unsubscribe from a topic notification ?
2003-12-12
TRY..CATCH
RE: Sequential Numbering
Another way to do this is using Indentity, not using it as a property of a column, but as function in a TSQL statement. Using your example: select Identity(int,1,1) as rank, Hiredate, LastName, Firstname into #hireDate from northwind.dbo.employees where Title = 'Sales Representative' order by HireDate Select cast(rank as char(4)) as Rank, cast(hiredate as varchar(23)) […]
2003-12-08
2003-11-25
1 reads
2003-07-25
RE: Code to Format Numeric Data?
Something like this developed into a function might do the trick. Ex. DECLARE @var varchar(40) declare @tempVar varchar(40) set @var = '48501239955.486' set @tempVar = rtrim(ltrim(reverse(@var))) select @var = reverse(left(@tempVar,charindex('.',@tempVar))), @tempVar = right(@tempVar,len(@tempVar) - charindex('.',@tempVar)) while len(@tempVar) > 3 begin select @var = ',' + reverse(left(@tempVar,3)) + @var, @tempVar = right(@tempVar,len(@tempVar) - 3) end select […]
2003-06-26
RE: Security Methodology Using Roles
the statement made that 'developers can't be trusted' is irresponsible - and is an example of what is wrong with a lot of the cost of doing business in the software industry lately... when industry is chock-full of prima-dona attitudes about who-did-what and the spirit of teamwork gets blown away with statements such as these […]
2003-06-25
1 reads
RE: Enjoying QOD
Thanks! There's a standings page that's half complete :). You can see it on the QOD homepage under Your Scorecard. Once there's enough points to really weigh people out there, I'll create a true standings page so people can see how they rank. The harder the question, the more points you get. Brian Knight bknight@sqlservercentral.com […]
2003-06-22
1 reads
RE: privilege to run bcp
If you're planning to use QA then the user need permission to exec. xp_cmdshell otherwise just the appropriate permissions to write data. for bulk insert: Your user has to be a member of the "Bulk Insert Adminstrators" role which is a server wide role Refer to "Bulk Insert" section "permissions" on BOL MW Edited by […]
2003-06-13
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