Click here to Skip to main content

Submit your article

SQL Server 2012

SQL-Server-2012

Great Reads

Executing Stored Procedure with User Defined Table Type Parameter in Entity Framework Using EntityFrameworkExtras

by AshishShukla6

This tip describes step by step implementation of executing stored procedure having user-defined table type as a parameter in entity framework using EntityFrameworkExtras package.

Reset SQL Server SA (System Admin) Password

by Sarathi Balakrishnan

Reset SQL server SA (System Admin) Password when you have lost all possible ways to connect to SQL server and your server has only Windows authentication disabled. You should have Windows administrator permission to do this.

FOR XML Basics (AUTO Mode): 2 of 4

by AhsanAhmed

A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format

SQL Server: Doing String Split And Join

by DiponRoy

How to do string split and join in SQL Server

Latest Articles

SQL Server: Find Table Order/Generation And Relation Details

by DiponRoy

A utility query to find table generations in SQL Server relational database

SQL Server: Doing String Split And Join

by DiponRoy

How to do string split and join in SQL Server

Streamline Log Shipping Failovers

by Micah Nikkel

SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.

Select Statement to HTML Table

by Luca Astolfi

User defined procedure for make an HTML table from T-SQL Select statment

All Articles

SQL Server 2012

Executing Stored Procedure with User Defined Table Type Parameter in Entity Framework Using EntityFrameworkExtras

26 Sep 2015 by AshishShukla6

This tip describes step by step implementation of executing stored procedure having user-defined table type as a parameter in entity framework using EntityFrameworkExtras package.

SQL-Server-2012

SQL-Server-2014

Reset SQL Server SA (System Admin) Password

21 Sep 2015 by Sarathi Balakrishnan

Reset SQL server SA (System Admin) Password when you have lost all possible ways to connect to SQL server and your server has only Windows authentication disabled. You should have Windows administrator permission to do this.

SQL-Server-2012

FOR XML Basics (AUTO Mode): 2 of 4

2 Jun 2017 by AhsanAhmed

A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL-Server-2008

SQL Server: Doing String Split And Join

19 Feb 2019 by DiponRoy

How to do string split and join in SQL Server

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Streamline Log Shipping Failovers

29 Aug 2018 by Micah Nikkel

SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

Pivot Operator in SQL Server Simplified

7 Feb 2015 by Gaurav_Chaudhary

This tip is a brief introduction to Pivot operator in SQL Server

SQL-Server-2012

Money Precision Issues

15 Feb 2015 by Bohdan Stupak

This tip shows some primary issue which puts a serious limitation on SQL Server MONEY data type.

SQL-Server-2012

SQL-Server-2008R2

why this query gives me an error

21 Jun 2015 by Kornfeld Eliyahu Peter

Say it aloud for yourself in English...'Please select me the date from the table BreakFast where EPF_Number'...Where EPF_Number, what?Where clause is incomplete as there is no actual condition in it...In any other aspect too you query is wrong - check CONVERT function[^] of SQL to see...

SQL-Server-2012

SSIS Import Text File Using Validation

6 Sep 2015 by Math08avan

Import text file data to SQL database using foreign key relation and validation.

SQL-Server-2012

How to Split Microsoft SQL Server Table Row Data

18 Dec 2015 by Md. Marufuzzaman

This tip shows you an easy way to split Microsoft SQL Server table row data.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Generate insert Statements from a Specific Table Data using SQL Server

27 May 2013 by Tharaka MTR

Generate insert statements from a specific table data using SQL Server

SQL-Server-2008

SQL-Server-2005

Using Stored Procedures in Entity Framework Model First Approach (Part I - Adding New Stored Procedure)

15 Apr 2014 by SRS(The Coder)

How to use Stored Procedures in Entity Framework Model First Approach

SQL-Server-2008R2

SQL-Server-2012

How to Sort numeric values mixed with alphanumeric values in sql

10 Jun 2014 by Peter Leow

Refer: Sort AlphaNumeric Data in Sql[^]

SQL-Server-2012

No More Stray User Tables in Master

19 Jul 2014 by Tim Golisch

The Master database often seems to be the "Lost & Found" bin of the SQL Server world. There are two popular ways for preventing this kind of problem. Read on...

SQL-Server-2012

SQL-Server-2008R2

Creating a SSRS Report With Microsoft Dynamics CRM On-line

12 Jun 2015 by coded007

Designing reports with Dynamics CRM

SQL-Server-2012

SQL-Server-2008R2

How can I load 50000 records in gridview without paging?

20 Jul 2015 by F-ES Sitecore

If the user spends 2 seconds per row it would take them 27 hours to look at your gridview. Returning that amount of data is a very bad idea for many, many reasons, some of which you are finding out now. Use paging or implement some sort of filtering\search. Why present data that is useless?

SQL-Server-2012

Unexpected rounding-off from DATETIME2 to DATETIME

23 Jul 2015 by Wendelius

Datetime2 is more accurate than datetime which has only accuracy for milliseconds.From datetime2 (Transact-SQL)[^]: When the fractional precision of the datetime2(n) value is greater than three digits, the value will be truncated.The following example shows the results of converting a...

SQL-Server-2012

SQL-Server-2008R2

Not able to insert. Doesn't show any errors but doesn't insert as well

24 Aug 2015 by Wendelius

I would say that the statement causes an error since you're missing an ending parenthesis for the values.Try usingSqlCommand cmd = new SqlCommand("Insert into...

SQL-Server-2012

which database is better for MVC

7 Sep 2015 by Sergey Alexandrovich Kryukov

Strictly speaking, the choice of the database engine has nothing to do with MVC or any other framework on top of ASP.NET. It's enough that it worked well with ADO.NET. This choice should take into account the requirements of your application, which you did not share with us. But please don't do...

SQL-Server-2012

what is call by value and call by ref?

6 Oct 2015 by CPallini

Try this:using System;public class Program{ static void by_value(int x) { x = 42; } static void by_reference(ref int x) { x = 42; } public static void Main() { int i = 0; by_value(i); Console.WriteLine("after by_value, i = {0}", i); ...

SQL-Server-2012

How to update data in table?

25 Apr 2016 by Suvendu Shekhar Giri

You can use UPDATE with JOIN to do this.Check something like following-UPDATE S SET S.salary=S.salary+(S.salary*(CASE WHEN R.[role]='a' THEN 0.2 WHEN R.[role]='c' THEN 0.3 ELSE 0 END))FROM sal SINNER JOIN map M ON S.empid=M.empidINNER JOIN rolemaster R ON R.roleid=M.roleidI...

SQL-Server-2008R2

SQL-Server-2012

How to join two tables to get this output

27 Jun 2016 by Maciej Los

In addition to solution1 by OriginalGriff[^], i'd strongly recommend to read this article: Visual Representation of SQL Joins[^]

SQL-Server-2012

SQL-Server-2008

FOR XML Basics (EXPLICIT Mode): 3 of 4

1 Jun 2017 by AhsanAhmed

A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL-Server-2008

Saving and reporting datetime & timezone info in database when data is dependant on datetime

21 Aug 2019 by Maciej Los

Initial note: i think the answer to your question is opinion and experience based only. Quote: - What is the preferred way of handling this kind of situation? Well, there are possible two ways to store dates in a database: 1) UTC time or 2) DateTime + Offset The second method is recommended...

SQL-Server-2012

Not valid column name

8 Jan 2020 by Wendelius

Since you're using an aggregate you need to give an alias to the column if you want to reference it by name. For example Statement s = con.createStatement(); ResultSet rs = s.executeQuery("select Max(CarNumber) AS MaxCarNo from CarRegistration"); rs.next(); rs.getString("MaxCarNo"); if...

SQL-Server-2012

SQL Server: Changed data capture without using Triggers

23 Oct 2012 by aasim abdullah

How to use DELETED and INSERTED virtual tables to capture data change in result of any INSERT, UPDATE or DELETE statement.

SQL-Server-2008

SQL-Server-2012

SQL-Server-2005

SQL Server : How to Keep Database Restore History

24 Oct 2012 by aasim abdullah

Backup and then restore of a database is a normal job for developers and DBAs. This script will be helpfull to findout, from which path, and which backup file a database was restored.

SQL-Server-2008

SQL-Server-2012

SQL-Server-2005

Counting Consecutive Dates Using SQL

17 Feb 2013 by Tharaka MTR

How to count consecutive dates using SQL

SQL-Server-2008

SQL-Server-2012

SQL-Server-2005

SQL server, what is the performance and difference from these selects?

22 Oct 2013 by Mike Meinz

I tested both queries in SQL Server Management Studio. I turned on "Include Actual Execution Plan".The first query required one join and two index seeks/scans.The second query required three joins and four index seeks/scans.

SQL-Server-2012

I want to update a column only the date without the time change

4 Apr 2014 by Schatak

Try this:UPDATE YourtableSET datetimecol = DATEADD(day, DATEDIFF(day, datetimecol, getdate()), datetimecol)

SQL-Server-2012

Storing Password in the Sql server database in a secure way.

21 Apr 2014 by Zoltán Zörgő

"Forgor password" functionality does not mean sending old plain text password to the user. Not at all. Actually this is the most vulnerable point in an application, since you have no control over what's happening. Generating one-time-password and sending that one to the user and forcing the user...

SQL-Server-2012

How can I create relationship others table with registration table?

4 May 2014 by Maciej Los

Notes provided by Sander Rossel are very useful. It could be shortly described: start with basics!WOW, 11 tables!Another note is: I'd suggest to decrease the number of tables at least to 3 :)RegistrationItemTypeItemsCollectionRegistrationCreate Table...

SQL-Server-2012

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

10 May 2014 by sankarsan parida

You can do it in your storeprocedurechange on this lineSet @SubscripID = (Select TOP 1 SubscriptionId from TblSubscription where UserId = @Userid and IsActive = 1)Use more conditions in where clause to return single and right value in a subquery.

SQL-Server-2012

Save your Data from LDAP Injection Attack

9 Jul 2014 by Jason Parms

Lightweight Directory Access Protocol (LDAP) Injection

SQL-Server-2008R2

Primary key column is incremented by wrong increment value

13 Aug 2014 by Amol_B

Hello ,I am facing a weird issue with tables in my database.Tables in my application are created with a primary key defined (with Clustered index).Identity seed is a one for all tables in my database (IDENTITY(1,1)).CRUD operations are done on these databases using stored procedure...

SQL-Server-2012

Primary key column is incremented by wrong increment value

13 Aug 2014 by Gupta Poonam

You might find your answer here..[^]

SQL-Server-2012

SQL function to get a value of (row)x(col) of a specified table

14 Sep 2014 by George Jonsson

As you don't specify any columns only a generic SELECT statement can be given for the value caseSELECT specific_column_nameFROM table_nameWHERE another_column_name operator value;For this to work, the values in the another_column_name must be unique.Another option is to use a...

SQL-Server-2012

Concatenation of two char variable in sql

1 Dec 2014 by Maciej Los

There is a bit difference between char and varchar[^] data types:char [ ( n ) ] Fixed-length, non-Unicode character data with a length of n bytes. n must be a value from 1 through 8,000. The storage size is n bytes. The SQL-2003 synonym for char is character.varchar [ ( n | max ) ] ...

SQL-Server-2008R2

SQL-Server-2012

SQL-server-2000

Synchronization between local and Azure SQL DB using SLQ Management Studio "Export Data..."

17 Mar 2015 by Sergey Kizyan

This article explains how to merge your local SQL DB content to Azure DB from scratch

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Refering dlls in SSIS Script Task

10 Apr 2015 by Rajeesh Madambat

Refer and write your own business logic in C# and add it to SSIS script task.

SQL-Server-2008

SQL-Server-2012

How ISDATE() function work in SQL SERVER

2 Jul 2015 by John C Rayan

Your result works as expected. 03/2010/15 is in MYD format so it returns 1. If you set to DMY format you might return 0.Check the documentation here https://msdn.microsoft.com/en-us/library/ms187347.aspx

SQL-Server-2012

How can I load 50000 records in gridview without paging?

20 Jul 2015 by Afzaal Ahmad Zeeshan

You are mixing a combination of Bad UX and Bad UI in your web application. First of all, you are well aware that web applications need network traffic so sending this much huge data (even if this takes 5 MB of network size) would never be a good idea. Pagination is used to minimize the network...

SQL-Server-2012

INNER JOIN two views from SQL SERVER

28 Jul 2015 by Suvendu Shekhar Giri

I don't see any problem doing that.Something like following should work.Your first viewCREATE VIEW [TestView1]ASSELECT 1 AS Id, 'Test 1' AS ValueUNIONSELECT 2,'Test 2'GOOUTPUT 1Id Value______________1 Test 12 Test 2Your second viewCREATE VIEW...

SQL-Server-2012

Technical pan in query of sql server

29 Jul 2015 by Kornfeld Eliyahu Peter

To open up you WHERE clause...STATION_ID = 'AIN SEBOU' AND SENSORNAME = 'NIVEAU')OR(STATION_ID = 'AIN SEBOU' AND SENSORNAME = 'PLUIE1HR')OR(STATION_ID = 'AZZABA' AND SENSORNAME = 'NIVEAU')OR(STATION_ID = 'AZZABA' AND SENSORNAME = 'PLUIE1HR')Where the last line actually not as you...

SQL-Server-2012

How to update number series with other number series in SQL

13 Sep 2015 by OriginalGriff

Um...UPDATE MyTable SET [No] = [No] + 9

SQL-Server-2012

SQL Databse not connecting on iis 7.5

28 Oct 2015 by Zoltán Zörgő

Wait a second.1) IIS does not connect to any RDBMS, except for storing session state - it is only a setting you can use in your application2) SQL Express does not enable TCP/IP connector by default, you need to enable it[^].3) For this to work, you need to have specific port level...

SQL-Server-2012

connectionstring

How to compare between two dates in VB.NET ?

16 Mar 2016 by OriginalGriff

Assuming you have the dates in VB, they should be in DateTime values.So...Dim diff As Timespan = realDeliveryDate - confirmedDeliveryDateIf you don;t have them as DateTime values, then convert them to DateTime using DateTime.TryParseIf they are in SQL, then again, they should be DATE or...

SQL-Server-2012

Sql query to fetch the details of customers across specific days of weeks

21 Aug 2016 by OriginalGriff

Try:SELECT * FROM MYTable aJOIN (SELECT CustName FROM MYTable GROUP BY CUSTName, DATEPART(ISO_WEEK,PurchaseDate) HAVING COUNT(PurchaseDate) >= 5) bON a.CustName = b.CustName

SQL-Server-2012

Sql server 2012 sa account locked out

21 May 2019 by phil.o

Connect to SQL Server When System Administrators Are Locked Out[^] may help.

SQL-Server-2012

Default Null Parameter

17 Sep 2012 by Stephen Hewison

There was something wrong with the report definition. It wasn't updating the parameter definitions to use the default values.After deleting the report from the server and republishing it, the default values were applied.

SQL-Server-2012

Connection to database in C#

5 Nov 2012 by fjdiewornncalwe

www.connectionstrings.com[^] is a great site that can help you build your connection strings. Just go there and navigate to the MySQL page and pick the type of connection string you need from there.Cheers.

SQL-Server-2012

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

9 Jan 2013 by aasim abdullah

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

SQL-Server-2008

SQL-Server-2012

Error converting data type nvarchar to date

3 Feb 2013 by skydger

Try to use SqlDateTime type. System.Data.SqlTypes.SqlDateTime m_dtm = System.Data.SqlTypes.SqlDateTime.Parse(txtMelliCodeReport.Text); adp.SelectCommand.Parameters.AddWithValue("@clrk_MelliCode", m_dtm); System.Data.SqlTypes.SqlDateTime az_dtm =...

SQL-Server-2012

How to insert data from Table 1 to Table 2.

4 Apr 2014 by Peter Leow

Refer: sql_insert_into_select[^]

SQL-Server-2012

how to import images from database in rdlc report

4 Apr 2014 by Schatak

Are you storing images in database or just paths to images?First , you need to take care few things if you are fetching your images from database then you need to set image source property to "Database" but if image is not saved in the database, but only the path to it then changed it to...

SQL-Server-2012

how to create foreign key in sql

4 Apr 2014 by Schatak

create table employee( employeeId int not null, employeeUsername varchar(50) not null, employeePassword varchar(50) not null, employeeName varchar(50) not null, employeeContact int not null, employeeEmail varchar(30) not null, Constraint PK_Employee PRIMARY...

SQL-Server-2012

how to create foreign key in sql

4 Apr 2014 by Guruprasad.K.Basavaraju

create table employee( employeeId int not null, employeeUsername varchar(50) not null, employeePassword varchar(50) not null, employeeName varchar(50) not null, employeeContact int not null, employeeEmail varchar(30) not null, primary key(employeeId));...

SQL-Server-2012

problem in function not able to rectify

8 Apr 2014 by Schatak

You are making mistake.correct itSELECT @COUNT=COUNT(*) FROM emp_table

SQL-Server-2012

How to SQL Format seconds as HH:MM:SS time

8 Apr 2014 by ArunRajendra

Try this method.select convert(varchar(100),GETDATE(),108)

SQL-Server-2012

explain table variable in briefly with examples

8 Apr 2014 by Schatak

SELECT distinct Profile,stuff((select distinct ', ' + Specialization FROM TM_Specialization tms INNER JOIN TM_Profile tmpON tms.ProfileID=tmp.ProfileID where tms.ProfileID =tm_p.ProfileIDFOR XML PATH('')) ,1,1,'') as SpecializationFROM TM_Profile TM_P INNER JOIN TM_Specialization...

SQL-Server-2012

When I Run The Store Procedure Shows Error As Follows

15 Apr 2014 by CHill60

sanket saxena is correct.Specifically look at these linesdeclare short cursor for select Message,Mobileno,MSgdelivered,Replymsg from Shortcode_Course_SMS where Msgdelivered > @Fromdate and Msgdelivered

SQL-Server-2012

stored procedure error

23 Apr 2014 by OriginalGriff

Um...You declare four parameters, but you only provide three in your call - and in the SP you try to declare a variable with the same name as one of the parameters: @artistIdI suspect that you didn't mean to include @artistId in the parameters list.

SQL-Server-2012

Hash Passwords in SQL Server vs. Hash and salt in .net

24 Apr 2014 by thatraja

Check theseBeginners guide to a secure way of storing passwords[^]&Password Security[^]The Art & Science of Storing Passwords[^]

SQL-Server-2012

People Pay There Bill On Time ,Not All People Pay There Bill On Time,People Who Pay There Bill I Have There Record But How I Wil Get The Record Of People Who Didn't Pay There Bil For Current...

30 Apr 2014 by CHill60

The following will answer your question as you have asked it...Declare @LatePayCharge intset @LatePayCharge= 60insert into tblbill (SocietyID,MemberID,BillDate,AmountRemaining,LatePayPenalty) select I.SocietyID,I.MemberID,CAST(GETDATE() AS DATE),I.TotalCharges,@LatePayCharge from...

SQL-Server-2008R2

SQL-Server-2012

Multiple User Sql Update at same time

6 May 2014 by thatraja

Check this article6 ways of doing locking in .NET (Pessimistic and optimistic)[^]

SQL-Server-2012

Is there any way to Optimize this Store Procedure or Queries inside Sp

10 May 2014 by Manas Bhardwaj

You could start something like this:Btw, the core of writing a program is logical structure than the actual syntax.CREATE PROC uspSetSubscriptionPayment @PayMethod varchar(50), @PackageType varchar(25), @Userid int, @ConstID int, @SubscriptionIdentity int...

SQL-Server-2012

stored-procedure

Error In sql Server " Conversion failed when converting the varchar value '%' to data type int."

11 May 2014 by DamithSL

you need to use cast as below (@StreetNo IS NULL OR @StreetNo = 0 OR StreetNo LIKE cast(@StreetNo as varchar(10)) + '%')check this SQL Fiddle[^]

SQL-Server-2012

User Logon for Windows Applications Best Practices

20 May 2014 by Aaron Hartley

I have a C# windows application written in VS 2010 that uses SQL Server Express database as the back-end. I'm finding that I have a need for having different users with different rights, to limit how much damage can be done by careless users. For example, one highly trusted user can mass delete...

SQL-Server-2012

Sql server Query : Conditional Select columns with TOP keyword

21 May 2014 by nilschaudhari

Hello,Create Stored Procedure for the same. Use the If Condition in the procedure as followsCreate procedure procedurename(parameters)DECLARE @mode INT;SET @mode = 0;IF @mode = 0 then SELECT t.Column1,Count(t.Column2) as Column2FROM Table1 t--Where some list of...

SQL-Server-2008R2

SQL-Server-2012

What are sources to understand SSIS from basics to advanced?

22 May 2014 by Arjun Holla

http://www.bimonkey.com/about-the-bi-monkey/support/ssis-component-samples-list/[^]

SQL-Server-2008R2

SQL-Server-2005

Read Data from the Next Row

21 Jun 2014 by george bolovan

Read data from the next row

SQL-Server-2012

SQL-Server-2008R2

Primary key column is incremented by wrong increment value

13 Aug 2014 by OriginalGriff

Never seen or heard of that as a problem: and SQL Identity fields are used so often I'm pretty sure it would show up.Are you sure that is exactly what is happening? It would be easy to see that kind of change if rows are deleted for example, since the identity values will not be...

SQL-Server-2012

GROUP BY several elements

16 Aug 2014 by Homero Rivera

FYI - Your tables are not following some basic standards, such as using the same column name for things that are meant to be the same (e.g. RegisteredProducts.PackageType and Packages.PackageType).Be careful with that.also, the result set you want to see looks more like an Excel pivot to...

SQL-Server-2008R2

SQL-Server-2012

How to use copy a table to another database table

8 Sep 2014 by hypermellow

Have a look at MSSQL's procedure sp_executesql.sp_executesql allows you create a dynamic string containing the SQL statement to run, so you should be able to incorporate you dynamic table name into the SQL statement.Hope it helps.

SQL-Server-2012

How Do I Concatenate A Variable After Dot

8 Sep 2014 by Stephen Hewison

You need to use Dynamic SQLThere is an SQL command called sp_ExecuteSQLThis will allow you build a string such as this and execute it:DECLARE @MySQL VARCHAR(MAX)SET @MySQL = 'SELECT * FROM DestinationDatabase.dbo.' + @TableNameEXEC sp_ExecuteSQL @MySQLWARNING!!! WARNING!!!...

SQL-Server-2012

How to copy a database's schema to another one without using 'Generate Scripts' in SQL Server

10 Sep 2014 by Gihan Liyanage

Copy Table Schema and Data From One Database to Another Database in SQL Server[^]

SQL-Server-2012

SQL function to get a value of (row)x(col) of a specified table

14 Sep 2014 by george4986

-----------sample table structureSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[area]( [area_id] [bigint] NOT NULL, [area_code] [varchar](10) NULL, [area_name] [varchar](50) NOT NULL, [latitude] [float] NOT NULL, [longitude]...

SQL-Server-2012

Export Primary, Unique, Foreign Key and Default Constraints in SQL Server

26 Sep 2014 by Anil kumar Bhardwaj

Export all the primary, Unique, Foreign key and default constraints from existing database

SQL-Server-2014

SQL-Server-2012

how to backup database in sqlserver 2012

4 Oct 2014 by Zoltán Zörgő

As I mentioned before, google is your friend. You can start here: http://www.serverintellect.com/support/sqlserver/database-backup-ssmse/[^]

SQL-Server-2012

Get Ready to Learn SQL: 6. How to Group and Summarize your Results

23 Oct 2014 by essentialSQL

How to Group and Summarize your Results in SQL

SQL-Server-2012

Get Ready to Learn SQL: 5. Query Results Using Pattern Matching

23 Oct 2014 by essentialSQL

Query Results Using Pattern Matching in SQL

SQL-Server-2012

Getting Started With SQL Server: 2. Sort Your Query Results

24 Oct 2014 by essentialSQL

How to sort your query results in SQL Server

SQL-Server-2012

When to use Sql Datatype Geometry and Geography ?

21 Nov 2014 by /\jmot

Links..http://techbrij.com/html5-geo-location-sql-server-asp-net[^]http://msdn.microsoft.com/en-us/library/bb895266(v=sql.105).aspx[^]

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

difference between ‘WITH NO CHECK’ and ‘NO CHECK’

10 May 2015 by Osama Abu Sitta

what is difference between ‘WITH NO CHECK’ and ‘NO CHECK’ in SQL Server ??

SQL-Server-2008R2

SQL-Server-2012

difference between ‘WITH NO CHECK’ and ‘NO CHECK’

11 May 2015 by Member 11039257

Using WITH NO CHECK:We have a table with 100 records.1)Now we are creating a foreign Key Constraint by altering that tableALTER TABLE [Sales].[SalesOrderDetailTemp] WITH NOCHECK ADD CONSTRAINT [FK_SalesOrderDetailTemp_SalesOrderHeader_SalesOrderID] FOREIGN...

SQL-Server-2008R2

SQL-Server-2012

how to join 6 tables using sql server 2012 using inner join

21 May 2015 by King Fisher

Hi,I doesn't matter how many tables we are going to join, the thing is you should clear in the concepts of join, if you are well clear then you can do whatever you want.here is the good article about joins,please read...

SQL-Server-2012

How Do I Sql Sum Get To Label C#

15 Jun 2015 by OriginalGriff

Remove the quotes:string query = "SELECT SUM (COUNT) FROM Count_EPF WHERE date = '@C' ";Becomes:string query = "SELECT SUM (COUNT) FROM Count_EPF WHERE date = @C ";Otherwise the parameter name is within an SQL string and is not treated as a parameter at all.[edit]Oh, and don't pass...

SQL-Server-2012

Date between in sql command

28 Jun 2015 by Suvendu Shekhar Giri

Try this-SELECT [Date],Price FROM Dataupload WHERE [Date] BETWEEN DATEADD(DAY,-8,GETDATE()) AND DATEADD(DAY,-1,GETDATE())Hope, it helps :)

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

How to display unique comments based on certain conditions in SQL Server?

1 Jul 2015 by Maciej Los

Have a look at sample:DECLARE @tmp TABLE(CustomerID INT, SequenceNo INT, Comments VARCHAR(MAX))INSERT INTO @tmp (CustomerID, SequenceNo, Comments)VALUES(1, 1, 'ABC D'),(1, 2, 'CDE'),(1, 3, 'ABC'),(1, 4, 'ABC D'),(1, 5, 'CDE'),(1, 6, 'abc'),(2, 7, 'ABC DEF'),(2, 8,...

SQL-Server-2012

Divide by zero error encountered

13 Jul 2015 by OriginalGriff

Use NULLIF[^] - because NULL propagates in SQL, it will cause the whole calculation to return NULL instead of throwing an exception.ROUND(((OverListedPrice/NUFFIF(listedprice,0))-1)*100,3) as overlistedpercentageBecause division by zero is mathematically an error for all practical purposes,...

SQL-Server-2008R2

SQL-Server-2012

How Do I Use Case In Sql Query ?

21 Jul 2015 by Suvendu Shekhar Giri

Although your question is not clear, the error in you query was unwanted "as Support" in between the case when statement.syntactically corrected query is-case when Business_Group like '%Back Office%' then bonus else bonus end as ALCBut this is something you never want as result, what I...

SQL-Server-2012

how to change query from 2012 to 2008 r2

23 Jul 2015 by Suvendu Shekhar Giri

You can rewrite it using CASE WHEN as-SELECT @Principal= CASE WHEN optionfieldvalue='' THEN NULL ELSE CAST(optionfieldvalue as decimal(38,18)) END FROM @DATA WHERE TemplateFieldId = 47Hope, it helps :)

SQL-Server-2012

SQL-Server-2008R2

Unexpected rounding-off from DATETIME2 to DATETIME

23 Jul 2015 by Suvendu Shekhar Giri

Here I got the solution. I have posted the same question in Stackoverflow[^]Quote:The reason is that in datetime type, you only have .000, .003 and .007 fraction of a second.Try this:select cast('2015-01-01 00:00:00.882' as datetime)select cast('2015-01-01 00:00:00.884' as...

SQL-Server-2012

SQL-Server-2008R2

How Can I Lock A Row While Editing?

24 Jul 2015 by barneyman

that's not really how SQL is designed, SQL will only lock the row/page when you start the update transaction - if you want to mark a row 'out of bounds' for editing, you'll have to implement your own lock mechanism ... perhaps a nullable datetime column on each row, which marks that row as being...

SQL-Server-2012

INNER JOIN two views from SQL SERVER

28 Jul 2015 by OriginalGriff

Name the views:SELECT a.Col1, b.Col1, a.Col2, b.Col2, a.Col3 FROM View1 aJOIN View2 bON a.Col1 = b.Col1

SQL-Server-2012

How Can I Show Elements Of Where Clause That Are Not Present In Table

28 Jul 2015 by Wendelius

A simple way would by to use EXCEPT to remove existing values from all values. Consider the following exampleSELECT all_values.IdFROM (SELECT 1234 AS Id UNION ALL SELECT 9999 AS Id UNION ALL SELECT 8888 AS Id ) all_valuesEXCEPTSELECT IdFROM MyTableFor more...

SQL-Server-2012

Inserting Primary Key of Emp table into Dept is a foreign key

6 Aug 2015 by Richard Deeming

As mentioned in the comments, a stored procedure would be a better approach. However, you can still do it with inline SQL:const string query = @"DECLARE @EmpID int;INSERT INTO EMP (empname, empdate) VALUES (@Name, @Date);SET @EmpID = Scope_Identity();INSERT INTO DEP (deptname,...

SQL-Server-2012

SQL - How do I split a string based on a delimiter?

23 Aug 2015 by Duncan Edwards Jones

First creaste a generic "split"[^] function, like so:-CREATE FUNCTION dbo.fnSplit( @sInputList VARCHAR(8000) -- List of delimited items , @sDelimiter VARCHAR(8000) = ',' -- delimiter that separates items) RETURNS @List TABLE (item VARCHAR(8000))BEGINDECLARE @sItem...

SQL-Server-2012

SQL-Server-2008R2

SQL - How do I split a string based on a delimiter?

23 Aug 2015 by Maciej Los

As to OP's comment:Member 11917248 wrote:IS IT NOT POSSIBLE TO SOLVE IN A SIMPLE WAY WITHOUT USING FUNCTIONYes, it is posible to get result using CTE: get 2nd and 3rd string by splitting a long string using T-Sql[^]

SQL-Server-2012

SQL-Server-2008R2

What is the best way to edit .aspx page which is on server.

26 Aug 2015 by Afzaal Ahmad Zeeshan

That is exactly why Content management systems[^] were introduced. You can create a system for your applications so that your clients are provided with features, in a GUI mode. They don't even have to change anything, they can apply templates, change the content, update or even delete the...

SQL-Server-2012