Acordeon De Bases De Datos

List of useful commandsSp_helpSp_helptextSp_dependsSp_helpconstraintSp_lock (informacion de los candados)Sp_configure “lock scheme” (show locking scheme)JoinSelect * from t1 join t2 on t1.c =t2.cSelect * from t1, t2 where t1.c = t2.cGroup bySelect c1, sum(c2) from t group by c1 having sum(c2)Insert Insert into t values(v1,v2…)Select * into t from pubs2…tUpdateUpdate t set c = v[where…]CaseUpdate t set v= Case When v = “old value 1” then v = “new value 1” When v = “old value 2” then v = “new value 2” When v2= “cosas” then v = “new value 3” Else v EndWhere…View (no puede llevar orderby)Create view myview as select * from ….GrantGrant [select|update|delete|insert|all] on view to userWith check option (restringe)RevokeRevoke select on view from userIndexCreate [clustered|unique] indexnameIndex on t(c1,c2…)Tempo tableCreate table #t(v char(4)…)Create table tempdb…t (v char(4)…)Constraint * Constraint cname check (c like “9”) * Default “value” * Constraint cname primary key(c1,c2…) * Constraint cname unique (c1,c2) * Constraint cname foreign key (c1, c2…) references t2(c1,c2…)Create table t1( C1 char(2) default “a”, C2 int unique, Constraint c1 primary key (C1))AltertableAlter table [add|drop|modify] [column| constraint]Group byselect t1.title_id, t1.type, t1.advance, sum(t2.advance) as "cumulative"from titles t1, titles t2where t2.title_id <= t1.title_id andt1.type = t2.type and t1.advance is not nullgroup by t1.title_id, t1.advanceorder by t1.title_id,t1.type | DefaultCreate default defName as 5Sp_binddefault defName, “table.colum”Sp_unbinddefault“table.column”Drop default defNameRulesCreate rule rulName as @var [like|in|<|=…]Sp_bindrule rulName, “table.column”Sp_unbindrule “table.column”Drop rule rulNameFunctionsUpper(), lower(),substring(expression, start, lenght), right(expression,length), charindex(expression,expression), getdate(), datename(datepart,date_expr), datepart(yy-mm,date_expr), count, avg, Isnull(columna,valor no null que...