Forum: MS SQL  9 Days Ago |
| Replies: 1 Views: 505 |
| Forum: MS SQL 30 Days Ago |
| Replies: 1 Views: 505 I have multiple external databases that i want to connect to, from a stored procedure. What server the database is located on is dynamic (a record in a table). All of the external databases are... |
| Forum: Windows Vista and Windows 7 Sep 28th, 2009 |
| Replies: 5 Views: 735 Butifull collection with over 50 Windows 7 wallpapers: http://www.wallpaperweb.org/wallpaper/Computer/Windows-7-Ultimate.html |
| Forum: JavaScript / DHTML / AJAX Aug 3rd, 2009 |
| Replies: 6 Views: 332 Remember that frameset should not use <body> and </body> tag.
Example:
<html>
<frameset cols="25%,*,25%">
<frame src="frame_a.htm" />
<frame src="frame_b.htm" />
<frame... |
| Forum: MS SQL Jul 5th, 2009 |
| Replies: 0 Views: 514 The issue isn't how to use sp_send_dbmail, because i use it everywhere, for both querys and system mails.
But i have one problem, and that is how do you send a mail with HTML and TEXT format?
... |
| Forum: MS SQL Jul 2nd, 2009 |
| Replies: 4 Views: 1,594 Solved, because i don't think there is any "good" solution for the problem.
I was thinking of making the automatical extension of schema based on user rights, because our customers have diffrent... |
| Forum: MS SQL Jul 2nd, 2009 |
| Replies: 4 Views: 1,594 Damit, then I have to try to make the matching in the schema with the split, LEN and match, just to do the debugging a bit easier.
If it was possible to get the exact column, I would like to build... |
| Forum: MS SQL Jul 2nd, 2009 |
| Replies: 4 Views: 1,594 Error message ”[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.” comes when you insert/update a larger value than the column is specified for. But is there a... |
| Forum: MS SQL Jul 2nd, 2009 |
| Replies: 5 Views: 1,160 I'm verry close now.
For INSERT together with OPENROWSET you can use WITH (IGNORE TRIGGERS).
IGNORE_TRIGGERS
Is applicable only in an INSERT statement when the BULK option is used with... |
| Forum: MS SQL Jul 2nd, 2009 |
| Replies: 5 Views: 507 If you "Include Actual Execution Plan" what does it say when you Insert or Update a record?
You could also try to change:
ALTER TRIGGER [dbo].[INS_AlarmsEvents]
ON [dbo].[TEST]
AFTER... |
| Forum: MS SQL Jul 2nd, 2009 |
| Replies: 5 Views: 507 This gode writes ERROR:
BEGIN TRY
SELECT 1/0
END TRY
BEGIN CATCH
PRINT 'ERROR'
END CATCH |
| Forum: MS SQL Jul 1st, 2009 |
| Replies: 7 Views: 950 Classic ASP and text/ntext is pain, but if your running SQL 2005 then you can use varchar(max) insted, i have not experienced any problems i had with ntext after i switched over to varchar(max).
... |
| Forum: MS SQL Jul 1st, 2009 |
| Replies: 5 Views: 507 Your code in the TRY don't fire a error into the catch.
If you run this one you will se that it prints out ERROR:
BEGIN TRY
DECLARE @INT AS INT
SET @INT=CAST(GetDate() AS VARCHAR(2))
END... |
| Forum: MS SQL Jul 1st, 2009 |
| Replies: 5 Views: 1,160 It's kind of same solution I’m implementing now.
I have added a column called "TUpdate" it's a bit column that i set to true in all the different update statements. This solution will not use much... |
| Forum: MS SQL Jul 1st, 2009 |
| Replies: 5 Views: 1,160 Just to be clear, I’m thinking about something like this (except that I want to skip trigger instead of setting the update to only lock current row):
UPDATE <TABLENAME> WITH (ROWLOCK) SET... |
| Forum: MS SQL Jun 30th, 2009 |
| Replies: 4 Views: 392 Sorry but i don't think it's possible in SQL 2008 either, I don’t even think it have been discussed. Most database designers use table names to categorise, and if they don’t then they change to... |
| Forum: MS SQL Jun 30th, 2009 |
| Replies: 1 Views: 390 Try to change:
if(update(ReturnedOn))
To:
IF (SELECT ReturnedOn FROM INSERTED) IS NULL |
| Forum: MS SQL Jun 30th, 2009 |
| Replies: 5 Views: 1,160 I have a INSERT, UPDATE trigger on a table, it works great and helps me from firing a stored procedure from all the (think it's over 50places) where it is needed.
But I have one batch update to... |
| Forum: MS SQL Jun 21st, 2009 |
| Replies: 4 Views: 391 Hi Bporajesh,
This group is for MS SQL, most people here don't have knowledge about MySQL.
If you post your question in the MySQL group, you probably get more help:... |
| Forum: ASP Feb 4th, 2009 |
| Replies: 2 Views: 1,950 There is a couple of unnecessary lines here.
sql = "Insert Into veriler (name) Values ('"&name&"')" 'ADD
sql = "Update veriler Set name='"&name&"' Where id=1" 'UPDATE
sql = "Delete... |
| Forum: JavaScript / DHTML / AJAX Jan 8th, 2009 |
| Replies: 4 Views: 2,164 <div style="text-align:center;">this text will be in center, no mater what.</div> |
| Forum: JavaScript / DHTML / AJAX Dec 19th, 2008 |
| Replies: 2 Views: 3,520 SELECT TOP 1000 * FROM <TABLENAME> ORDER BY ID DESC
But i belive this should have been posted under Database, not JavaScript... |
