LEFT() function in SQL Server
Left():- This function returns the specified number of characters from the left part of the given character string.
Syntax:-
Select LEFT ( character_expression...
2014-08-11
973 reads
Left():- This function returns the specified number of characters from the left part of the given character string.
Syntax:-
Select LEFT ( character_expression...
2014-08-11
973 reads
Right():- This function returns the specified number of characters from the Right part of the given character string.
Syntax:-
Select RIGHT ( character_expression...
2014-08-11
776 reads
This function is used to returns distinct values that are returned by both the query on the left and right...
2014-08-11
1,093 reads
SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write...
2014-08-19 (first published: 2014-08-11)
10,265 reads
If you’re reading this, you probably think, like me, that SQL Server is an awesome product. One of the great...
2014-08-11
1,400 reads
(This is the first part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)
Been quiet on this blog...
2014-08-10
753 reads
(This is the second part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)
Out of a total of...
2014-08-10
577 reads
Continuation from the previous 36 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Since the very first CTP beta, I have been asking for some...
2014-08-10
188 reads
The following is the list of my articles published on SSWUG.org from March 2014 to July 2014. To read these articles, you must have SSWUG.org standard-level membership. SQL Server...
2014-08-08
19 reads
The following is the list of my articles published on SSWUG.org from March 2014 to July 2014. To read these...
2014-08-08
887 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Telp/WA 628217555651 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Telp/WA 62817825533 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers