Tips and Tricks

Validating the user
These are the techniques used by developers to solve issues, create special features in applications and to improve performances. These notes are created by software professionals on the job.
Visual Studio Windows/Dos WCF MVC ASP.Net C# Java Script AJAX HTML JQuery AngularJS .NET Core SQL Server
    Visual Studio  (11)
#
Title
Author
Entry Date
1
In Visual studio 2012 is giving a pop up saying that asp.net 4.5 has not been registered on the web server on Web projects.
Shiju Mathews
08/01/2016
2
Why Visual studio 2012 is publishing c# files on web deployment?
Shiju Mathews
03/31/2016
3
How to get list of all search results in Visual Studio?
Shiju Mathews
11/06/2013
4
How to Arrange and Dock Windows in Visual studio?
Shiju Mathews
10/30/2013
5
How can add vertical lines at each indent level in Visual Studio?
Shiju Mathews
10/29/2013
6
Difference between Build Solution and Rebuild Solution in Visual Studio?
Shiju Mathews
09/30/2013
7
How to run Visual Source Safe's Analyze Utility on Command prompt?
Shiju Mathews
01/31/2013
8
Error While trying to run project uncaught exception thrown by method called thru reflection.
Shiju Mathews
10/02/2012
9
ServiceModel Metadata Utility Tool (Svcutil.exe)
Shiju Mathews
08/22/2012
10
How can we deploy thirdparty assemblies included in my project.
Shiju Mathews
03/04/2009
11
How can I clear Recent Projects list in Visual Studio?
Shiju Mathews
02/22/2009
    Windows/Dos  (14)
#
Title
Author
Entry Date
1
How to know the list of the user group that I am In?
Shiju Mathews
04/21/2016
2
Browser is not working eventhough internet connection is fine on Windows 7 PC.
Shiju Mathews
10/31/2015
3
How to Shut Down and Reboot Remote PCs via the Command Prompt?
Shiju Mathews
04/04/2015
4
In windows 2003 server start button is disabled when connecting to the server using RDP.
Shiju Mathews
02/25/2015
5
How to Windows 2003 Server start or stop services
Shiju Mathews
12/01/2014
6
What is the Hosts file?
Shiju Mathews
10/30/2013
7
What is the Location of Internet Explorer 9 Favorites?
Shiju Mathews
02/13/2013
8
Snipping Tool to capture screen shots
Shiju Mathews
08/09/2012
9
Use Snipping Tool to capture capture a snip of a menu
Shiju Mathews
08/09/2012
10
What's the difference between x64 and IA-64?
Shiju Mathews
10/28/2010
11
Requires stdole Version 7.0.33 be installed in GAC ClickOnce deployment
Shiju Mathews
05/14/2009
12
How do you open task manager when ctrl alt del doesn't work?
Shiju Mathews
02/11/2007
13
Free anti-virus and security software from Microsoft
Shiju Mathews
10/09/2012
14
When I migrated to IE 9, my titlebar is missing. How to show Titlebar on my new browser?
Shiju Mathews
05/23/2011
    WCF  (5)
#
Title
Author
Entry Date
1
How to open WCF Test Client?
Shiju Mathews
07/23/2014
2
What is the difference between SOAP and REST?
Shiju Mathews
10/15/2013
3
Error on adding WCF service reference to my web project.
Shiju Mathews
07/05/2013
4
Basics of WCF
Shiju Mathews
07/04/2013
5
What is WCF?
Shiju Mathews
07/02/2013
    MVC  (17)
#
Title
Author
Entry Date
1
In Visual Studio 2015 projects are throwing an error saying The Microsoft.CodeAnalysis.BuildTasks.Csc task could not be loaded from the assembly...
Shiju Mathews
02/20/2017
2
How to eliminate render-blocking JavaScript and CSS in above-the-fold content when the site is an MVC?
Shiju Mathews
11/20/2016
3
How can I Pass multiple parameters to another action method using RedirectToAction() method?
Shiju Mathews
10/18/2016
4
How do I get the collection of Model State Errors in ASP.NET MVC?
Shiju Mathews
03/25/2016
5
In MVC, how to update the View after the post?
Shiju Mathews
03/25/2016
6
Static Images and CSS Files Not Showing in IIS 7, 7.5, or 8
Shiju Mathews
02/13/2016
7
When I updated the Nuget Packages on a project and deployed to IIS, I am getting an error Says "Failed to load resource: the server responded with a status of 403 (Forbidden)".
Shiju Mathews
02/13/2016
8
How to add multiple RoutePrefixes on a controller in MVC, using Attribute routing?
Shiju Mathews
06/23/2015
9
In MVC Helpers, how to display row html?
Shiju Mathews
02/08/2015
10
What is the diffrece between ActionResult and ViewResult?
Shiju Mathews
10/21/2013
11
How to install MVC 3 on a windows 2008 server, where ASP.Net 4.0 is running on IIS 7.5?
Shiju Mathews
10/19/2013
12
How create a link using action link to pass id parameter in MVC?
Shiju Mathews
10/17/2013
13
How to create a custom ValidationAttribute in MVC 3?
Shiju Mathews
09/18/2013
14
How to add Remote validation to MVC 3.0?
Shiju Mathews
09/18/2013
15
How to create a client side custom ValidationAttribute in MVC 3?
Shiju Mathews
08/18/2013
16
How to add user role to FormsAuthentication in MVC?
Shiju Mathews
07/15/2013
17
MVC project templates not present in my Visual Studio 2010, How to Fix it?
Shiju Mathews
07/08/2013
    ASP.Net  (75)
#
Title
Author
Entry Date
1
What is Restful webservices?
Shiju Mathews
10/04/2017
2
How to configure web.config for site redirection?
Shiju Mathews
11/10/2016
3
What are the different types of testing conducted in software life cycle?
Shiju Mathews
09/20/2016
4
How can I clear all session, cookies and authentication on a ASP.Net web site?
Shiju Mathews
03/30/2016
5
Handling the Client-Side events(JavaScript Events) with Server-Side code.
Shiju Mathews
03/25/2016
6
How to Create a backup for the IIS configuration
Shiju Mathews
09/11/2015
7
How to list all tables from a SQL server Database?
Shiju Mathews
02/14/2015
8
When the Bootstrap templated web site is deployed to production server some images and fonts are missing.
Shiju Mathews
01/23/2014
9
How can we use if and foreach loop in HTML page in ASP.net?
Shiju Mathews
11/04/2013
10
The process cannot access the file because it is being used by another process FROM IIS, Why?
Shiju Mathews
11/01/2013
11
How to Convert XmlReader to String?
Shiju Mathews
10/06/2013
12
What is Entity Framework?
Shiju Mathews
07/07/2013
13
How to access Cookie written in JavaScript on server(code behind)?
Shiju Mathews
01/09/2013
14
How to add page Title, keywords, description meta tags to a web page server head control from code behind?
Shiju Mathews
12/15/2012
15
How to handle the javascript events from a FileUplaod control after the selection is done?
Shiju Mathews
11/27/2012
16
How to check the CPU Usage available RAM in a windows machine using C Sharp?
Shiju Mathews
11/16/2012
17
How to update a row in a asp dot Net Repeater On a button Click from the same row?
Shiju Mathews
10/20/2012
18
What is the difference between ‘file’ and ‘configSource’ using in configuration file for accessing external configuration files?
Shiju Mathews
10/04/2012
19
How web.confg file can Reference an External config File for connecton string?
Shiju Mathews
10/03/2012
20
How web.confg file can Reference an External config File?
Shiju Mathews
10/03/2012
21
Accessing values from connectionStrings element from the configuration file in C SHARP
Shiju Mathews
09/28/2012
22
How to check IIS version using C#
Shiju Mathews
09/06/2012
23
How to resize an image usig c#?
Shiju Mathews
07/24/2012
24
Uplaod files to the web server from User's computer
Shiju Mathews
07/16/2012
25
Convert from String Array to List (Generic List)
Shiju Mathews
07/08/2012
26
Required field for ASP.NET Checkbox
Shiju Mathews
07/01/2012
27
How to bind the ASP.NET Iframe to a URL from Code behind?
Shiju Mathews
04/13/2012
28
Redirecting a non www url to www url
Shiju Mathews
02/20/2012
29
How can page redirect or website redirect be done using the web.config file?
Shiju Mathews
02/02/2012
30
How can a child repeater can access parent data in nested repeater?
Shiju Mathews
11/04/2011
31
How to list the schema names from a SQL Database?
Shiju Mathews
10/18/2011
32
Favicon is not displaying on IE9
Shiju Mathews
10/03/2011
33
How to work with multiple result sets using SqlDataReader?
Shiju Mathews
09/21/2011
34
How to Setup IIS 6.0 on Windows 7 to Allow Classic ASP Sites to Run
Shiju Mathews
09/14/2011
35
How to send Email Using Classic asp
Shiju Mathews
08/22/2011
36
ASP .net Menu in ASP 4.0/ ASP Menu using List Item.
Shiju Mathews
05/10/2011
37
How to access ContentPlaceHolder from Nexted masterpage.
Shiju Mathews
04/25/2011
38
Add a subtotal Row in a asp dot net Repeater control?
Shiju Mathews
03/01/2011
39
Grabbing a value for current row in ItemDataBound of Repeater
Shiju Mathews
02/28/2011
40
Sending mail with Gmail Account using c# in ASP.NET
Shiju Mathews
02/14/2011
41
How to create semi transparent image in Adobe Photoshop.
Shiju Mathews
02/06/2011
42
How to access Master page variable and chang values from a content page?
Shiju Mathews
01/27/2011
43
How to Use nested master page in asp.net?
Shiju Mathews
01/26/2011
44
ASP.Menu (asp dot net menu) to open web pages in a new window.
Shiju Mathews
01/21/2011
45
Session Timeout on IIS 7 when Application pool is updated to ASP.NET 4.0
Shiju Mathews
12/03/2010
46
How can I bind XML to a dropdownlist?
Shiju Mathews
10/21/2010
47
How can I remove all the server cache objects?
Shiju Mathews
10/18/2010
48
How can I list all the server cache objects that are live?
Shiju Mathews
10/18/2010
49
How to Access variables from Global.asax.cs on web pages?
Shiju Mathews
10/13/2010
50
How to check which version of asp.net is running on the IIS server?
Shiju Mathews
10/12/2010
51
How to register ASP.NET on IIS after installing the .NET Framework?
Shiju Mathews
07/21/2010
52
How to retrieve List of Primary Keys and Foreign Keys of Database fom a SQL Server?
Shiju Mathews
07/12/2010
53
How to set a background-image for an html element?
Shiju Mathews
07/08/2010
54
How To Implement Forms-Based Authentication in ASP.NET Application by Using C#.NET and SQL Server
Shiju Mathews
07/06/2010
55
How to access the Item in asp.net Menu and manipulate on the fly?
Shiju Mathews
07/03/2010
56
Overview-Web Development using ASP.NET 4 and Visual Studio 2010
Shiju Mathews
06/29/2010
57
How to create HttpCookie in ASP.net Using c#?
Shiju Mathews
05/04/2010
58
How to Configure Session Time-out (IIS 7)
Shiju Mathews
02/26/2010
59
How to Rotate Ads without Refreshing the Page using AdRotator and ASP.NET AJAX
Shiju Mathews
01/22/2010
60
How can I apply CSS class on an ASP.NET Client Validator
Shiju Mathews
03/17/2009
61
How to add Items ViewState ?
Shiju Mathews
02/15/2009
62
How can I create an ASP.net Repeater which highlight the current row on 'mouseover'?
Shiju Mathews
02/07/2009
63
How to display asp:Menu in IE8
Shiju Mathews
04/24/2008
64
How can access a control in a web form?
Shiju Mathews
03/11/2007
65
How to create Transparent DIV for Firefox, Internet Explorer?
Shiju Mathews
12/03/2005
66
Diffrent methods to add CSS style to a web page
Shiju Mathews
11/24/2012
67
How to create dynamic Controls in ASP.Net
Shiju Mathews
07/23/2012
68
Check if a a particular process is running in a computer?
Shiju Mathews
05/12/2011
69
Adding dynamic links to an ASP.NET WebForm at runtime
Shiju Mathews
07/23/2012
70
301 redirect from asp.net using database table
Shiju Mathews
02/20/2012
71
How to check which version of IIS is running on server?
Shiju Mathews
10/12/2010
72
How to access to a page's Title element using ASP.NET?
Shiju Mathews
06/11/2008
73
How can I use custom entities and classes in aspx pages (not on code behind)?
Shiju Mathews
03/02/2008
74
How to create dotted hyper link in web pages?
Shiju Mathews
05/04/2009
75
How can I Send Emails from web page using Microsoft Outlook
Shiju Mathews
04/14/2001
    C#  (45)
#
Title
Author
Entry Date
1
How to access the value of the Output parameter from a SQL parameter array?
Shiju Mathews
04/27/2016
2
How to replace multiple spaces with a single space in C#?
Shiju Mathews
10/02/2015
3
How to copy properties between two objects using Reflection?
Shiju Mathews
08/19/2014
4
How to convert to 'DateTime' without 'InvalidCastException.' exception?
Shiju Mathews
08/18/2014
5
How to deal with the escape charectors in string when it is converting to xml?
Shiju Mathews
08/11/2014
6
what is the use of as operator in C Sharp?
Shiju Mathews
11/04/2013
7
how to use SQLMetal code generator tool for LINQ to SQL
Shiju Mathews
11/02/2013
8
Wha is lazy operators and greedy operators in LINQ ?
Shiju Mathews
10/28/2013
9
What is the keyword yield in c sharp do?
Shiju Mathews
10/18/2013
10
What is the Take and Skip Operator functionality In LINQ to SQL?
Shiju Mathews
10/16/2013
11
What is the difference between .Net Heap and the Stack?
Shiju Mathews
06/26/2013
12
how to send email with multiple attachments using C Sharp in ASP.NET
Shiju Mathews
11/29/2012
13
What are the diffrence between AND operators in c#?
Shiju Mathews
10/26/2012
14
How App.confg file can Reference an External config File for connecton string?
Shiju Mathews
10/03/2012
15
How App.confg file can Reference an External config File?
Shiju Mathews
10/03/2012
16
Accessing values from appSettings element in C SHARP
Shiju Mathews
09/28/2012
17
How to select time from sql server in AM - PM Format (Meridiem)?
Shiju Mathews
02/23/2012
18
Method Capitalize First Letter of Each Word
Shiju Mathews
02/23/2012
19
String Replacement using RegularExpressions
Shiju Mathews
02/23/2012
20
How to send Email From Dataabse using Transact-SQL Part 2
Shiju Mathews
12/18/2011
21
Standard Date Formats in sql server
Shiju Mathews
12/05/2011
22
How to Join DataTable from a dataset using DataRelation?
Shiju Mathews
10/27/2011
23
How to use Ternary operator in C# ?
Shiju Mathews
10/27/2011
24
Create a desktop shortcut in a Visual studio 2010 Setup project.
Shiju Mathews
04/04/2011
25
Difference between Int32.Parse(), Convert.ToInt32(), and Int32.TryParse()
Shiju Mathews
10/22/2010
26
Improove structurer performance by using StructLayout attribute
Shiju Mathews
10/14/2010
27
What is Managed, Unmanaged, Native Code?
Shiju Mathews
10/13/2010
28
Max and Min int Constants
Shiju Mathews
05/12/2010
29
Special Character Conversion when Writing XML Content using c#
Shiju Mathews
05/06/2010
30
What are the new Features added to c# 4.0
Shiju Mathews
05/01/2010
31
String Format for DateTime [C#]
Shiju Mathews
03/08/2010
32
Common Password Regular Expressions
Shiju Mathews
07/12/2009
33
How to call a stored procedure with table valued parameters in c#?
Shiju Mathews
04/30/2009
34
Email Address Validation using Regular expression
Shiju Mathews
03/01/2007
35
C Sharp/Break and Continue Statement
Shiju Mathews
04/19/2006
36
How can I check the today is a week day or not?
Shiju Mathews
04/19/2005
37
How to compile C sharp files from Command line?
Shiju Mathews
02/23/2003
38
How to Change console foreground color and background color on a c# Application?
Shiju Mathews
04/27/2011
39
How can I set the local time for different time zones?
Shiju Mathews
02/06/2012
40
How to access Windows Registry using c#
Shiju Mathews
02/15/2007
41
How to add default value for a DataColumn of a DataTable?
Shiju Mathews
10/20/2011
42
How do I get the name of the current executable in C#?
Shiju Mathews
02/17/2011
43
How do I specify multiple recipients in an Email using <b>System.Net.Mail</b>?
Shiju Mathews
12/20/2007
44
How to get the Spanish date format using C#?
Shiju Mathews
04/26/2008
45
How Can I Insert Data in a Table Using Stored Procedure
Shiju Mathews
09/30/2010
    Java Script  (13)
#
Title
Author
Entry Date
1
JavaScript lastIndexOf() Method
Shiju Mathews
11/27/2012
2
How to attach a JavaScript event handler on the fly, using JavaScript?
Shiju Mathews
11/01/2012
3
How to change the display using the div element in diffrent layers?
Shiju Mathews
09/23/2012
4
How to change the hyperlink location(href) using JavaScript?
Shiju Mathews
09/23/2012
5
How to change the hyperlink text using JavaScript?
Shiju Mathews
09/23/2012
6
How to convert the hyperlink to a normal text using JavaScript?
Shiju Mathews
09/23/2012
7
How to access Windows username with JavaScript?
Shiju Mathews
08/02/2012
8
How to create help on mouse over on an image
Shiju Mathews
06/29/2012
9
How can I get the Timezone information using Javascript
Shiju Mathews
02/06/2012
10
Making scrolling text effect, using Javascript
Shiju Mathews
09/30/2011
11
Using the window.open method for pop up windows from a web page
Shiju Mathews
05/07/2010
12
Using JavaScript change the class associated with an element.
Shiju Mathews
02/08/2010
13
How to focus on a HTML text box using Javascript?
Shiju Mathews
10/06/2011
    AJAX  (1)
#
Title
Author
Entry Date
1
Dynamic Data display in asp.net web page using jQuery and Ajax.
Shiju Mathews
11/08/2013
    HTML  (7)
#
Title
Author
Entry Date
1
How to block Internet explorer to display the content in Compatibility mode?
Shiju Mathews
01/27/2014
2
How to add a div element with rounded borders?
Shiju Mathews
11/11/2013
3
How to stop and start HTML Marquees on Mouse events
Shiju Mathews
08/10/2013
4
How to set maximum width or height for an image?
Shiju Mathews
01/15/2013
5
How to disable the HTML input element?
Shiju Mathews
12/04/2012
6
How to redirect a web page to another website after a delay?
Shiju Mathews
10/11/2012
7
Making scrolling text and links with the use of the marquee tag
Shiju Mathews
09/28/2011
    JQuery  (14)
#
Title
Author
Entry Date
1
How can I check the check box status using jQuery?
Shiju Mathews
07/15/2016
2
How to remove Title bar on the top of jQueryUI Dialog?
Shiju Mathews
11/05/2013
3
How to remove close button on jQueryUI Dialog?
Shiju Mathews
11/05/2013
4
How do I get the value of a textbox using jQuery?
Shiju Mathews
08/27/2013
5
Why Queryui.com website and demos are not working in my computer?
Shiju Mathews
07/08/2013
6
Chapter 9- jQuery Hide and Show
Shiju Mathews
06/17/2013
7
Chapter 8 - jQuery Event examples
Shiju Mathews
06/17/2013
8
Chapter 7- jQuery Event
Shiju Mathews
06/17/2013
9
Chapter 6 - jQuery Event
Shiju Mathews
06/16/2013
10
Chapter 5 - Selectors in jQuery
Shiju Mathews
06/15/2013
11
Chapter 4 - JQuery Syntax
Shiju Mathews
06/15/2013
12
Chapter 3- Document Ready Function
Shiju Mathews
06/15/2013
13
Chapter 2- How to add JQuery to Your Web Pages?
Shiju Mathews
06/13/2013
14
Chapter 1- What is JQuery?
Shiju Mathews
03/13/2013
    AngularJS  (3)
#
Title
Author
Entry Date
1
What is the use $watch in AngularJS?
Shiju Mathews
04/15/2019
2
How to add AngularJS to a project or File?
Shiju Mathews
09/29/2017
3
What is AngularJS?
Shiju Mathews
09/27/2017
    .NET Core  (8)
#
Title
Author
Entry Date
1
How to Add Form Validation to Core 6 Razor Pages?
Shiju Mathews
01/19/2022
2
What is "_ViewImports.cshtml" in ASP.Net MVC6?
Shiju Mathews
10/22/2017
3
Explain 'Nameof' Operator in c# 6.0?
Shiju Mathews
10/18/2017
4
What is the difference between 'Entity' and 'ViewModel'?
Shiju Mathews
10/16/2017
5
What is the ObjectResult Class in Microsoft.AspNetCore.Mvc?
Shiju Mathews
10/15/2017
6
Web.config and ASP.Net Core?
Shiju Mathews
10/08/2017
7
What is ASP.NET Core?
Shiju Mathews
10/03/2017
8
What is Tag Helpers in ASP.NET Core?
Shiju Mathews
10/03/2017
    SQL Server  (83)
#
Title
Author
Entry Date
1
How to create a SQL server Database Snapshots?
Shiju Mathews
02/28/2017
2
What is SQL server Database Snapshots?
Shiju Mathews
02/28/2017
3
How to find the Column dependency on SQL Server Database?
Shiju Mathews
09/12/2016
4
What is the significance of "QUOTED_IDENTIFIER ON/OFF "in a SQL Server Stored Procedure?
Shiju Mathews
07/29/2016
5
What is the advantage of using "SET NOCOUNT" in a SQL Server Stored Procedure?
Shiju Mathews
07/29/2016
6
IN SQL Server how to get all the Tables with or without Primary Key Constraint?
Shiju Mathews
05/24/2016
7
How to ORDER BY on a select when the sort column data types are different ?
Shiju Mathews
04/26/2016
8
In SQL Server how to reseed table identity value ?
Shiju Mathews
03/26/2016
9
Exception Thrown By The Target Of An Invocation on SQL SERVER Management Studio.
Shiju Mathews
03/26/2016
10
How to find records from one table which don't exist in another table?
Shiju Mathews
12/15/2015
11
How to identify all stored procedures refering a particular table?
Shiju Mathews
12/11/2015
12
How to create a schema if dosen't exist on a database?
Shiju Mathews
12/07/2015
13
SQL Server 2012 Auto Identity Column Value Issue - Missing Values
Shiju Mathews
07/19/2015
14
How to list all tables with a specific column name from a database?
Shiju Mathews
06/17/2015
15
How to create a stored procedure with transaction?
Shiju Mathews
05/12/2015
16
How to remove non numeric characters in SQL server using TSQL?
Shiju Mathews
03/14/2015
17
What is the effect of XACT_ABORT with TRANSACTIONS
Shiju Mathews
03/06/2015
18
How to find the string after the last occurrence of a character in SQL Server?
Shiju Mathews
02/13/2015
19
How to select rows in where one of the column values is in capital letters?
Shiju Mathews
09/02/2014
20
SQL Server LEN() function and blank spaces
Shiju Mathews
08/15/2014
21
where is the Temp tables located in SQL server database?
Shiju Mathews
07/14/2014
22
What is the use of XACT_STATE in try catch blocks?
Shiju Mathews
07/14/2014
23
How to create DIFFERENTIAL back up all the selected databases using SQL script?
Shiju Mathews
07/11/2014
24
How to back up all the selected databases using SQL script?
Shiju Mathews
07/11/2014
25
The MERGE Statement in SQL Server
Shiju Mathews
06/24/2014
26
Format an address in Tsql Using Coalesce?
Shiju Mathews
06/23/2014
27
How do you shrink the SQL Server transaction log?
Shiju Mathews
10/15/2013
28
How to replace while loops with set based solution?
Shiju Mathews
09/29/2013
29
Sql Join or Sub query has better Performance?
Shiju Mathews
09/26/2013
30
How to search for a text in all stored procedure and UDF in the database.
Shiju Mathews
09/16/2013
31
How select the stored procedure name containing a specific text in SQL server?
Shiju Mathews
09/11/2013
32
How to find the dependent table in a stored procedure in SQL server?
Shiju Mathews
09/11/2013
33
How to Clear drop down list of Recent Connection from SQL Server Management Studio ?
Shiju Mathews
02/13/2013
34
How to round Up Time to Nearest Minutes Interval
Shiju Mathews
01/10/2013
35
DELETE, TRUNCATE and RESEED Identity column in SQL Server
Shiju Mathews
01/09/2013
36
How to Reset Identity column in SQL Server?
Shiju Mathews
01/09/2013
37
The EXECUTE permission was denied on the object , database , schema
Shiju Mathews
11/24/2012
38
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON
Shiju Mathews
11/24/2012
39
How to enable Remote Connection on SQL Server 2008 Express
Shiju Mathews
11/13/2012
40
How to reset the Identity column is a SQL Server Data table?
Shiju Mathews
10/28/2012
41
The requested toolbar can not be found - Error from SQL 2008 R2 Management Studio Express
Shiju Mathews
10/21/2012
42
Object Explorer is not appearing on SQL 2008 R2 Management Studio Express
Shiju Mathews
10/21/2012
43
How to list the Stored Procedures by Create Date or Modified Date
Shiju Mathews
10/18/2012
44
Return Values from Stored Procedures inSQLServer
Shiju Mathews
08/23/2012
45
How to convert the last character in a SQL server Column to ASCII value?
Shiju Mathews
08/12/2012
46
Convert ASCII to Decimal and Decimal to ASCII in SQL SERVER
Shiju Mathews
08/12/2012
47
How to updadate GUID in SQL Server table.
Shiju Mathews
06/27/2012
48
How to find out Foreign Key and Primary Key Relationship Constraint in Database?
Shiju Mathews
05/09/2012
49
How can I format the time in AM-PM format (MeridiemTime Format)?
Shiju Mathews
04/17/2012
50
How to list column Name and Type of SQL Server Table ?
Shiju Mathews
04/04/2012
51
What is the use of XACT_ABORT Transact-SQL?
Shiju Mathews
02/07/2012
52
SUBSTRING function in SQL
Shiju Mathews
10/27/2011
53
How to List Schema Name and Table Name for Database in SQL Server
Shiju Mathews
10/18/2011
54
How to ALTER DATABASE to set SINGLE USER - MULTI USER Mode?
Shiju Mathews
10/17/2011
55
How to Add Delay Function – WAITFOR clause in SQL Server scripts?
Shiju Mathews
10/14/2011
56
xml datatype in SQL server
Shiju Mathews
10/05/2011
57
How to generate a HTML table using FOR XML PATH From a Database Table?
Shiju Mathews
04/23/2011
58
How can I get information about the inserted or deleted rows from a table in SQL SERVER?
Shiju Mathews
04/22/2011
59
How to Remove Newline Tab Character in Data using SQL Server
Shiju Mathews
02/08/2011
60
Extended Date Formats in SQL server
Shiju Mathews
01/05/2011
61
New Date Data Types in Microsoft SQL Server 2008.
Shiju Mathews
10/29/2010
62
How do I know which version of SQL Server is running?
Shiju Mathews
09/27/2010
63
How to Add or remove Primary key to/ from an existing table?
Shiju Mathews
07/22/2010
64
How to Insert Values into an Identity Column in SQL Server
Shiju Mathews
07/15/2010
65
How Rename a Column or Table in SQL SERVER
Shiju Mathews
07/14/2010
66
How to drop stored procedure if it exists before creating the stored procedure?
Shiju Mathews
07/13/2010
67
How to drop tables if it exists before creating the table?
Shiju Mathews
07/13/2010
68
What is difference Between GETDATE and SYSDATETIME in SQL Server?
Shiju Mathews
07/12/2010
69
How can I create a string by concatenating a column from a table without using a cursor?
Shiju Mathews
07/01/2010
70
How to find out the week days(Monday- Friday) from a date range
Shiju Mathews
04/23/2010
71
SQL SERVER – Find Monday of the Current Week
Shiju Mathews
04/22/2010
72
Passing table valued parameters in SQL Server 2008
Shiju Mathews
08/27/2009
73
Case Sensitive SQL Query Search in SQL SERVER.
Shiju Mathews
02/13/2012
74
Diffrence between TRUNCATE vs DELETE in SQL Server Deleting commands
Shiju Mathews
02/02/2012
75
Search for Stored Procedures, UDFs, Views and Triggers using Text in SQL Server
Shiju Mathews
10/18/2011
76
How to fill a Cursor from a UDF?
Shiju Mathews
05/10/2011
77
Returns the last-inserted identity value using @@IDENTITY
Shiju Mathews
01/20/2012
78
How to send Email From Dataabse using Transact-SQL Part 1
Shiju Mathews
12/18/2011
79
Changing a Read Only Database to Read/Write mode OR changing a Read/Write database to Read-Only mode
Shiju Mathews
10/17/2011
80
Using Common Table Expressions (CTE) in SQL Server
Shiju Mathews
01/03/2012
81
Error- Cannot drop database, because it is currently in use.
Shiju Mathews
10/17/2011
82
How to create XML Data using T-SQL
Shiju Mathews
10/15/2011
83
How to get only hour from getdate() function in sql server?
Shiju Mathews
08/27/2007
 
Visual Studio Windows/Dos WCF MVC ASP.Net C# Java Script AJAX HTML JQuery AngularJS .NET Core SQL Server