@GMM
1.) At the time, we were only concerned with SP's but I like your suggestion; makes more sense.
2.) This is true...not too sure of a way around it in SQL. I can do it in C#, but haven't figured it out in SQL....gives me something to work on, lol.
@SQLScholar
GREAT program....I use it a...
For years I've been looking for a way to search all the SP's in a specific DB for a specific string. In most cases, it's usually when I'm cleaning up our database and find a table that I think is no longer in use. I then need to search the SP's to make sure the table isn't in use. I believe I...
I need to access a variable from my code behind in the .aspx page and it's not working. Here's what I'm trying:
.aspx page - RequiredFieldValidator
<asp:RequiredFieldValidator ID="rfvEditWebLogin" runat="server"
ControlToValidate="txtWebLogin"...
I've got 2 tables that I need to get data from...my users table looks like this:
Users Table
-------------
UserID
FirstName
LastName
WebLogin
WebPassword
Active
UserAlternates Table
---------------------
UserAlternateID
UserID
AlternateUserID
Users Table Data
------------------
1, John...
I need to write a method that will take a table name as a parameter and generate the SQL statement for creating and inserting the data.
What I'm trying to do is copy a table and it's data to another database but I only need the SQL to do so.
Any ideas?
PK_Issues clustered, unique, primary key located on PRIMARY IssueID
it appears as if that's the only index.
Here's the results from DBCC SHOWCONTIG:
DBCC SHOWCONTIG scanning 'Issues' table...
Table: 'Issues' (530816953); index ID: 1, database ID: 10
TABLE level scan performed.
- Pages...
I've got a large query that has many joins and returns roughly 13k records. I've noticed lately that there's a long pause within the program which this SP is executed, so I decided to run it in the Management Environment to see what's up. Here's the SQL:
SELECT Issues.*, c.CustomerName...
Thanks RTag, but what if this isn't an option for me (it is, I'm just really curious if there's a built-in SP or if someone came up with something to do this)?
I've got a windows app that uses a Crystal Report to show data from our DB. My issue with it is that in code, it requires a Login name and Password for the DB. I do not want to hard-code this info for obvious reasons, so is there a way I can retrieve a password for a specific DB user with SQL...
Thanks guys...I ran the wizard and it fould Full-Text searches needed to be changed (but we don't use them so I think this is ok) and a few Keywords that have depreciated which will need changing. What a life-saver this app is. Thanks for the help! Oh and yes, we ran it in our Staging...
Pretty much what the topic says...we are preparig to upgrade our SQL Server 2000 to 2008 and was curious if there are any hurdles that I should be aware of?
Kostarsus,
Thanks for the help, it pointed me in the right direction. Within the project, if you right-click and choose Properties, then the Publish tab, then Application Files, there's a dialog box that appears. Makes sure to click the "Show all files" checkbox in the lower left corner. The...
I've got some code that stores any errors to our DB and emails us when it happens. Here's the simple call:
catch (Exception ex)
{
if (System.Diagnostics.Debugger.IsAttached)
System.Diagnostics.Debugger.Break();
else...
What is the best practice/approach to writing a SP that returns either a single row or all rows based on the 1 parameter passed in?
Lately we've noticed a need to retrieve either 1 record or all records from tables within our DB (Customer(s), Location(s), Room(s), etc.). So for customers, we...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.