sql server scalar function example

entered in the numeric expression Rand returns the random float value between 0 and 1 round returns the numeric expression and rounding to the specified length or precision sign returns the positive (+ 1) of the given expression), zero (0) or negative (-1) Signs sin returns the given angle (in radians) in an approximate number (float) expression) Square returns the square of the given expression SQRT returns the square root of the given expression tan returns the tangent of the input exp

Recent time from the client to the background to write services, for the background database and service writing is a small white, so the recent written certainly not too much technical content. First put the problems encountered: or that error on the report, the main fields have reported error ID (ErrorID), reported (Reportperson), escalation time (reporttime) accurate to milliseconds, now to do the statistics are: (1) Statistics for a certain period of time " From start to end time is accurat

+name from Car; The query here will display the code and name two varchar type Lian as a string concatenation.Similarly, if it is a column of two value types, it will follow the mathematical operationConvert (type, column name) type conversionCast (column name as type)Time-Date functionGETDATE () Gets the current timeYear (GETDATE ()) Gets the years in the current timeMonth (GETDATE ()) Gets the months in the current timeDAT (GETDATE ()) DayIsDate (time date) determines whether the time date is

Query table: select * fromsys. objectswheretypeU query Stored Procedure select * fromsys. objectswheretypeP query Stored Procedure content EXECSp_HelpText stored procedure name query User-Defined Function select * fromdbo. Explain query User-Defined Function content EXE Query table: select * from sys. objects where type = 'U' query the Stored Procedure select * from sys. objects where type = 'P' queries th

-- Simple Case FunctionCASE sexWHEN '1' THEN 'male'WHEN '2' THEN 'female'ELSE 'others' END-- Case search functionCase when sex = '1' THEN 'male'WHEN sex = '2' THEN 'female'ELSE 'others' END These two methods can achieve the same function. Simple Case functions are relatively simple in writing, but compared with Case search functions, there are some functional limitations, such as writing Case functions.Note that the Case

-- Simple Case FunctionCASE sexWHEN '1' THEN 'male'WHEN '2' THEN 'female'ELSE 'others' END-- Case search functionCase when sex = '1' THEN 'male'WHEN sex = '2' THEN 'female'ELSE 'others' END These two methods can achieve the same function. Simple Case functions are relatively simple in writing, but compared with Case search functions, there are some functional limitations, such as writing Case functions.Note that the Case

CREATE TABLE student (ID VARCHAR2 (5) Primary key,name VARCHAR2 (+), not null,sex char (2) Check (sex= ' male ' or sex= ' female ')--to Stude NT inserts a piece of data, using a function to verify that the insert is correct create or replace function (f_id in Varchar2,f_name in Varchar2,sex in varchar2) return VARCHAR2 isc_ ID number;beginif f_id is null thenreturn (' number cannot be empty, record is not s

--sql Regular Replace function The Code is as follows: CREATE function Dbo.regexreplace ( @source ntext, the original string @regexp varchar (1000),--Regular expression @rep Lace varchar (1000),--Replaces the value @globalReplace bit = 1, whether it is global replace @ignoreCase bit = 0-Ignore case ) ReturnS varcha R (1000) as begin Declare @hr integ

Use sum (SUM) FunctionThe sum function is used to return the sum of all values in the expression. This function is usually used to summarize some data. Syntax: Sum ([All | distinct] expression) Parameter description: L all: Performs aggregate function operations on all values. All is the default setting. L distinct: Specify sum to return the sum of unique values.

Tags: font and interval Lower OLE lua ber boolean value simhttps://docs.microsoft.com/en-us/sql/t-sql/functions/rand-transact-sql?view=sql-server-2017Generate random numbers within a certain intervalHttps://stackoverflow.com/questions/7878287/generate-random-int-value-from-3

If you want to remember the records in a table for random display, or randomly extract a record, we do not need to write a long stringProgramCodeHow can we create a random number and then make a so-called "random record"? You only need to use a small function in SQL Server to implement the random sorting or random extraction