Al Programming

SQL Server > XML Data XML support is integrated into all the components in SQL Server. FOR XML clause

SQL Server  >  Built-in Functions   > SOUNDEX SOUNDEX converts an alphanumeric string to a four-character code that is based on how ...

SQL Server  >  Built-in Functions   > TRY_CAST Try to cast a value to the specified data type.  If the cast not succeeds returns nu...

SQL Server  >  DML   > INSERT INSERT  adds one or more rows to a table or a view. When insert data into a view, the view must r...

SQL Server  > System tables sysobjects

SQL Server > Operators > Subtract - Operator (minus) subtracts two numbers or a number (in days) from date. Example 1. Sub...

SQL Server > Scripts > Row Size create table ##RowSize ( tableName nvarchar ( 50 ), rowSize int ) exec sp_msforeachtable ...

SQL Server  >   System Stored Procedures  >  sp_dbremove Removes a database. Example EXEC sp_dbremove HR;

SQL Server  >  Built-in Functions   > STR Converts number to varchar. STR ( expression , length , decimal ) Example: SELECT ...

SQL Server > Transact-SQL Transact-SQL is Microsoft's proprietary extension to SQL (Structured Query Language). All applications...

SQL Server  >  Built-in Functions   > PARSE Translates an  expression  to the requested data type. Example SELECT PARSE ( ...

SQL Server  >  Built-in Functions   > CONVERT CONVERT  converts an expression of one data type to another. Example select CONV...

SQL Server  >  Built-in Functions >  APP_NAME APP_NAME returns the application name for the current session. Example: select A...

C#  >  System.Data    > SqlClient > SqlBulkCopy SqlBulkCopy efficiently bulk load a SQL Server table with data from another sou...

SQL Server  >  Built-in Functions   > CAST CAST converts an expression of one data type to another. CAST ( expression AS data_t...

SQL Server > Built-in Functions   > FORMAT Formats a values to specific format. Example: A. DECLARE @d DATETIME = ...

SQL Server  >  Built-in Functions   > LOWER Converts  uppercase character data to lowercase. Example SELECT lower ( 'SQL S...

SQL Server > DDL > Drop DROP statements removes existing entities. DROP TABLE DROP TRIGGER

SQL Server > Catalog Views > sys.schemas Gets information about database schema. Example: select * from sys . schemas R...

SQL Server > Catalog Views > sys.data_spaces Return info for each data space. Example select * from sys . data_spaces ...