Posts
Sort by recent activity
My Impressions
I install ANTS on two machines, one with Win XP and one with VISTA business. On both machines installation run with no problems. On both PC's I use Visual studio 2005 with all upgrades.
I run ANTS ...
Backup/Restore error
I made a backup database. The backup failed, with this error:
SQL Backup log file
14.12.2006 15:30:07: Backing up Bicom4_SC (full database) to:
14.12.2006 15:30:07: C:\aa\FULL_(local...
Column names and comments
I still miss options for setings column names after SELECT statement.
Code like this
SELECT staffId,
staffName,
grossSalary
FROM personnel WITH (ROWLOCK)
WHERE (ty...
INNER JOIN ON problem
Select statement like this
SELECT * FROM [dbo].[Narocila] AS n
INNER JOIN [dbo].[narocila_poz] ON
I need field n.NarocId from table 'Narocila' alias 'n'.
But, if I ...
Sorting in the candidate list
I miss possibility to sort the All common objects candidate list.
Default sorting A to Z to column name is OK, but I never know exact column name so I need sort to table name, then I look into tabl...
Comment problem
This code:
ALTER PROCEDURE [dbo].[tr_obnzal_polnenje_cen]
@TipZapisa varchar(3) = 'SYS', --comments
@nMaxLev tinyint = 0,
@nLev tinyint = 0,
@JobID varchar(10)
AS
SE...
Suggestion for options for column placement
Code like this:
SELECT staffId, staffName, grossSalary
FROM [personnel] WITH (ROWLOCK, NOEXPAND)
WHERE type IN ('n', 'm')
Lay Out SQL change to:
SELECT staffId,
...