h1

Toate instr. create in t-sql tutoriale

March 12, 2010

1) CREATE AGGREGATE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms182741.aspx

2) CREATE APPLICATION ROLE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms181491.aspx

3) CREATE ASSEMBLY (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms189524.aspx

4) CREATE ASYMMETRIC KEY (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms174430.aspx

5) CREATE SYMMETRIC KEY (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms188357.aspx

6) CREATE BROKER PRIORITY (Transact-SQL)

http://msdn.microsoft.com/en-us/library/bb934170.aspx

7) CREATE CERTIFICATE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187798.aspx

8) CREATE CONTRACT (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms178528.aspx

9) CREATE CREDENTIAL (Transact-SQL)

A credential is a record that contains the authentication information that is required to connect to a resource outside SQL Server. Most credentials include a Windows user and password.

http://msdn.microsoft.com/en-us/library/ms189522.aspx

10) CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)

http://msdn.microsoft.com/en-us/library/bb677184.aspx

11) CREATE DATABASE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms176061.aspx

12) CREATE DATABASE AUDIT SPECIFICATION (Transact-SQL)

http://msdn.microsoft.com/en-us/library/cc280404.aspx

13) CREATE DATABASE ENCRYPTION KEY (Transact-SQL)

http://msdn.microsoft.com/en-us/library/bb677241.aspx

14) CREATE DEFAULT (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms173565.aspx

15) CREATE ENDPOINT (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms181591.aspx

16) CREATE EVENT NOTIFICATION (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms189453.aspx

17) CREATE EVENT SESSION (Transact-SQL)

http://msdn.microsoft.com/en-us/library/bb677289.aspx

18) CREATE FULLTEXT CATALOG (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms189520.aspx

19) CREATE FULLTEXT INDEX (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187317.aspx

20) CREATE FULLTEXT STOPLIST (Transact-SQL)

http://msdn.microsoft.com/en-us/library/cc280405.aspx

21) CREATE FUNCTION (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms186755.aspx

22) CREATE MASTER KEY (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms174382.aspx

23) CREATE MESSAGE TYPE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187744.aspx

24) CREATE PARTITION FUNCTION (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187802.aspx

25) CREATE PARTITION SCHEME (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms179854.aspx

26) CREATE QUEUE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms190495.aspx

27) CREATE REMOTE SERVICE BINDING (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms178024.aspx

28) CREATE RESOURCE POOL (Transact-SQL)

http://msdn.microsoft.com/en-us/library/bb895329.aspx

29) CREATE ROLE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187936.aspx

30) CREATE ROUTE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms186742.aspx

31) CREATE SYNONYM (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms177544.aspx

32) CREATE TRIGGER (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms189799.aspx

A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view.Note:
These triggers fire when any valid event is fired, regardless of whether or not any table rows are affected.DDL triggers execute in response to a variety of data definition language (DDL) events. These events primarily correspond to Transact-SQL CREATE, ALTER, and DROP statements, and certain system stored procedures that perform DDL-like operations. Logon triggers fire in response to the LOGON event that is raised when a user sessions is being established. Triggers can be created directly from Transact-SQL statements or from methods of assemblies that are created in the Microsoft .NET Framework common language runtime (CLR) and uploaded to an instance of SQL Server. SQL Server allows for creating multiple triggers for any specific statement.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: