Viewing 15 posts - 14,071 through 14,085 (of 15,381 total)
Take a look at the undocumented procedure sp_MSforeachdb. It will do exactly what you are looking for.
September 8, 2011 at 11:34 am
My boss is very weak when it comes to anything SQL. In fact he insisted that my Customer table have two fields that I thought should have been in another...
September 8, 2011 at 10:16 am
First of all welcome. Great job posting some consumable data and information.
You have a couple issues with this. You can't convert your string formula to float. That is no...
September 8, 2011 at 10:00 am
Selahattin SADOGLU (9/8/2011)
I have some issues with stored procedure on SQL Server 2005.
My Conditions:
1-by date range,
2-according to cari_kod,
3-according to stok_kod,
...
September 8, 2011 at 9:45 am
Replication. It sounds like it is exactly what you are looking for.
September 8, 2011 at 9:25 am
You would need to group by all your columns. You can't do an aggregate function if you don't specify what to group by. If the reason you don't want all...
September 7, 2011 at 8:12 am
ashok.faridabad1984 (9/7/2011)
However there is no harm in having separate column for type and moreever you can have fix length of ID like xxyyyyyyyy where xx can be your type,...
September 7, 2011 at 7:49 am
And converting to utc for historical data gets really complicated if you need it exact due to the daylight saving time changes made in some sections of certain timezones. International...
September 6, 2011 at 1:22 pm
That will work if all the users are in the same timezone as the server. Otherwise you will have to determine which timezone they are in.
Good point about the...
September 6, 2011 at 1:09 pm
So then I for any change, it'd just be a matter of doing a SELECT on the table with the next lowest primary key than the record being viewed as...
September 6, 2011 at 1:03 pm
You would have to know what their time zone offset is from gmt. Then it is just a dateadd.
If the user's timezone is -6gmt then just dateadd(hh, -6, DateField)
September 6, 2011 at 12:35 pm
david.holley (9/6/2011)
Sean Lange (9/6/2011)
September 6, 2011 at 12:26 pm
fyi, the text and ntext datatypes are deprecated. You should instead use varchar(max) or nvarchar(max).
September 6, 2011 at 12:20 pm
These are the exact challenges I was suggesting you would run into in your original thread about these auditing triggers. It is challenging to put these records back together so...
September 6, 2011 at 12:05 pm
@@ROWCOUNT just says how many rows were affected by the last sql statement. So when you try to insert...if @@ROWCOUNT = 0 you need to insert from your second statement....
September 6, 2011 at 11:58 am
Viewing 15 posts - 14,071 through 14,085 (of 15,381 total)