sql server convert int to string

Original article: http://blog.csdn.net/ylqmf/article/details/4972034 Method 1 Write a function -- String comparison functions that are case sensitive to stringsCreate function [dbo]. [StrComp] (@ Str1 NVARCHAR (50), @ Str2 NVARCHAR (50 ))Returns integer--1 is equal, and its return value is not equal.ASBEGINDeclare @ hashcode1 varbinary (32)Declare @ hashcode2 varbinary (32)Declare @ result int Select @ has

Label:In SQL server databases, SQL Server DateTime format conversion strings can change the format of SQL Server date and time, which is what every SQL database user should know. In thi

Label:SELECT CONVERT (varchar), CAST (@testFloat as Decimal (38,2)))SELECT STR (@testFloat, 38, 2) Import from Excel to sql2000, there is a column "contact" has become a float type, I want to convert to nvarchar type, with the following statement Select convert (nvarchar (+), convert (

database name (the database collection makes up the server), the two are the same user id/uid=username//login name when using SQL login password/pwd=password//password when using SQL login For other key values, please refer to: https://www.cnblogs.com/niuyjdz/p/7533439.htmlIv. four parameters of the open () function connected to the database:Open the database wi

Tags: logs convert weight made with int span app DivSQL Server Profiler caught a lot of code in the job, applicationname similar to Sqlagent-tsql JobStep (Job 0x94b9b5c016e8d94fb50898c868314d08:st EP 1) Such a Need to convert the binary name in the job into job_id The conversion is done in the following ways: Declare @

security architecture, hard coding of connection strings, etc., and is worth using. SQL Native Client ODBC Driver Standard secure connection Copy Code code as follows: Driver={sql Native Client}; Server=myserveraddress;database=mydatabase; Uid=myusername; Pwd=mypassword; Are you using SQL

F_splitstr (@s varchar (8000),--string to be split@split varchar (10)--Data delimiter) RETURNS TABLEAsRETURN (SELECT Col=cast (SUBSTRING (@s,id,charindex (@split, @[email protected],id)-id) as varchar (100))From Tb_splitstrWHERE Idand CHARINDEX (@split, @[email protected],id) =id)GO --Method 4: Use SQL server2005 outer APPLY CREATE FUNCTION [dbo]. [Ufn_splitstringtotable](@str VARCHAR (MAX),@split VARCHAR

I. NET Framework Data Provider for SQL ServerType:. NET Framework Class LibraryUse: System.Data.SqlClient.SqlConnectionManufacturer: Microsoft 1. Standard secure connection Copy Code code as follows: Data Source = myserveraddress;initial Catalog = myDataBase; User Id = MyUserName; Password = mypassword; Use the server name \ Instance name as the connection to specify the data source for th

= ' 01-2002-03 'SELECT @dt--Results: 2002-01-03 00:00:00.000--the date entered does not specify the century partSET @dt = ' 01-02-03 'SELECT @dt--Results: 2003-01-02 00:00:00.000GO--3./*--descriptionIf the date entered does not contain a date separator, SQL Server interprets the dateSetting for set DATEFORMAT is ignored.--*/--example, in the following code, the character date that does not contain the date

)--Data delimiter) RETURNS TABLEAsRETURN (SELECT Col=cast (SUBSTRING (@s,id,charindex (@split, @[email protected],id)-id) as varchar (100))From Tb_splitstrWHERE Idand CHARINDEX (@split, @[email protected],id) =id)GO--Method 4: Use SQL server2005 outer APPLYCREATE FUNCTION [dbo]. [Ufn_splitstringtotable](@str VARCHAR (MAX),@split VARCHAR (10))RETURNS TABLEAsRETURN(SELECT b.idFrom (SELECT [value] = CONVERT (X

corresponding to the ASCII code numberChar (integer_expression) integer_expression an integer between 0 and 255. If the integer expression is not within this range, a NULL value is returned.Select Char (72)Returns a Unicode character that returns a specified integer codeNCHAR (integer_expression) integer_expression a positive integer between 0 and 65535. If a value beyond this range is specified, NULL is returned.Select NCHAR (1000)Returns a Unicode string