2013-03-20 19:24
A common misconception about DELETE and TRUNCATE statements is that they do the same thing. This is incorrect. In fact, there are many differences between the two. &n&hell…Read More
Blog Directory > Software Blogs > Programming Blogs > Coding Authority | Personal Notes of a Developer programming Blog >
Coding Authority | Personal Notes Of A Developer Blog
codingauthority.wordpress.com
Tags:
table
truncate
hollow
user defined
mph heading
mohsin javaid
logged operation
sql server
production
rest
Personal Notes of a Developer
2013-03-20 19:13
DBCC CHECKIDENT can reset the identity value of a table. Lets say tblUser has 5 rows with last identity as 5, if we want the next identity to be 20 we just need to write
DBCC CHECKID… Read More
2013-03-20 19:01
These questions which I found over the internet are some real brain teasers. Have a go at them ;)
Given a rectangular (cuboidal for the puritans) cake with a rectangular piece removed (any s… Read More
2013-03-20 18:54
Here is a collection of some SQL questions which can be handy in an interview:
What is RDBMS?
What are the Properties of the Relational Tables?
What is Normalization?
What is De-normalizati… Read More
2013-03-20 17:41
After a lot of research here is my take on what are the advantages and disadvantages of BlogSpot and WordPress.
Blogspot
Very light faster access initially possible
Design / Templates selec… Read More
2006-06-07 11:16
The following UDF returns the Days in a month. It is fully functional and works with every date keeping in mind the leap years. CREATE FUNCTION [dbo].[udf_GetNumDaysInMonth] ( @p_DateTime DA… Read More
2006-06-07 11:16
When we start designing our model using Master Data Services it is pertinent that we know how we will receive data from clients. A problem came before me when I had to upload a suppliers lis… Read More
2006-06-07 11:16
The following table lists down the differences between Stored procedures and User Defined Functions. Stored Procedures (SP) User Defined Functions (UDF) Can Return zero or n values. Can retu… Read More
2006-06-07 11:16
A few days back I had the weirdest problem ever. I used a thirdparty grid “Flexigrid” and hooked it up with my custom AMSX webservice. I implemented all Add/Edit/Delete functiona… Read More
Subscribe to Coding Authority | Personal Notes Of A Developer
Get updates delivered right to your inbox!