|
|
Browse by Tags
All Tags » Microsoft » T-SQL
-
My learned colleague Howard van Rooijen recently blogged about the new release of Microsoft Source Analysis for C# (aka StyleCop) and his enthusiasm for the tool was near-tangible.
This tool analyses your source code and suggests changes that may be in line with best practice coding skills and the ultimate aim is for a consistent ...
-
SQL Server 2005 includes the WITH CUBE and WITH ROLLUP syntaxes that are used to display summary information for combinations of columns in the GROUP BY clause. That's useful functionality but it didn't provide particularly fine-grained control over what summaries were returned. Essentially it was all-or-nothing.
In katmai, the next ...
-
A very short post here showing some of the new T-SQL constructs in katmai.
Check out the following code snippet:declare @i int = 1;set @i += 1; create table t1 (col1 int);insert t1 values (@i),(@i+1); There are actually three syntax enhancements in there. Can you spot them? No? Let me fill you in:Initialisation at the same time as ...
-
Two days ago I posted a blog entry here that showed how the following SQL statement: select dp.NAME AS principal_name, dp.type_desc AS principal_type_desc, o.NAME AS object_name, ...
-
Today I was asked how one can query the server to list out all permissions that a principal has on all the securables in a SQL Server database. After 10 mins of searching through BOL I came up with the following that seems to work quite well: 1 select dp.NAME AS ...
|
|
|