Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bitbucket » SQL 2008 T-SQL
Add to briefcase
24 posts, Page 1 of 3
123»»»

SQL 2008 T-SQL Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
bitbucket-25253
Posted Monday, August 24, 2009 8:36 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:02 PM
Points: 5,100, Visits: 20,195
Comments posted to this topic are about the item SQL 2008 T-SQL

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read
Post #776407
Aluminum
Posted Tuesday, August 25, 2009 6:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:07 PM
Points: 353, Visits: 287
Ummm.... I had an error when processing this sql. That is the option I picked before I answered and decided to check it after I was wrong.
Post #776621
kramaswamy
Posted Tuesday, August 25, 2009 7:42 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 1:53 PM
Points: 785, Visits: 1,534
did you try it in SSMS 2008? doens't work in 2005, those features are part of the 2008 version.
Post #776678
Aluminum
Posted Tuesday, August 25, 2009 7:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:07 PM
Points: 353, Visits: 287
Did not. Thanks for the post.
Post #776684
Michael Poppers
Posted Tuesday, August 25, 2009 8:05 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, January 17, 2013 2:34 PM
Points: 565, Visits: 360
I thought @msg *= 3 would not work -- my bad .
Post #776712
kevin.l.williams
Posted Tuesday, August 25, 2009 9:15 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:29 AM
Points: 2,794, Visits: 1,123
I thought this wouldn't work because I assumed 2005 worked the same as 2008. I was surprised to see that I was wrong. I wanted to see it work in 2008 but when I ran it my server returned this error.

@i @Msg Date
----------- ----- --------
An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column 'Date'. The GetBytes function can only be used on columns of type Text, NText, or Image.

What does this mean?

-Kevin


Post #776782
Bhavesh-1094084
Posted Tuesday, August 25, 2009 10:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 25, 2011 2:41 AM
Points: 145, Visits: 99 
DECLARE @i AS INT = 100,@msg AS VARCHAR(5)= '11',@Date AS DATE=GETDATE()

will generate error "Cannot assign a default value to a local variable."

Bhavesh
.NET and SQL Server Blog
Post #776867
kevin.l.williams
Posted Tuesday, August 25, 2009 10:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:29 AM
Points: 2,794, Visits: 1,123
bhavster27 (8/25/2009)
DECLARE @i AS INT = 100,@msg AS VARCHAR(5)= '11',@Date AS DATE=GETDATE()

will generate error "Cannot assign a default value to a local variable."


Not for SQL 2008


Post #776892
KevinC.
Posted Tuesday, August 25, 2009 10:55 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, December 07, 2010 12:55 AM
Points: 771, Visits: 504
Good question!
Post #776897
john.moreno
Posted Tuesday, August 25, 2009 11:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:31 PM
Points: 339, Visits: 950
On my SQL 2008 server (using the Master database so no question of compatibility level) this fails with the previously mentioneed "GetBytes function" error.

use master
DECLARE @Date AS DATE=GETDATE()
SELECT @Date as '@Date'

An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column '@Date'.  The GetBytes function can only be used on columns of type Text, NText, or Image.

If you explicitly cast the DATE to CHAR or VARCHAR then it works (also if you change the type of date to DATETIME). I'm not sure why this is so, as the conversion page says that there is an implicit conversion from Date to char and varchar AND no conversion possible to Text, NText or Image.

So, I got the right answer for the wrong reason, but it was graded wrong for an unknown reason. Sounds fair to me.
Post #776918
« Prev Topic | Next Topic »

Add to briefcase
24 posts, Page 1 of 3
123»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.