<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Scripts by Mohit Nayyar
SQLServerCentral.com profile
Items 1 to 14 of 14
Data extrapolation on the fly
Sometimes we need to generate the data based on a given date, to an end date (data extrapolation). This is a easy way to do that without any temporary storage.
Read more...
By
Mohit Nayyar
2008/11/14
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
774 reads
Combine multiple rows into single output
Read more...
By
Mohit Nayyar
2013/05/19
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,486 reads
Get all user def table info
Get space for all user defined table information like size and row counts.
Read more...
By
Mohit Nayyar
2011/06/06
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
6,739 reads
Table row count using 3 different ways
Three different ways that you can get the count of the rows in a table.
Read more...
By
Mohit Nayyar
2011/06/16
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
6,354 reads
Locate primary key - foreign key relations
Read more...
By
Mohit Nayyar
2011/09/14
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,660 reads
To Get Latest SQL Job Status
Read more...
By
Mohit Nayyar
2013/05/19
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
6,592 reads
DB Details - Tables, Rows, Columns, Primary Keys
Read more...
By
Mohit Nayyar
2013/05/19
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
723 reads
Error Handling in SQL Server (like Visual Basic)
Read more...
By
Mohit Nayyar
2013/05/19
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
855 reads
To get Table and column name for Primary Keys.
Read more...
By
Mohit Nayyar
2013/05/19
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,111 reads
Get Triggers for the Table
Read more...
By
Mohit Nayyar
2013/05/19
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
237 reads
Get Relationship for your tables
Read more...
By
Mohit Nayyar
2013/05/19
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
631 reads
To retrieve Stored Procedure Parameters with Description
Read more...
By
Mohit Nayyar
2013/05/19
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
891 reads
Number of days for a given month
Read more...
By
Mohit Nayyar
2013/05/19
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
396 reads
Get the Table Structure using a simple query
Read more...
By
Mohit Nayyar
2013/05/19
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,574 reads
Items 1 to 14 of 14
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
