Recent update: 2008-3-21
64 byte By
akula at 2008-1-10
Any chance of getting an aggregate to combine varchar's in 08?
64 byte By
akula at 2008-1-10
Any chance of getting an aggregate to combine varchar's in 08?
64 byte By
akula at 2008-1-9
Any chance of getting an aggregate to combine varchar's in 08?
in SQL 2008 (or in the future), is there a plan to allow something similar to: Code SnippetSelect * FROM(EXEC spProcedure @NamedParameter='test') Or, more likely: Code SnippetSelect * from udfTest(@NamedParameter='test') It has always been something nettlesome - either use ...
<font face=Arial size=2>Is it possible to be able to find out from within a stored procedure where that procedure was called from?</font> Thanks, <blockquote dir=ltr style="margin-right:0px"> -Rob </blockquote>
Will partitioning on multiple columns be supported in SQL 2008, without needing to use the computed column option? Thanks for any help
<font face=Verdana>Is any more function available in KATMAI, to know the OS version of the DB server ?</font>
<font face=Verdana>Is any more function available in KATMAI, to know the OS version of the DB server ?</font>
hi, i currently don't have a katmai installed on my box. just wanted to ask whats the result of SELECT @@version thanks /rh4m1ll3
hi, i currently don't have a katmai installed on my box. just wanted to ask whats the result of SELECT @@version thanks /rh4m1ll3
Declare @Code varchar(3) Declare @Description varchar(15) Set @Code = 'ABC' Set @Description ='Merge' Merge into tblData T USING TblData S ON S.Code = @Code WHEN MATCHED THEN UPDATE SET t.Description = @Description WHEN NOT MATCHED THEN INSERT (Code,Description) VALUES ...
Is this on the list for Katmai? (BOL shows only what is available in the current CTP, so it is hard to know). thanks
Are we to expect support for Row Constructors beside what is in the current CTP (i.e. beside what is shown for INSERT? Examples: Select * From MyTable Where (a,b) in (Select a,b From OtherTable...); or Update MyTableSet (a, b, c, d) = (SELECT a, b, c, d From OtherTable ....)Where ...; ...
Declare @Code varchar(3) Declare @Description varchar(15) Set @Code ='ABC' Set @Description ='Merge' Mergeinto tblData T USING TblData S ON S.Code = @Code WHENMATCHEDTHENUPDATE SET t.Description = @Description WHENNOTMATCHEDTHENINSERT(Code,Description) VALUES(@Code,@Description); ...
276 byte By
Rob78 at 2008-1-4
We're in the process of making SQL syntax changes to prepare for an upgrade to SQL 2005, and I don't want to go through this particular exercise again if we can get everything compliant for SQL 2008 while we're making the current changes. Thank you, Rob
With LINQ becoming the language for developement in SQL Server 2008 , is Microsoft going to gradually come out of SQL . Any enhancements to T-SQL in Katami ? Thanks
536 byte By
Sakthi at 2008-1-4
Hi, In oracle we have column variable declaration i.e we can use the column data type in procedures and functions. Example: employeeAgeType employees.emp_age%TYPE; When i change the column datatype or length, the impacted procedure or function will automatically takes the type. But this is ...