sqlserverteam.blogspot.com
SQL Server: November 2008
http://sqlserverteam.blogspot.com/2008_11_01_archive.html
SQL Server - TSQL, Queries, Stored procedure, triggers, tables, views, functions,sql server 2005 features, sql server 2008 features ( Select * from Random Ideas Order By Common Sense ). Sunday, November 30, 2008. Writing Outer Joins in T-SQL. Note: Most of the information in this article can be applied to views as well as tables. For simplicity, the word "table" will be used to mean table or view unless stated otherwise. Keys are not defined on views, but the underlying table’s key column o...LEFT OUTER ...
sqlserverteam.blogspot.com
SQL Server: October 2008
http://sqlserverteam.blogspot.com/2008_10_01_archive.html
SQL Server - TSQL, Queries, Stored procedure, triggers, tables, views, functions,sql server 2005 features, sql server 2008 features ( Select * from Random Ideas Order By Common Sense ). Friday, October 24, 2008. Using Views to Enforce Business Rules. A view is most commonly thought of as a SELECT statement. Most developers will simply create a view to "group" complex SELECT statements for reuse within another view or stored procedures. It makes typing easier! 4 Database (Multiple tables). Let's use an ex...
sqlserverteam.blogspot.com
SQL Server: How to Minimize SQL Server Blocking
http://sqlserverteam.blogspot.com/2009/03/how-to-minimize-sql-server-blocking.html
SQL Server - TSQL, Queries, Stored procedure, triggers, tables, views, functions,sql server 2005 features, sql server 2008 features ( Select * from Random Ideas Order By Common Sense ). Sunday, March 29, 2009. How to Minimize SQL Server Blocking. The syntax for the SET LOCK TIMEOUT is:. SET LOCK TIMEOUT timeout period. Where timeout period is the number of milliseconds that a connection waits for a blocking lock to go away before an error is returned from SQL Server to the application. A value of -1 ...
sqlserverteam.blogspot.com
SQL Server: Is Truncate Table DDL or DML Statement?
http://sqlserverteam.blogspot.com/2014/04/is-truncate-table-ddl-or-dml-statement.html
SQL Server - TSQL, Queries, Stored procedure, triggers, tables, views, functions,sql server 2005 features, sql server 2008 features ( Select * from Random Ideas Order By Common Sense ). Thursday, April 3, 2014. Is Truncate Table DDL or DML Statement? There is an ongoing discussion about this topic. However, if you quickly bingle for this question, you get the impression that the majority is somehow leaning more toward defining the TRUNCATE TABLE statement as a DDL statement. For example, Wikipedia. On th...
sqlserverteam.blogspot.com
SQL Server: Gmail in 5 Indian Languages Hindi, Tamil, Telugu, Kannada and Malayalam
http://sqlserverteam.blogspot.com/2009/03/gmail-in-5-indian-languages-hindi-tamil.html
SQL Server - TSQL, Queries, Stored procedure, triggers, tables, views, functions,sql server 2005 features, sql server 2008 features ( Select * from Random Ideas Order By Common Sense ). Tuesday, March 31, 2009. Gmail in 5 Indian Languages Hindi, Tamil, Telugu, Kannada and Malayalam. Anil, how have things been going? Have you found a new job yet? April 3, 2009 at 11:22 AM. Subscribe to: Post Comments (Atom). Earn xtra money by reading mails. Things borrower must know about Pre Closing Home loan. A view ru...
sqlserverteam.blogspot.com
SQL Server: July 2009
http://sqlserverteam.blogspot.com/2009_07_01_archive.html
SQL Server - TSQL, Queries, Stored procedure, triggers, tables, views, functions,sql server 2005 features, sql server 2008 features ( Select * from Random Ideas Order By Common Sense ). Thursday, July 9, 2009. Google Chrome Operating System. Http:/ googleblog.blogspot.com/2009/07/introducing-google-chrome-os.html. Subscribe to: Posts (Atom). Earn xtra money by reading mails. Things borrower must know about Pre Closing Home loan. Get ready to pay more tax as new HRA exemption rule introduced.
sqlserverteam.blogspot.com
SQL Server: August 2009
http://sqlserverteam.blogspot.com/2009_08_01_archive.html
SQL Server - TSQL, Queries, Stored procedure, triggers, tables, views, functions,sql server 2005 features, sql server 2008 features ( Select * from Random Ideas Order By Common Sense ). Wednesday, August 12, 2009. ISRO unveils mapping application 'Bhuvan'. ISRO will unveil its version of Google Earth, the iconic mapping service for the common man to zoom into any part of the world on their personal computer using satellite images. Http:/ bhuvan2.nrsc.gov.in. Subscribe to: Posts (Atom). As per new circula...
sqlserverteam.blogspot.com
SQL Server: ISRO unveils mapping application 'Bhuvan'
http://sqlserverteam.blogspot.com/2009/08/isro-unveils-mapping-application-bhuvan.html
SQL Server - TSQL, Queries, Stored procedure, triggers, tables, views, functions,sql server 2005 features, sql server 2008 features ( Select * from Random Ideas Order By Common Sense ). Wednesday, August 12, 2009. ISRO unveils mapping application 'Bhuvan'. ISRO will unveil its version of Google Earth, the iconic mapping service for the common man to zoom into any part of the world on their personal computer using satellite images. Http:/ bhuvan2.nrsc.gov.in. Subscribe to: Post Comments (Atom). As per new...
sqlserverteam.blogspot.com
SQL Server: February 2009
http://sqlserverteam.blogspot.com/2009_02_01_archive.html
SQL Server - TSQL, Queries, Stored procedure, triggers, tables, views, functions,sql server 2005 features, sql server 2008 features ( Select * from Random Ideas Order By Common Sense ). Friday, February 13, 2009. Passing a Table to a Stored Procedure. SQL Server 2005 and previous versions do not support passing a table variable to a stored procedure. This article introduces the new feature added to SQL Server 2008, which supports passing a TABLE to a stored procedure or function. There is another view, w...
sqlserverteam.blogspot.com
SQL Server: September 2008
http://sqlserverteam.blogspot.com/2008_09_01_archive.html
SQL Server - TSQL, Queries, Stored procedure, triggers, tables, views, functions,sql server 2005 features, sql server 2008 features ( Select * from Random Ideas Order By Common Sense ). Tuesday, September 30, 2008. Common Table Expression in SQL Server 2005. Types of Common Table Expression. Creating a Common Table Expression. Expression name [ ( column name [ ,.n ] ) ]. CTE query definition ). In the following example, a Common Table Expression "MyCTE" is being defined that has two resulting columns LP ...