Tags » SQL Server

RECORD Data type does not support in Microsoft SQL Server : How to manage it by comparing with ORACLE?

INTRODUCTION :

Microsoft SQL Server doesn’t support records as type but it support in ORACLE. RECORD type is like same as STRUCTURE used in C. Now I am going to explain here by an example that how to replace record type in Sql Server query. 337 more words

Sql Server

SQL Server Upgrade Preconference at PASS Summit 2014

Please join me and my associates for an all-day SQL Server Upgrade workshop on November 3rd

If you are planning an upgrade to a newer version of SQL Server, you won’t want to miss this all-day, preconference workshop. 259 more words

SQL Syndication

SQL Server, Merge two records in one record

We have these tables

CREATE TABLE tbl01
(
     int NOT NULL PRIMARY KEY,
     nvarchar(50) NOT NULL
)

CREATE TABLE tbl02
(
     int NOT NULL PRIMARY KEY ,
     int NOT NULL REFERENCES tbl01(id),
     nvarchar(50) NULL,
     int NULL
)
… 137 more words
Stackoverflow

Apply in SQL Server

The apply keyword was introduced mainly for the use of selecting data by combining a select query with a table valued function, which is nothing but select query on another table (or result of any business logic in the function). 467 more words

SQL Server

.NET software developer interview questions and answers

I want to share today some questions for an interview as a .Net software developer according to my experience. If you know more, write me and I will add. 2,130 more words

.NET

Corruption for the Accidental DBA'S

I apologize to all the readers for the lay-off that I had been in which resulted in me discontinuing my blog posts. I hope that with this post I can catch up to my intended speed of blogging useful information for all my colleagues and enthusiasts in the database domain. 1,059 more words

Database