offtop

create table dbo.Tally(i int identity(1,1))

go

insert into dbo.Tally DEFAULT VALUES

go 1000000

DECLARE @int INT;

SET @int = 1;

WHILE @int <=1000

BEGIN

INSERT INTO TestTable (id, col)

VALUES (@int, 'name' + CAST(@int AS VARCHAR(100)));

SET @int += 1;

"Bulk" appeared only in sql2005

?

change "/" to "\" for ROWTERMINATOR

declare @t table(Unit nvarchar(100))

insert into @t(Unit) values

('Unit3'),

('Unit 4'),

('Shop2'),

('Shop 5'),

('Villa 7'),

('Villa11')

select

t.unit

, left(t.unit, patindex('%[0-9]%', t.unit)-1)

, substring(t.unit, patindex('%[0-9]%', t.unit), 100)

from

@t t

?

Use Alert?

DBCC USEROPTIONS

exec sp_MSforeachdb @command1 = 'use [?]; SELECT COUNT(*) FROM MyLeads WHERE active = 1'

Select dividend/t.price as dividendYield, t.price/Bookvalue as PriceToBookValue, t.price/Earnings as PERatio From SecurityDetails

cross apply (select GetPrice(SecurityId) price) t

Select

dividend/t.price as dividendYield,

t.price/Bookvalue as PriceToBookValue,

t.price/Earnings as PERatio

From SecurityDetails, (select GetPrice() price) t

turn on logging in the package

http://connectionstrings.com/

declare @t table(id int, Name varchar(100), Mark1 varchar(100), Mark2 varchar(100), Mark3 varchar(100), Mark4 varchar(100), mark5 varchar(100))

insert into @t values(1, 'AAAA', '75', '85', '45', '65', '85')

select

id

, Details

from

@t t

unpivot...

Right click on any DB -> All Tasks -> Generate SQL Script

goto tab "options" and check "Script SQL Server logins (Windows Ans SQL Server logins)"

try change

set @sql = 'SELECT TABLE_NAME = NAME FROM ' + @dbname + '..SYSOBJECTS WHERE XTYPE =' + '''' + 'U' + ''''with

set @sql = 'SELECT...