Tags » SQL

SQL interview questions part 1

What is SQL function?

SQL Server user-defined functions are routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value. 433 more words

Những mẹo hay trên SQL

Xin chào mọi người :3 Mình đã trở lại sau thời gian dài nghỉ ngơi dưỡng sức :v Đúc rút kinh nghiệm bị mọi người xỉa xói lắm về vấn đề mở bài thì dài mà nội dung chẳng liên quan nên mình xin mạn phép ko nói nhiều nữa. 855 more words


What is the serialization and what is use of serialization in real time?.

Let me give you one practical example. In one of my application, I was given XML schemas (XSD files) for request and response XML files. I need to parse the request XML file, process and save the information back into several tables. 1,143 more words

TRIM: More than meets the eye

I’ve always just used the TRIM-function to remove leading and trailing spaces. While going through Markus Winands presentation “Four* Major Database Release of 2017 in Review” on SlideShare.net… 385 more words


Get the size of all the tables in a SQL database

t.NAME AS TableName,
s.Name AS SchemaName,
p.rows AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB, 129 more words


What is SQL injection?

If you have the slightest interest in computers and technology then chances are that you have heard the term SQL Injection. We all know that SQL stands for Structured Query Language and that it is used to communicate with databases. 178 more words


Custom Color for Production Connection

Have elevated permissions in production and want a visual aid to help quickly identify your production environments? 73 more words