Category Archives: SQL Server
Let’s face it, most of us typically work with Stored Procedures with modest complexity using JOINS and such. Some of us embed Common Table Expressions (CTE) in the stored procs. If you are already using Entity Framework 2.2, you would … Continue reading
You have heard the famous cliché, “there are many ways to skin a cat”. That said, there are many ways to import a flat file into SQL Server. Some of them include the following: SSMS – Select Database -> Right … Continue reading
Let’s say, you have multiple stored procedures each of which is tied to a partial view or View Component in MVC. Now, while this may seem like a logical thing to do, but what if you want the entire payload … Continue reading
Let’s write a Table-valued function below. This can be created by navigating to Functions – Table-Valued Functions inside SQL Management Studio. Just an FYI, I am using the AdventureWorks database, but this sample can be used in any situation. CREATE … Continue reading
This post was replaced by an erroneous content by an intruder…I will have re-write it. The inconvenience is regretted my dear lovely readers!
To order essay on an author of the essay not only that but safely. Our exchange provides a number of obligations, which guarantee customers that they will receive a high quality and decent work: each essay is checked by the … Continue reading
As the name suggests, nested transaction is one that is nested within a transaction. Let’s illustrate this with an example. Let’s create a table: CREATE TABLE PERSON ( ID INT IDENTITY(1,1), FirstName VARCHAR(25), LastName VARCHAR(25), Gender CHAR(1) ) SELECT * … Continue reading