Posts
Sort by recent activity
JOIN CONDITION
on suggestion for join : Is it possible to haveSELECT *
FROM table1 a
JOIN table2 b on b.id = a.id
-- instead of
SELECT *
FROM table1 a
JOIN table2 b on a.id = b.id
in my opinion , after th...
Format insert into
v4 is really great, but one this is bugging me
i already said something about this, but it really frustate me :
in V3 :INSERT INTO TABLE1 (
COL1,
COL2,
COL3,
COL4
) VALUES (
/* CO...
SP suggestion
Im not able to have suggestion for stored procedure
exec sp_helptext <control+space> was working in v3
am i missing an option ?
sys table and information_schema view and insert statement
-no suggestion for all the sys table ? or information_schema view ?
it's very usefull ...
- too much line for the insert into.it make the code less readable.
1 line for the column value, 1 line for...
dbo
is there a way not to have select * from dbo.tablename ?
and have select * from tablename instead