Wordpress - sqlexplore.wordpress.com - Exploring SQL SERVER With Dilip Kumar Jena
General Information:
Latest News:
SQL Server 2008 – All Time Zones – UTC – IST – Atlantic Time – Eastern Time – Mountain Time – Pacific Time – Alaska Time – Hawai Time 6 Jan 2013 | 01:07 am
Often we encounter problem in converting and storing the correct date time in databases. The major problem comes when we have a web site for specific country or open to all the world and our Server lo...
About SqlExplore – Year 2012 in Review – Overview of Blog 3 Jan 2013 | 11:00 am
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog. Here’s an excerpt: 4,329 films were submitted to the 2012 Cannes Film Festival. This blog had 44,000 views in 2012. ...
SQL SERVER – How to work with Row Constructors , inserted and deleted tables and Handle Result Set 29 Jun 2011 | 04:47 pm
There are many ways to track changes made to the table in SQL Server one of the method is to use inserted and deleted tables and get the result set and use in code appropriately. Step 1: Creating Tab...
We have a table with a CHARACTER data type field. We apply a “>” row comparison between this field and another CHARACTER field in another table. What ... 9 May 2011 | 06:24 am
This is something so many asked me because I also faced the same situation before, so having a NULL in a row when compared will give an UNKNOWN result. The result will not be correct hence creates a...
SQL SERVER – What is the basic difference between a join and a union 6 May 2011 | 06:20 am
A join selects columns from 2 or more tables. A union selects rows. Reference : Dilip Kumar Jena ( http://sqlexplore.wordpress.com
SQL SERVER – CREATE INDEX myIndex ON myTable(myColumn)What type of Index will get created after executing the above statement 4 May 2011 | 05:45 am
Non-clustered index. Important thing to note: By default a clustered index gets created on the primary key, unless specified otherwise. Reference : Dilip Kumar Jena ( http://sqlexplore.wordpress.com ...
SQL SERVER – what are the DBCC commands that are commonly use for database maintenance 2 May 2011 | 06:05 am
DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC SHRINKFILE etc. But there are a whole load of DBCC commands which are very useful for DBAs...
SQL SERVER – What is @@Rowcount, @@Error and @@Identity 1 May 2011 | 05:43 am
@@Rowcount is used to display the number of rows affected by last SQL statement. @@Error displays the error number for the last SQL statement executed. The value is zero,if there is no error. @@iden...
SQL SERVER 2008 – How to rename a column 28 Apr 2011 | 06:10 am
There are many ways where in we can rename a column but what I prefer is using predefined stored Procedure sp_rename . Syntax : exec sp_rename ‘tablename.ColumnName’, ‘NewColumnName’, ‘column’ –ob...
SQL SERVER – What is the difference between group by and order by 27 Apr 2011 | 06:07 am
Group by controls the presentation of the rows, order by controls the presentation of the columns for the results of the SELECT statement. EX 1 : Group By helps us display any aggregate of any colum...
