RIGHT() function in SQL Server
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
759 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
759 reads
Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server?
Options:-
a) 1
b) 2
c) More...
2014-04-08
580 reads
Suppose we need to find out the name of all the months in a given year (Year will be given...
2014-04-08
493 reads
Holi is the time to unwind de-stress and bond with sweets,Thandai and colours.Come let’s rejuvenate by immersing ourselves in the...
2014-03-16
388 reads
Question :- In which database temporary tables are created in SQL Server?
1) User database (where temporary table are defined)
2) Master...
2014-01-11
1,670 reads
Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record...
2014-01-11
777 reads
Question :-
Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined...
2014-01-10
1,293 reads
Question:-
Which table is called Heap table in SQL Server.
1) Table without any indexes
2) Table without any clustered index (Correct...
2014-01-06
615 reads
Question :-
Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined...
2014-01-02
533 reads
Question :-
How many non clustered indexes are possible in a table in SQL Server 2008R2
1) 1
2) 249
3) 999 (Correct answer)
4)...
2014-01-01
1,084 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers