In MS SQL Server 2014 SP 2, I have a Communication table that is used by many areas of our website to store user notes, comments, and certain email text. The Comments column is defined as nvarchar(4000) and I need to change it to nvarchar(max).
The table has over 250k rows with numerous...
I'm downloading an Excel file in ASP.Net that works in Firefox and IE, but not Chrome.
A link on a calling page opens this page in a new window which generates a spreadsheet, downloads it, then closes the window.
protected void Page_Load(object sender, EventArgs e)
{...
I am beginning a new project and, against my better judgement, we are using SSRS rather than Crystal Reports. I have never been impressed with SSRS but I have use it in a couple of situations where it was just easier to install and let users run reports from the server. But now I am developing...
Thanks for the thoughts.
What is the relevance to PHP? Well, I guess it's only a small tie-in.
<story type='long, boring'>
I have a PHP subroutine that you can pass some data and a css class and it will build an HTML table from that. I've had it for years and it works pretty well. Usually...
I have always tried to keep a separation in my coding (N-tiered development it used to be called; now in .Net it is MVC) but it has recently come up that it can be "better" to store some code inside database tables. This seems REALLY hard to troubleshoot and / or maintain.
Does anybody...
I have a stored procedure that returns the Store, Product Category, Units Sold, & Sales Dollars, but each is reported in different charts.
StoreID ProductCategory FYQuarter Units Sold Sales Dollars
1198 Gloves 2013 - Q1 1 176
1198 Hats 2012 - Q4 18 4410
1198 Shoes 2013 - Q1 8 2460...
Here is the code; it's pretty simple:
var sURL = "Edit/?iAction=2&sGroup=" + sGroupName;
$('#sGroupNameIsValid').load(sURL + ' #div_Results', function(){});
It works just fine...
...until I add a space in the sGroupName variable.
The user enters some text for a new data item. All I want...
We have a really long, complicated stored procedure and, for tracking its progress, we have added PRINT statements showing the current location of the execution.
Like this:
-- Do long SELECT into temp table
PRINT 'Location 1'
-- Update temp table via loop
PRINT 'Location 2'
-- Sequentially...
SQLBill, your link to the book made me LOL that there would be an entire book dedicated to Transaction Logs.
Nevertheless, you are very much on the right track with the database Recovery Mode, which I had not considered.
In SQL 2008 R2, there are Simple, Full, and Bulk-Insert options...
We are revising our data structure from 15 tables with 255 columns each to 1 (or possibly 5) tables with 6 columns each. Pivoting all this data -- or actually, UNpivoting -- is creating a lot of rows and therefore a lot of transactions. On a couple of occasions we filled up the transaction log...
Thanks jbenson001. What you said makes perfect sense, but I couldn't make it happen. It turns out what I thought was just a file server for the images does more than that so they won't let me touch IIS there.
Here's the approach I took. Hopefully someone can use it.
As you said, it has to be a...
This does not seem like it should be that hard, but for some reason I'm stuck.
We have a file server that houses images from several applications and our web server needs to display them. When I add this code, I get a broken image icon.
<asp:Image ID="imgPhoto" runat="server" Width="140px"...
I'm trying to write a counter that uses the alphabet as the count like this:
A
B
...
Y
Z
AA
AB
...
AZ
BA
BB
....
ZY
ZZ
AAA
AAB
Here's my current (incomplete) code. It's a recursive function where you pass in a counter value and it's converted to a letter via Chr(). It's close, but at the...
Sorry, I misunderstood. I didn't take the "SET @value1 =" literally.
Yes, there has to be something after the equals. Otherwise it's an incomplete statement. If you want it to be NULL, that works. "SET @value1 = NULL", but that is like it was never set in the first place.
Try IsNull instead.
SELECT IsNull(@value1, 0)
And under certain circumstances, SQL will bark at you when confusing data types like your example. @value1 was declared as int, but you returned a string. You may need to Convert() it. (Just a caution.)
We are implementing a full-text search in our database and the goal is to be as search engine-like as possible for the user. Unfortunately, it has been difficult finding clearly written information about some of these things involved in the full-text search.
Right now, I am trying to understand...
I'm new to the Create User Wizard so I've done some searching and haven't found the answer to this. I am happy with the way the wizard works and the info it collects, but we want to be in control of who is allowed to log into our site.
Ideally, if the user entered his own data and we were...
You're right.
There's nobody here to look over my shoulder. The problem was that the grid is inside a loginView. I realized it as soon as you said that about the grid (which, indeed, is barebones at this point).
Thanks for the help!
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.