A blog for Sql Server news ,Sql queries, Sql Stored Procedures ,Sql Triggers, Sql Views by Psingh Choudhary.
http://sqlcodemaster.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
0.2 seconds
16x16
32x32
64x64
128x128
PAGES IN
THIS WEBSITE
18
SSL
EXTERNAL LINKS
25
SITE IP
74.125.225.10
LOAD TIME
0.219 sec
SCORE
6.2
Sql Code Masterz | Sql server | Sql server 2005 | Sql server 2008 | Sql Queries | Sql Procedures | Sql Triggers | Sql Facts and Figures | sqlcodemaster.blogspot.com Reviews
https://sqlcodemaster.blogspot.com
A blog for Sql Server news ,Sql queries, Sql Stored Procedures ,Sql Triggers, Sql Views by Psingh Choudhary.
sqlcodemaster.blogspot.com
Which of the following ranking functions distribute the rows in an ordered partition into a specified number of groups | Sql Code Masterz |Sql server | Sql server 2005 | Sql server 2008| Sql Queries | Sql Procedures | Sql Triggers | S
http://sqlcodemaster.blogspot.com/2012/09/which-of-following-ranking-functions.html
This blog is for developers, they can find answers to some very common and little problems but time consuming ones. If they are missing a logic or are just a step behind, this blog will surely help you achieve. Some very useful and time saving sql queries and much more. Wednesday, September 5, 2012. Which of the following ranking functions distribute the rows in an ordered partition into a specified number of groups. E None of the Above. Subscribe to: Post Comments (Atom). Created by Templates Block.
Sql Code Masterz: 2012-09-02 | Sql server | Sql server 2005 | Sql server 2008 | Sql Queries | Sql Procedures | Sql Triggers | Sql Facts and Figures
http://sqlcodemaster.blogspot.com/2012_09_02_archive.html
This blog is for developers, they can find answers to some very common and little problems but time consuming ones. If they are missing a logic or are just a step behind, this blog will surely help you achieve. Some very useful and time saving sql queries and much more. Wednesday, September 5, 2012. Which of the following ranking functions distribute the rows in an ordered partition into a specified number of groups. E None of the Above. Links to this post. Subscribe to: Posts (Atom).
Sql Code Masterz: 2012-02-19 | Sql server | Sql server 2005 | Sql server 2008 | Sql Queries | Sql Procedures | Sql Triggers | Sql Facts and Figures
http://sqlcodemaster.blogspot.com/2012_02_19_archive.html
This blog is for developers, they can find answers to some very common and little problems but time consuming ones. If they are missing a logic or are just a step behind, this blog will surely help you achieve. Some very useful and time saving sql queries and much more. Thursday, February 23, 2012. How many types of triggers are there in SQL. There are mainily 3 types of triggers. Instead of trigger written on only view. Written on table that gets fired on dml events like insert. That trigger may fire.
Sql Code Masterz: 2012-04-01 | Sql server | Sql server 2005 | Sql server 2008 | Sql Queries | Sql Procedures | Sql Triggers | Sql Facts and Figures
http://sqlcodemaster.blogspot.com/2012_04_01_archive.html
This blog is for developers, they can find answers to some very common and little problems but time consuming ones. If they are missing a logic or are just a step behind, this blog will surely help you achieve. Some very useful and time saving sql queries and much more. Friday, April 6, 2012. Composite key vs Candidate Key vs Alternate Keys. A composite key is a combination of more than one column to identify a unique row in a table. All keys in a table that become unique called as candidate key. Creatin...
@@IDENTITY VS SCOPE_IDENTITY() VS IDENT_CURRENT | Sql Code Masterz |Sql server | Sql server 2005 | Sql server 2008| Sql Queries | Sql Procedures | Sql Triggers | Sql Facts and Figures
http://sqlcodemaster.blogspot.com/2012/06/identity-vs-scopeidentity-vs.html
This blog is for developers, they can find answers to some very common and little problems but time consuming ones. If they are missing a logic or are just a step behind, this blog will surely help you achieve. Some very useful and time saving sql queries and much more. Saturday, June 2, 2012. IDENTITY VS SCOPE IDENTITY() VS IDENT CURRENT. It returns the last IDENTITY value produced on a connection and by a statement in the same scope, regardless of the table that produced the value. It returns the last ...
TOTAL PAGES IN THIS WEBSITE
18
Web Master: June 2012 | Web Master Driver | Asp.Net | Web Development| Website Development | Desktop Development | C# | Web Application | Interview Question
http://webmasterdriver.blogspot.com/2012_06_01_archive.html
Monday, June 4, 2012. How to check string is palindrome or not in .NET. Length = str.Length; str = str.ToLower(); for. I (length / 2. Posted by Pratap Singh. How to generate Fibonacci series in c#. Open a console application project in c# language in your editor and just paste the following code in your class's brackets -. Static void Main(string[] args). Int previous = -1; int next = 1;. Console.WriteLine("Enter the position");. Position = int.Parse(Console.ReadLine() ;. For (int i = 0; i position; i ).
Web Master: May 2012 | Web Master Driver | Asp.Net | Web Development| Website Development | Desktop Development | C# | Web Application | Interview Question
http://webmasterdriver.blogspot.com/2012_05_01_archive.html
Thursday, May 24, 2012. How will implement Page Fragment Caching? How will implement Page Fragment Caching? Page fragment caching involves the caching of a fragment of the page, rather than the entire page. When portions of the page are need to be dynamically created for each user request this is best method as compared to page caching. You can wrap Web Forms user control and cache the control so that these portions of the page don’t need to be recreated each time. Posted by Pratap Singh. Page output cac...
What are the software requirements of ASP.NET MVC4 application? | Web Master | Web Master Driver | Asp.Net | Web Development| Website Development | Desktop Development | C# | Web Application
http://webmasterdriver.blogspot.com/2013/10/what-are-software-requirements-of.html
Wednesday, October 23, 2013. What are the software requirements of ASP.NET MVC4 application? 4 runs on the following Windows client operating systems:. It runs on the following server operating systems:. Windows Server 2008 R2. 4 development tooling is included with Visual Studio 2012 and can be installed on Visual Studio 2010 SP1/Visual Web Developer 2010 Express SP1. Posted by Pratap Singh. Subscribe to: Post Comments (Atom). What is difference between DELETE and TRUNCATE commands? What is JSON Binding?
What is Dependency Resolution? | Web Master | Web Master Driver | Asp.Net | Web Development| Website Development | Desktop Development | C# | Web Application
http://webmasterdriver.blogspot.com/2013/10/what-is-dependency-resolution.html
Wednesday, October 23, 2013. What is Dependency Resolution? What is Dependency Resolution? 3 introduced a new concept called a dependency resolver, which greatly simplified the use of dependency injection in your applications. This made it easier to decouple application components, making them more configurable and easier to test. Support was added for the following scenarios:. Controllers (registering and injecting controller factories, injecting controllers). Model binders (registering and injecting).
What are the various types of Application Templates used to create an MVC application? | Web Master | Web Master Driver | Asp.Net | Web Development| Website Development | Desktop Development | C# | Web Application
http://webmasterdriver.blogspot.com/2013/10/what-are-various-types-of-application.html
Wednesday, October 23, 2013. What are the various types of Application Templates used to create an MVC application? The various templates are as follows:. The Internet Application template: This contains the beginnings of an MVC. Web application — enough so that you can run the application immediately after creating it and see a few pages. This template also includes some basic account management functions which run against the ASP.NET Membership. The Basic template is intended for experienced MVC. The M...
What namespaces MVC use and for what? | Web Master | Web Master Driver | Asp.Net | Web Development| Website Development | Desktop Development | C# | Web Application
http://webmasterdriver.blogspot.com/2013/10/what-namespaces-mvc-use-and-for-what.html
Wednesday, October 23, 2013. What namespaces MVC use and for what? What is namespace of ASP.NET MVC. Namespaces as well as classes are located in assembly. System.Web. Mvc. Some of the content has been taken from various books/articles. What is System.Web. Mvc. This namespace contains classes and interfaces that support the MVC. What is System.Web. Mvc. System.Web. Mvc. Namespace contains classes that supports Ajax scripting in an ASP.NET MVC. What is System.Web. Mvc. System.Web. Mvc. What are the variou...
What is JSON Binding? | Web Master | Web Master Driver | Asp.Net | Web Development| Website Development | Desktop Development | C# | Web Application
http://webmasterdriver.blogspot.com/2013/10/what-is-json-binding.html
Wednesday, October 23, 2013. What is JSON Binding? What is JSON Binding? 3 included JavaScript Object Notation (JSON) binding support via the new. Enabling the action methods to accept and model-bind data in JSON format. This is especially useful in advanced Ajax scenarios like client templates and data binding that need to post data back to the server. Posted by Pratap Singh. Subscribe to: Post Comments (Atom). What is difference between DELETE and TRUNCATE commands? What are Validation Annotations?
Web Master: October 2013 | Web Master Driver | Asp.Net | Web Development| Website Development | Desktop Development | C# | Web Application | Interview Question
http://webmasterdriver.blogspot.com/2013_10_01_archive.html
Wednesday, October 23, 2013. What are Validation Annotations? Data annotations are attributes you can find in. Namespace. These attributes provide server-side validation, and the framework also supports client-side validation when you use one of the attributes on a model property. You can use four attributes in the. Namespace to cover common validation scenarios,. Required, String Length, Regular Expression, Range. Posted by Pratap Singh. When we create a default ASP.NET MVC. Posted by Pratap Singh.
Web Master: August 2012 | Web Master Driver | Asp.Net | Web Development| Website Development | Desktop Development | C# | Web Application | Interview Question
http://webmasterdriver.blogspot.com/2012_08_01_archive.html
Saturday, August 4, 2012. Event Bubbling is nothing but events raised by child controls is handled by the parent control. Example: Suppose consider datagrid as parent control in which there are several child controls.There can be a column of link buttons right.Each link button has click event.Instead of writing event routine for each link button write one routine for parent which will handlde the click events of the child link button events. If (e is CommandEventArgs) {. RaiseBubbleEvent(this, args);.
What are Scaffold templates? | Web Master | Web Master Driver | Asp.Net | Web Development| Website Development | Desktop Development | C# | Web Application
http://webmasterdriver.blogspot.com/2013/10/what-are-scaffold-templates.html
Wednesday, October 23, 2013. What are Scaffold templates? These templates use the Visual Studio T4 templating system to generate a view based on the model type selected. Scaffolding in ASP.NET MVC. Posted by Pratap Singh. Subscribe to: Post Comments (Atom). What is difference between DELETE and TRUNCATE commands? What are Validation Annotations? Trip around the World! What are Validation Annotations? What are Scaffold templates? What namespaces MVC use and for what? What is Dependency Resolution?
TOTAL LINKS TO THIS WEBSITE
25
SQLCODE4YOU
If you want to gain technical knowledge, share it to the world! Wednesday, August 6, 2014. How to change interval for Is-alive? Microsoft Cluster Server (MSCS) uses poll intervals to determine the status of the resources it is protecting. The "Looks Alive" poll occurs frequently, performing a quick check to verify that the resource is still running, while the "Is Alive" poll performs a more comprehensive check of the resource and occurs less frequently. 4 Change to the " Poll Interval. Tab (see Figure 3).
SQL CODE BANK
Wednesday, September 9, 2015. Changes to SQL Server 2014 AlwaysOn Availability Groups. In addition, here are some major enhancements to AlwaysOn Availability Groups in SQL Server 2014 that you might want to be aware of:. Enhanced Availability for Read-Only Replicas. Increased Number of Replicas. Another important enhancement in SQL Server 2014 is the increased maximum number of secondaries. SQL Server 2012 supported a maximum of four secondary replicas. With SQL Server 2014, AlwaysOn Availability...In ad...
Sql Code Bank | Sql hakkında her şey
Sql hakkında her şey. Tsql-t birim testi yapmak için kullanılan ücretsiz bir database yapısıdır. tSQLt kullanarak SQL server 2005 ve üzeri tüm sürümlerde birim testi oluşturulabilir. Sağladığı en büyük kolaylık birim testi yapmak için başka yazılım uygulamaları arasında geçiş yapmayı gerektirmeden, SQL Server üzerinde test yapma imkanı sunmasıdır. tSQLt Temel özellikleri nelerdir? Birim testi transcation içerisinde çalıştırılır. […]. Prapare Data - - - - - - - - - - - -. Result - - - - - - - - - - - -.
SQL Code Guard
To understand code better. Thursday, June 25, 2015. I glad to introduce new member of Express Profiler team - Chris Moore! He has many ideas and eager to implement them. Welcome onboard, Chris! Wednesday, June 24, 2015. SQL Code Guard - Developer build: just as planned. Well, not exactly just as planned, but at last! Fixed unparsed with CONTAINS condition. Fixed xtra "ST010 Use alias for all table sources" for UPDATE/DELETE statements with single FROM clause item. At your own risk, of cours ;). You can m...
SQL Code Guard home
SQL Code Guard is a free solution for SQL Server that provides fast and comprehensive static analysis for T-Sql code, shows code complexity and objects dependencies. Integration with SSMS 2008/2008R2/2012/2014. Integration with Visual Studio 2012/2013. Checkin Policy for TFS ( how to install and use. Support of msbuild ( how to use msbuild. Command line utility ( how to use command line utility. For custom tool development (demo projects can be found in SQL Code Guard folder). SQL Code Guard 2.8. For qui...
Sql Code Masterz | Sql server | Sql server 2005 | Sql server 2008 | Sql Queries | Sql Procedures | Sql Triggers | Sql Facts and Figures
This blog is for developers, they can find answers to some very common and little problems but time consuming ones. If they are missing a logic or are just a step behind, this blog will surely help you achieve. Some very useful and time saving sql queries and much more. Wednesday, October 23, 2013. What is difference between DELETE and TRUNCATE commands? TRUNCATE removes all rows from a table, but the table structure, its columns, constraints, indexes and so on, remains. TRUNCATE cannot be rolled back.
sqlcoders.com
SQL Code Snippets | A place to store and find useful snippets of SQL code.
A place to store and find useful snippets of SQL code. November 10, 2011. Scenario: Being assigned to document an existing system, you need to get column level information on tables including descriptions if they exist. Get me Table Info. CName , Case. System Type Id = 56 Then. System Type Id = 36 Then. System Type Id = 231 Then. System Type ID = 167 Then. System type id = 175 Then. System Type Id = 61 Then. System Type Id = 104 Then. DataType , Case. Is NullAble = 0 Then. NullAble , x.Value As. 1 Copy t...
SQL Coding
Databases are at the heart of many enterprise applications, and it is very important to pay special attention to database programming. Everywhere you'll, from small websites or accounting applications, to the largest analytical applications such as a Web Search Engine, you will find that databases play essential role. SQL is a database computer language designed for retrieval and management of data in relational database management systems. Functionality. Examples of extensions:. SQL/MED, or Management o...
SQLCoffee.com
SQLCoffee.com serving the SQL Server community since August, 2007. This web site is devoted to Microsoft SQL Server content, CLR Integration, high availability, performance tuning and optimization, troubleshooting and tips. How to Install Master Data Services. How to manually uninstall SQL Server. How to Install Master Data Services Add-in for Excel. Running SSIS packages from the Command Prompt. Santo Domingo, Dominican Republic. Send mail to webmaster@sqlcoffee.com.
SOCIAL ENGAGEMENT