ec2 server types

In our daily development process, when designing a database, we often encounter problems with selecting data types, choosing what type of data is most appropriate, and then choosing the corresponding CLR type when we create the corresponding entity in the project. In response to these questions, this article was born. SQL Server data types

Server data type Description Synonymous Bit 1 digits, value 0 or 1 Int Integer 4 bytes, value is -2^31~2^31-1 Smallint 2 bytes, value is -2^15~2^15-1 Tinyint 1 bytes, value is 0~255 Decimal (P,s) numeric data, with a fixed precision of p, and a width of s Numeric Money 8 bytes, store currency type, value is -2^63~2^63-1 Small Money 4 bytes, store currency type, value is -214748.3648~+214748.3647 approximate numeric data type Float (N) n between 1~24,

Label:Snapshot publication:The publisher sends a snapshot of the published data to the Subscriber at a predetermined interval.Transactional publications:After the subscriber receives the initial snapshot of the published data, the publisher streams the transaction to the Subscriber.Peer Publishing:Peer publishing supports multi-master replication. The publisher streams the transaction to all peers in the topology. All peer nodes can read and write changes, and all changes are propagated to all n

created when the type is created, and you cannot use the ALTER statement.Declare table variables according to table typeDECLARE @table_variable type_name;Table variablesA table variable is a type of data that has the structure of a table and the functionality of some tables. It can be queried, inserted, updated, deleted. It is important to note that table variables cannot be used with select: INTO statement Insert dataBut temporary tables can. Table variables can be used in combination with sto

Tags: bar type convert int mil false cond reserved--HarThe time (2) type retains two bits of milliseconds, and after the application converts the time (2) type to int to SQL Server, the following two methods can convert int to time (2):--Method 1 DECLARE @T int SET @T = 10455836 SELECT DATEADD (Hour, (@t/1000000)%, DATEADD (minute, (@T /10000)%, DATEADD (second, (@t/100)%, DATEADD (millisecond, (@T%) *, cast (' 00:00:00 ' asTime (2)))) --Method 2 SELE

Tags: fixed har char trim definition length take number requires VarThe length of the char type is immutable in SQL Server, and the length of the varchar is variable.When depositing data:If the data type is char, when a fixed length of a field is defined, if the length of the stored data is less than the length of char, then the length of data stored in the data is still defined field length, the data format will be stored in the data and space;If the

. No_log and truncate_only are synonymous. Here's a question, what is the activity log, Microsoft's explanation is: The portion of the log file from the first log record that must exist to ensure that the database is successfully rolled back to the last written log record is called the active part of the log, which is the activity log. This is the section of the log required for full database recovery. You can never truncate any part of the activity log. DBCC shrinkdatabase shrinks al

of digits that can be stored (left and right of the decimal point). P must be a value between 1 and 38. The default is 18. The s parameter indicates the maximum number of digits stored to the right of the decimal point. s must be a value between 0 and P. The default is 0. 5-17 bytessmallmoney The currency data between -214,748.3648 and 214,748.3647. 4 bytesMoney data between -922,337,203,685,477.5808 and 922,337,203,685,477.5807. 8 bytesfloat (n) floating precision digital data from -1.79e + 30

Create function fun_a () #标题函数, create function Fun_name () returns OUTPUT_TYPE as begin return value end;returns intAsBeginreturn 1;EndGoCreate function Fun_b () #多语句用户定义函数, create function Fun_name () returns @value table (Colum_list) as begin return; end Returns @tb table (ID int, Name nvarchar (8))AsBeginInsert into @tb (id,name) VALUES (1, ' 111 '), (2, ' 222 ');ReturnEndGoCreate function Fun_c () #内联用户定义函数, create function Fun_name () returns table as return select ...;Returns tableAsRe

Secondary indexCreateXmlIndexIxml_xmltable_xmlcol_property onXMLTable (xmlcol) using XMLIndexIpxml_xmltable_xmlcol for Property--XML Content Secondary indexCreateXmlIndexIxml_xmltable_xmlcol_value onXMLTable (xmlcol) using XMLIndexIpxml_xmltable_xmlcol forvalue------------------------------------------------------------------------------------Query StatementsSelect TOP +Xmlcol.query ('(/authorinfo/personinfo) [1]') asXm fromXMLTableSelect * fromXmlTablewhereXmlcol.value ('(/authorinfo/personi