...

...

*I'm working as a senior database administrator for Total System Services Inc. I've more than a decade of IT experience in development, technical training, and database administration on Microsoft SQL Server platforms. I've authored numerous SQL Server ...

...

A step-by-step guide to learn PHP...

Can we use the temporary table created in one procedure from another procedure? The answer depends on how you call the procedure Take this example Create a temporary table in a procedure create procedure proc_1 as create table #t(i int) insert in...

Congratulation sir!!...

...

This is actually a spin-off from a Question of the Day, which appeared in SQLServerCentral (December 16, 2010). A brief History For those of you who have been around in the industry for more than a decade, the term Y2K carries mixed feelings. It was a...

SQL Server interprets two-digit years based on a cutoff year of 2049. That is, the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is interpreted as 1950. SQL Server also provides cutoff configurations but Microsoft recommend usin...