Funciones String

Funciones String

1. Data Base

   • SELECT DB_ID(N'AdventureWorks2008R2') AS [Database ID];
   • SELECT DB_NAME(3)AS [Database Name];

2. Session

   • SUSER_NAME ( [ server_user_id ] )
   • SUSER_SNAME ( [ server_user_sid ] )
   • SUSER_ID ( [ 'login' ] )
   • SUSER_SID ( [ 'login' ] [ , Param2 ] )

3. Host

   • HOST_NAME ()
   • HOST_ID ()

4. User

   • USER_ID ( [ 'user' ] )
   • USER_NAME ( [ id ] )

5. Object

   • SELECT OBJECT_ID(N'AdventureWorks2012.Production.WorkOrder') AS 'Object ID';
   • OBJECT_NAME ( object_id [, database_id ] )

6. NULL

   • SELECT AVG(ISNULL(Weight, 50)) FROM Production.Product;

7. ASCII

8. REPLICATE

9. CHARINDEX

10. LEN

11. LOWER

12. CHAR

13. REVERSE

14. RIGHT

15. STUFF

16. SUBSTRING

17. UPPER

Bilder und Dateien der Mindmap