SQLServerCentral - Guest Columnist: Divya Agrawal

Finding the Correct Weekday Regardless of DateFirst

In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server. Read more...

By Divya Agrawal 2010/02/19 | Source: SQLServerCentral.com | Category: datefirst

Rating:

|

Discuss |

Briefcase | 6,563 reads

Problem with scripting objects through query

This article from Divya Agrawal might help you to overcome the problem when multiple objects or statements are scripted together. This is technique that can eliminate errors from scripts built dynamically. Read more...

By Divya Agrawal 2009/10/30 | Source: SQLServerCentral.com | Category: incorrect syntax near go

Rating:

|

Discuss |

Briefcase | 1,897 reads

Compatibility issue and CROSS APPLY

This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY Read more...

By Divya Agrawal 2009/08/06 | Source: SQLServerCentral.com | Category: cross apply

Rating:

|

Discuss |

Briefcase | 5,022 reads

Split string using XML

Learn how you can split a delimited string in a single query using XML with Divya Agrawal. Read more...

By Divya Agrawal 2009/06/25 | Source: SQLServerCentral.com | Category: xml

Rating:

|

Discuss |

Briefcase | 10,683 reads

Execute SQL job through batch file

This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file. Read more...

By Divya Agrawal 2009/06/05 | Source: SQLServerCentral.com | Category: jobs

Rating:

|

Discuss |

Briefcase | 13,878 reads