Drop all Tables, Stored Procedures, Views And Triggers with one SQL query in SQL Server.
15-Dec-2016 Kamal Pratap
0 Comments 413 Views
Here we explain how to drop all Tables, Stored Procedures, Views And Triggers in one SQL statement. Suppose we have lot of tables, procedure, views & triggers we need to remove them from the database will be a difficult task.
Continue Reading...

Hiding label message after a time interval in Asp.Net from code behind through JavaScript
12-Sep-2016 vikram singh
0 Comments 323 Views
Here we explain how to hide label messages after your defined time interval in Asp.Net using JavaScript.
Continue Reading...

How to Find a Stored Procedure Containing Text or String
09-Sep-2016 Kamal Pratap
0 Comments 376 Views
Many times raise some question when we work on SQL Server.
Continue Reading...

SQL Server UDF Function Convert String to Proper Case / Title Case Example
04-Sep-2016 Kamal Pratap
0 Comments 319 Views
In most cases when we require to display the text in Proper Case or Title Case using SQL Server. To handle this situation we explain the user defined function for convert the string in Title Case or Proper Case.
Continue Reading...

How to implement SQL Server Functions that helps to convert date values to other date formats.
03-Sep-2016 Kamal Pratap
0 Comments 292 Views
Here we explain how to get the desire date format in SQL server using SQL Functions. We pass the date and date format like (dd-Mon-yyyy) as input parameter and it will return the formatted date like (01-Sep-2016) as output.
Continue Reading...

How to format datetime & date in Sql Server
03-Sep-2016 Kamal Pratap
0 Comments 299 Views
Execute the following Microsoft SQL Server T-SQL datetime and date formatting scripts in Management Studio Query then you will get the following results.
Continue Reading...

How to count the number of days, months, years between two dates
02-Sep-2016 Kamal Pratap
0 Comments 263 Views
Here we explain how to get days, months, year between two given date in a single select statement
Continue Reading...

Implement Custom Paging in Repeater control in ASP.Net
18-Aug-2016 vikram singh
0 Comments 347 Views
In this article i explain how to use / populate paging (Pagination) in repeater. By default repeater control does not have pagination so we need to write custom code for populate the paging.
Continue Reading...

ASP.Net DataList Custom Paging Like First, Previous, Numeric, Next And Last
18-Aug-2016 vikram singh
1 Comments 362 Views
In this article i explain how to populate paging (Pagination) in DataList control. By default DataList control does not have the paging option hence we create a custom paging. Here we give the example the custom paging like First, Previous, Numeric,
Continue Reading...

ASP.Net GridView Custom Paging Like First, Previous, Numeric, Next And Last
17-Aug-2016 vikram singh
1 Comments 581 Views
When there are bulk records to show in the GridView, developers often use paging to divide the complete records into multiple pages to show the records in the GridView.
Continue Reading...

1 2 3 4 Next Last