Home Dashboard Directory Help
Refine Search Results
Status
Votes
Total Votes (at least)
Workarounds
Total Workarounds (at least)
Validations
Total Validations (at least)
Comments
Total Comments (at least)
Time
Created in the last (days)
Updated in the last (days)
Product Search Results
Sort By:
You searched for: items submitted by TechVsLife2 for this product (signing in could show even more results)
Showing 1 - 10 of 27 Previous 123 Next

2
0
Sign in
to vote
From Connection: SQL Server
UPDATES TO BELOW: 1. Interestingly, if you replace the table name in the sproc code with a table that does NOT exist, then the sproc does NOT give an error and runs correctly. 2. Bug is not present …
Created on 10/28/2015 (updated 5 weeks ago) | 1 validation | 1 workaround | 0 comments | feedback id: 1953249  | 
Active
1
1
Sign in
to vote
From Connection: SQL Server
select format(cast('07:35' as time(0)), N'hh:mm'); gives null. select format(cast('07:35' as datetime2(0)), N'hh:mm'); works. select format(cast('07:35' as time(0)), N'hh\:mm'); works.
Created on 10/4/2015 (updated 18 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 1867727  | 
Closed
as Fixed Help for as Fixed
5
0
Sign in
to vote
From Connection: SQL Server
BOL is sometimes misleading regarding how implicit type conversion regarding float and decimal work. In particular, the documentation for the POWER function is wrong and causes confusion. SELECT PO…
Created on 8/13/2012 (updated 186 weeks ago) | 2 validations | 0 workarounds | 2 comments | feedback id: 758014  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
(More of a suggestion than a bug:) The help for some sql server topics (for example, CASE and SELECT) uses single quote marks as column identifiers, which has in some forms (e.g. select 'A'='B') alrea…
Created on 2/10/2012 (updated 218 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 724381  | 
Closed
as Fixed Help for as Fixed
3
0
Sign in
to vote
From Connection: SQL Server
This is either bug or suggestion, depending on what the cause is. (There may be a reasonable cause for this behavior, but I'd like to make sure this has been looked at, since it makes a great differe…
Created on 1/10/2012 (updated 84 weeks ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 717964  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
to vote
From Connection: SQL Server
The documentation for sp_addlinkedserver (Transact-SQL) is incorrect regarding access 2007 or 2010 files, as there is a bug and you can't currently connect to Access 2007/Access 2010 files via linked …
Created on 12/22/2011 (updated 84 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 715272  | 
Closed
as Not Reproducible Help for as Not Reproducible
1
1
Sign in
to vote
From Connection: SQL Server
An issue with adding columns to tables, if the tables already have calculated columns: I can add a column easily to such a table using one line of t-sql, but Juneau (the table designer of Juneau) reje…
Created on 9/5/2011 (updated 215 weeks ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 687301  | 
Closed
as Not Reproducible Help for as Not Reproducible
1
0
Sign in
to vote
From Connection: SQL Server
The following legal t-sql syntax Juneau ctp3 believes to be incorrect, and produces a warning in its errors list (when the code is in a stored procedure): UPDATE r SET r.fld = 0 FROM dbo.tbl AS r WHE…
Created on 8/19/2011 (updated 246 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 684848  | 
Closed
as Not Reproducible Help for as Not Reproducible
1
0
Sign in
to vote
From Connection: SQL Server
The errors list in Juneau persists warnings for a LONG time, even after the object causing the warning has been deleted. As far as I can tell, there is no way to "force refresh" on the list or I didn…
Created on 8/19/2011 (updated 246 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 684847  | 
Closed
as Not Reproducible Help for as Not Reproducible
1
0
Sign in
to vote
From Connection: SQL Server
UPDATE: After testing with Adi Unnithan, I wasn't able to reproduce again after exiting and restarting visual studio. I did notice a "record macro" was running on my first instance of juneau, becaus…
Created on 8/19/2011 (updated 247 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 684844  | 
Closed
as Not Reproducible Help for as Not Reproducible
Showing 1 - 10 of 27 Previous 123 Next