Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

SQL Server Show Exact Match Values Top (First) then Partial Match Values (Like) Example

Nov 25, 2015 4 comments
Introduction:

Here I will explain how to use
sql server to show exact match values at the top and then partial match values with example or sql server show exact match values at first and then show partial match / like values next with example. By using Order By property we can show exact match values first and then remaining values in sql server.
Description:

SQL Server Charindex Function Example in 2008

Nov 20, 2015 1 comments
Introduction

Here I will explain what is charindex function in SQL Server and uses of charindex function in SQL Server. Generally charindex function in SQL Server is used to search for specific word or substring in overall string and returns starting position of match. Generally we will use charindex in SQL Server to check if string contains specific word or not.

Description:
  
In previous articles I explained SQL Query to get particular part of string, SQL Query to replace part of string, kill all active database connections in SQL Server, SQL Query to read xml file, SQL Query to get month wise, year wise data and many articles relating to SQL Server,
jQuery, JavaScript. Now I will explain charindex function in SQL Server with example

SQL Server Get String Before and After Character (Delimiter) Example

1 comments
Introduction:

Here I will explain how to get string before and after character in
sql server with example or sql server get string before or after character / delimiter example. By using CHARINDEX and SUBSTRING properties we can get string before or after character in sql server.
Description:

Split String with Comma Separated Delimiter and Convert to Table Rows in SQL Server

Nov 18, 2015 1 comments
Introduction

Here I will explain how to split string with comma delimited character in SQL Server or split string with comma separated delimiter in SQL Server or split string with special character in SQL Server or split and convert comma separated or delimited string to table in SQL Server.

Description:

SQL Server Convert String to Proper Case (Camel Case) or Title Case Function Example

Sep 8, 2015 1 comments
Introduction:

Here I will explain how to convert string to proper case or title case or camel case in
sql server with example. To convert string to proper case or title case in sql server we don’t have any built in function for that we need to create user defined functions to convert string to title case in sql server.
Description:

SQL Server Execute Stored Procedure from Another Stored Procedure with Parameters

Aug 13, 2015 2 comments
Introduction:

Here I will explain how to call or execute one stored procedure from another stored procedure in
sql server or execute stored procedure with parameters from another stored procedure in sql server. To call or execute stored procedure within another stored procedure we need to create stored procedure in sql server and call that procedure like “EXEC SAMPLE1” from another stored procedure.
Description:

SQL Server Arithmetic Overflow Error Converting Numeric (Money) to Data Type Numeric

Aug 4, 2015 0 comments
Introduction:

Here I will explain how to fix / solve problem of “
Arithmetic overflow error converting numeric to data type numeric.” in sql server. Actually this problem occured whenever we are converting decimal or money value to numeric datatype with limited size in sql server. To fix this error we need to increase numeric datatype size limit then automatically this problem fix in sql server.
Description:
In previous articles I explained SQL Server single procedure to insert update delete, SQL Server take database backup, SQL Server restore database from .bak / .mdf file, Primary key constraint in sql server, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain how to fix problem of Arithmetic overflow error converting numeric to data type numeric.” in sql server.

Restore Database in SQL Server from .bak (.mdf) File using Query or Management Studio

Jul 30, 2015 6 comments
Introduction:

Here I will explain how to write restore database in
sql server from .bak or .mdf file using query or restore database backup using sql server management studio. To restore database backup in sql server we need to write query like “RESTORE DATABASE DatabaseName FROM Disk…etc” or directly from management studio we can restore database in sql server.

Description:   
                        
In previous articles I explained take database backup in sql server, SQL injection attacks with example, SQL Server interview question and answers, joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain how to write query to restore database backup files (.bak or .mdf) in sql server management studio 2008.

Asp.net GridView Crud Operations (Insert Select Edit Update Delete) using Single Stored Procedure Example

Jul 20, 2015 6 comments
Introduction

Here I will explain how to implement
gridview crud operations insert, select, edit, update and delete operations with single stored procedure in asp.net using c#, vb.net with example or insert, update, delete operations (crud) in asp.net gridview using single stored procedure in c#, vb.net with example.

Description:
  
In previous articles I explained
gridview examples in asp.net, display images from database using handler in asp.net, Bind Dropdownlist selected value in asp.net gridview, gridview rowdatabound event example in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to implement gridview crud operations (insert, select, edit, update) in asp.net with single stored procedure using c#, vb.net with example.

SQL Server Select Insert Update Delete in Single Stored Procedure (Query) with Example

Jul 19, 2015 5 comments
Introduction:

Here I will explain how to select, insert, update, delete in one stored procedure in
sql server 2008, 2010, 2012 or sql server query to insert, select(retrieve), edit, update, delete operations in single stored procedure with example or sql server insert, update, delete, select using single stored procedure with example.
Description:

SQL Server Difference between @@IDENTITY, SCOPE_IDENTITY () and IDENT_CURRENT

Jul 13, 2015 5 comments
Introduction:

Here I will explain difference between @@identity, scope_identity and ident_current in sql server with example. Generally @@identity, scope_identity and ident_current properties in sql server is used to get identity / id value of last or newly inserted record in table but only difference is scope either local or global and session either current session or other session in sql server.

Description:

Get Last (Newly) Inserted Record Id from SQL Server Table in Asp.net

Jun 24, 2015 0 comments
Introduction

Here I will explain how to get newly or last inserted record id from sql server database (table) in
asp.net using ado.net with c#, vb.net. By @@IDENTITY or SCOPE_IDENTITY() or IDENT_CURRENT we can get last or latest inserted record id from sql server table in asp.net using c#, vb.net.

Description:
  
In previous articles I explained SQL Server Query to get last inserted record id,
display gridview row details in popup window on hyperlink click in asp.net, jQuery show gridview row details in modal popup in asp.net, ajax modalpopupextender to edit gridview row details, gridview examples in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to get last or latest inserted record id from database using ado.net with example in asp.net using c#, vb.net.

SQL Server Difference between DML, DDL, DCL and TCL Commands

Jun 6, 2015 1 comments
Introduction:

Here I will explain what is the difference between DDL, DML, DCL and TCL commands or statements in
sql server with examples. In sql server database operations like insert, update, delete, etc… categorized into multiple operations those are DDL, DML, DCL and TCL. In sql server DDL means data definition language, DML means data manipulation language, DCL means data control language and TCL means transactional control language.
Description:

Other Related Posts

© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.