|
|
-
|
|
Any database should follow a certain set of properties, collectively called ACID properties - Atomicity, Consistency, Isolation and Durability. Answer this simple question regarding ACID properties and SQL Server databases to win up to two (2) Pluralsight training codes!...
|
|
-
|
|
Recently a friend asked me steps/instructions to scripting schema and data of tables from a SQL Server database. I thought of writing a post and sharing the link rather than writing the process in an email, because I think this may benefit more people. ...
|
|
-
|
|
<p align="justify"><font color="#000000" size="2">Over the short span of my career, I have seen many people get burnt out and change their careers from technology to some other field. It is easy to get disillusioned with a job that requires you to sit on a chair the entire day and "code" t......
|
|
-
|
|
As a part database developer myself, I am sure that what I am about to document today will be useful to almost everyone who has ever written a stored procedure for with indexed tables for SSRS reporting or massive batch processing. What I will be trying today is to find an answer to the dilemma – Sh......
|
|
-
|
|
Whenever we talk about inclusive date comparison & filtering in T-SQL, the only two options that come to mind are the BETWEEN clause and the greater than (>) and less than (<) operators paired with the equal to operator. Today, let us attempt to find out if there is a difference between the two.......
|
|
-
|
|
This is part of the series of posts that I am running under the title "Under Appreciated Features of SQL Server". The series has been inspired by Andy Warren's editorial on SQLServerCentral.com. After Activity Monitor, this is one of the other features that I was surprised to see in the l......
|
|
-
|
|
Out of these four queries, only one query will throw an error. Without running these queries find out the query and error message that it would generate.
Queries
Query 1 : select top 1 1 from sysobjects,syscolumns where 1=1
Query 2 : select top 1 1 from syscolumns,syscolumns where 1=1
Query 3 : ......
|
|
-
|
|
Without running this query, can you guess what would be the answer?
Query
select 3+-+-+-++4
Choose the correct Answer
Answer 1 An error which says incorrect syntax near -
Answer 2 7
Answer 3 -1
Answer 4 None of the above
......
|
|
-
|
|
BULK INSERT is used to insert data to a table from a text file. Only problem with it is that it is not possible to specify the columns that you want data to be imported. For example the table has 4 columns whereas there are data for 2 columns in the text file. Consider the following dataSource data ......
|
|
-
|
|
Let Us Learn Oracle - Part 1 of N [ String Concatenation in Oracle ]
Source table: tblPlayers
In Oracle concatenation can be done in the following ways
Option 1: Using Concatenation Operator ( || )
SQL> Select PlayerFirstName || ' ' || PlayerLastName FullName From tblPlayers;
FULLN......
|
|