Posts
Sort by recent activity
Could be more helpful when calling UDFs
Create the following UDF:
CREATE FUNCTION rrr (@id2 INT, @id int)
RETURNS INT AS
BEGIN
RETURN (@id)
END
Now do:
SELECT dbo.rrr(
I see both params -- very useful -- but they're out of order. How ab...
Table variables
DECLARE @n TABLE (i)
Type [space] after the "i" and I would expect to see a list of data types, not database objects, global functions, and other random stuff...
Problem with variables in UDFs (RETURN)
Try the following:
CREATE FUNCTION rrr (@m INT)
RETURNS INT
AS
BEGIN
SELECT
end
... After the SELECT, type "@, and @m" will appear in the candidate list.
Unfortunately, not so for RETURN:
CREA...
Problem with subqueries
Type this (in AW):
SELECT
(SELECT FROM person.[AddressType] q) from
[HumanResources].Employee
... Now, go to the inner SELECT list, and type "q." ... and you should get a column list from person.A...
Derived tables and CTEs
Derived table support -- FINALLY!!! Seems to be working pretty well. I've tested both inner joins and CROSS APPLY. Only problem I've found is an annoyance... Type:
SELECT p.
FROM
(
SELECT * from...
Problem in ORDER BY clause
Type:
SELECT *
FROM sys.databases n
ORDER BY
Hit [space], and "n" is the first option -- great. Now hit [enter], then "."
No column list
Issues with GDR DDL
CREATE USER User1
Hit [SPACE] and I would expect to see options that apply there... FOR, FROM, WITHOUT, etc.
GRANT
Hit [SPACE] and we should see some options...
GRANT CONTROL ON SCHEMA::
... and we...
Still no support for schemas?
USE AdventureWorks
GO
SELECT *
FROM Hum
... Where is HumanResources?
And even worse:
USE AdventureWorks
GO
SELECT *
FROM Emp
... Employee does come up (it's in the HumanResources schema) -- but whe...
When do we get to see the RC?
... Just curious
Much worse uninstall problem
I uninstalled both SQL Prompt and SQL Refactor earlier today, yet both are still showing up in SSMS. I've already rebooted twice since the uninstall, so it clearly has nothing to do with shutting ...