alter table MyTable add constraint MyTable_MyColumn_FK FOREIGN KEY ( MyColumn ) references MyOtherTable(PKColumn)
Category: sql sever syntax
declare @Find varchar(20) declare @search varchar(50) SET @Find=’- ‘ SET @Search=’hhhjoehhh-joehhhjoex- 02340’ SELECT COALESCE(RIGHT(@search, NullIf(CHARINDEX(REVERSE(@Find), REVERSE(@search)), 0)-1), @search)
#temp – local temporary table. This table is only visible to this session of SQL Server. When I close this session, the table will be automatically dropped. You can treat this table just like any other table with a few exceptions. The only real major…
ALTER DATABASE oldDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE oldDBname MODIFY NAME =newDBname ALTER DATABASE newDBname SET MULTI_USER
IF EXISTS (SELECT name FROM sys.databases WHERE name = N’dbname’) DROP DATABASE [dbname] GO
begin transaction update v set v.domainacct = a.login from [otherdbname].dbo.ADUserList a inner join dbo.Vacation2011 v on (v.lastname = a.lastname COLLATE SQL_Latin1_General_CP1_CI_AS and v.firstname = a.firstname COLLATE SQL_Latin1_General_CP1_CI_AS) commit transaction
select v.domainacct, a.login, a.firstname afirst, v.firstname vfirst, a.lastname alast, v.lastname vlast –into ##temp from dbo.Vacation2011 v left outer join dbo.ADUserList a on (v.lastname = a.lastname COLLATE SQL_Latin1_General_CP1_CI_AS and v.firstname = a.firstname COLLATE SQL_Latin1_General_CP1_CI_AS)
also can do for INSERT CREATE TRIGGER trig_vacReq ON dbo._vac FOR DELETE AS BEGIN INSERT INTO dbo._vacLog (vacRequestID, firstname, lastname, startdate, enddate, date_entered, LogDate, logevent) SELECT vacRequestID, firstname, lastname, startdate, enddate, date_entered, GETDATE() as LogDate, ‘Deleted’ as LogEvent FROM Deleted END
update query like this: WHERE a.lastname COLLATE Latin1_General_CI_AS = k.lastname