Adding Column Defaulting to Current Datetime in Table
Let us see our solution. Let us first create a table which does not have column with current datetime. In our case we will assume that there are only two rows in the table. USE tempdb GO -- Create Table CREATE TABLE TestTable (ID INT, Col1 VARCHAR(100));…
A New Approach to Scale .NET Applications
A typical scale-out architecture might look like this: Each process in the NuoDB architecture represents a virtual or physical cloud resource but the database as a whole continues to represent itself as a single logical database to any client that’s…
SQL SERVER – Solution to Puzzle – REPLICATE over 8000 Characters
Just quick to summarize the puzzle. Here is the quick recap of the same. Now let us run following script. DECLARE @FirstString VARCHAR(MAX) DECLARE @SecondString VARCHAR(MAX) DECLARE @ThirdString VARCHAR(MAX) SET @FirstString = REPLICATE('A',4000) SELECT…