Viewing 15 posts - 6,376 through 6,390 (of 7,164 total)
(2)if file exist,use Script task to split the file into multiple files dynamically, i.e. all ACC records will goes to Accout.txt and so forth.
I would not use a Script Task...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 10:56 am
dankwart menor (5/22/2011)
UPDATE pSET name = i.name,
some_other_field = i.some_other_field
FROM inserted i
JOIN dbo.productsxy p on i.id = p.id ;
And...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 10:32 am
Thanks for the post back. Keep sequences in mind when you upgrade to SQL 11 (code named "Denali")
...you just manually implemented Example D from this article:
http://msdn.microsoft.com/en-us/library/ff878058%28v=SQL.110%29.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 10:08 am
Koen Verbeeck (5/22/2011)
opc.three (5/20/2011)
Also, how...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 9:54 am
Koen Verbeeck (5/22/2011)
http://www.sqlservercentral.com/Forums/Topic999328-148-1.aspx
Point 1: I don't see an issue with that at first sight. I use it myself from time...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 9:54 am
You can do it one statement using the OUTPUT clause. See Example F in this article: http://msdn.microsoft.com/en-us/library/ms177564.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 20, 2011 at 7:35 pm
In relation to users what is the difference between adding users in
Servername>Security>Logins and Servername>Databases>Databasename>Security>Users in the object explorer window of sql server 2005.
To clarify some terminology there are no...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 20, 2011 at 4:20 pm
+1
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 20, 2011 at 3:25 pm
abygaikwad17 (5/19/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 20, 2011 at 3:07 pm
Ed Zann (10/6/2010)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 20, 2011 at 2:09 pm
You're welcome!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 20, 2011 at 11:33 am
Credit to this article:
http://www.sqlservercentral.com/articles/T-SQL/63681/%5B/url%5D
USE tempdb
GO
IF OBJECT_ID(N'tempdb..#SomeTable1') > 0
DROP TABLE #SomeTable1;
GO
CREATE TABLE #SomeTable1
(
AcctNum INT,
InsCode INT,
InsName VARCHAR(100)
)
GO
INSERT INTO #SomeTable1 (AcctNum, InsCode, InsName)
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 20, 2011 at 11:17 am
We are "planning to upgrade soon" even if an SP is not released...but that was not an option in the poll so I answered No :hehe:
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 20, 2011 at 11:01 am
It's not possible because sqlcmd vars and t-sql vars are evaluated independently in different and disparate steps of the execution of a sqlcmd script. This example illustrates:
-- run in SSMS...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 20, 2011 at 9:13 am
dankwart menor (5/19/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 19, 2011 at 10:16 pm
Viewing 15 posts - 6,376 through 6,390 (of 7,164 total)