The script can be used to perform any task against all databases hosted on an instance. This is an example script that checks if a user is in a database if it is not then create the user and add it db_datareader role.
2016-02-02 (first published: 2016-01-15)
674 reads
This article depicts how to approach row by row updates needed in a salary table. It might not directly let you increase your salary, but it could help you at review time.
2009-11-26
34,516 reads
2010-06-23 (first published: 2008-12-24)
37,222 reads
i have recently had the need to search the every database on the server for a particular string.
i came up with this... it has lots of room for improvement but it works
2009-08-03 (first published: 2008-11-11)
969 reads
in this scripts there are two methods of creating sample data for a gambling application.
i have used both cursors and loops.
2008-10-10
683 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-09-13
but like your explains i can not search evry day between Getdate() '16:00' and Getdate()+1 '16:00' and in tow different field thnks ilan
2003-07-14
2003-06-27
2003-06-06
Jay, i am using SQL server 7.0 Here's the query and the error results: DELETE FROM WTRDET INNER JOIN ( SELECT Order_NBR ,Line_NBR, MAX(Ship_Date) as MaxShipDate FROM WTRDET GROUP BY Order_NBR ,Line_NBR ) AS dt ON WTRDET.Order_NBR = dt.Order_NBR AND WTRDET.Line_NBR = dt.Line_NBR AND WTRDET.Ship_Date < dt.MaxShipDate Error result: Server: Msg 156, Level 15, State […]
2003-06-05
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers