Topics
Started by
Posts
Last post
Anyone know if it's possible to open a *.sql file from Windows Explorer with Query Analyzer? It's …
2 replies
I hoping for some help on a the below code. I am creating a running total(by day within a month) fr…
1 replies
does anone have a scipt to drop all indexes, then add them back?
3 replies
I have the same user in multiple databases as the table owner. In one of the databases the login n…
2 replies
This statement is from the SQL Server 2000 online book: UPDATE titles SET t.ytd_sales = t.ytd_s…
3 replies
Dear All, We have a requirement to read and execute .sql files, what is the best way of doing this.…
5 replies
The sql statement below works fine. However as you can see the exact same WHERE clause is repeated …
6 replies
I am trying to create either a store procedure or a trigger that records the names of all newly cre…
4 replies
I’m looking to find out how many computers have “Out of Date” antivirus DATs and how many have “In …
2 replies
I have the following stored procedure: CREATE PROCEDURE GetData @ID NVARCHAR(100) AS SELECT Type, …
2 replies
I have a table containing about 2500000 rows out of this i have found that 750 rows have been dupli…
6 replies
My application uses Microsoft Access VBA as the front end to SQL Server. It contains a significant…
7 replies
I adapted Ludo's script http://www.sqlservercentral.com/scripts/contributions/464.asp%5B/url It wor…
16 replies
I tried to provide the user the possibility to change his password. I have written a stored procedu…
2 replies
I can't figure out how to pass a parameter to a stored procedure to select a specific row, like CRE…
2 replies
Viewing 15 topics - 14,656 through 14,670 (of 17,082 total)
You must be logged in to create new topics.