Suppose we have a table emp_plan which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its structure is given below:-
Create table emp_plan (empid nvarchar(200),planid...
2015-08-03
1 reads
Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of...
2015-07-11
1,469 reads
Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of distinctively decent competitors they have within the space of...
2015-07-11
Below script will help in finding the complete months within the 2 given dates. In the below script we takes...
2015-07-10
808 reads
Below script will help in finding the complete months within the 2 given dates. In the below script we takes below dates as exampleStartdate =2015-07-05Enddate =2016-01-06
/**********************Script Start**************************/IF (object_id('tempdb..#month') is...
2015-07-10
1 reads
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the...
2015-07-10
785 reads
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the complete weeks within 2 given dates. In this script,...
2015-07-10
For any programming language, just writing the code is not well enough. It should be written using the best practices....
2015-02-01
4,138 reads
For any programming language, just writing the code is not well enough. It should be written using the best practices. This article will try to explain the disadvantages of...
2015-02-01
2 reads
Right():- This function returns the specified number of characters from the Right part of the given character string.Syntax:- Select RIGHT ( character_expression , integer_expression ) For example, the below query will...
2015-01-26
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Comments posted to this topic are about the item 50 Years of Microsoft
Comments posted to this topic are about the item Multiple Collations
Comments posted to this topic are about the item Retrieving Data Using the REST...
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers