31796 0
SQL server connection string examples in C# & XML
In this article, I have provided various examples of SQL server connection string in C#, ASP.NET Web.Config file in XML format and MySQL connection string in C#.
Type
Article
27944 2
How to open sql server configuration manager in windows 10?

I am using SQL server Express 2012 in my new windows 10 laptop, now I need to open SQL server configuration manager in windows 10? Where can I find it in Windows 10, in Windows 7, it was easier to navigate and check it in All Programs -> SQL server 2012 -> SQL server configuration manager, but in Windows 10 I cannot find it.

Where can I find it in windows 10? I tried to check in All programs but wasn't able to find it.

Thanks

...
Type
Question
23498 0
How to check sql server version? (Various ways explained)
In this article, I am going to provide you various possible ways to check SQL server version, by following these simple steps.
Type
Article
20749 2
Import csv into SQL server (with query OR without query using SSMS)
In this article, I have explained how you can import data from csv file into sql server using query and without query import csv into database using SQL server management studio.
Type
Article
20707 0
Stored procedure in sql server (With Example)
In this article, I have explained basics and important points to understand stored procedure in sql server with examples.
Type
Article

19644 0
Understanding SQL server switch case (With Example)
This article provides you implementation details of SQL server switch case statement and how to use it with examples
Type
Article
18169 3
How to use switch case statement in stored procedure?

As easily we use the if else statement in stored procedure to check the statement type and there after we perform the desired task. Same thing I want to do using switch case 

...
Type
Question
18145 1
Check database size in Sql server ( Various Ways explained)
In this article, I have explained, how you can check database size in SQL server using various possible ways, easily.
Type
Article
17927 0
Aggregate Functions in SQL Server (SUM, AVG, COUNT, MIN, MAX)
This article provides you complete details of the aggregate function (SUM, AVG, COUNT, MIN, MAX) in SQL server with suitable examples.
Type
Article
17911 1
How to reset the column value using sql and knockout js in MVC?

If, we assign the rank to the column
Ex:
Name.   .   .    .   .      . Rank
A.                        .   .   .  1
B                                     2
C                            .   .   . 3

When the user adds the data, the rank is saved in DB(database).

How to update the rank in DB, when user delete the data using knockout?

On click of delete, there is one function called
Remove row
And in that function table row<tr> is removed using knockout.

Example: if we delete row B its order will be, -1 as deleted item will have rank/order -1 and order/rank of c will be 2

Is, there any alternative way to reset the column value in SQL or something else? 

Please, suggest me

Thank you

...
Type
Question

Page 1 of 11