Viewing 13 posts - 1 through 13 (of 13 total)
If your import process just inserts new records (ie it does no updates) you can insert records in a temporary table(s) and then copy all records to the real table(s)...
May 23, 2012 at 6:21 am
Without seeing the DB, I can suggest 2 steps:
Check how many records are returned by the query in the cursor declaration.
If 0 rows are returned then the body of the...
May 15, 2012 at 6:57 am
DELETE [002 Shipments Table].*
FROM [002 Shipments Table];
Msg 102, Level 15, State 1, Line 2
Incorrect syntax...
July 2, 2009 at 4:55 am
You can have a look at this article:
http://www.sqlservercentral.com/articles/T-SQL/63681/
ciao
Giacomo
June 23, 2009 at 7:49 am
This is because you are not putting the quotes in the string, and the resulting query is
Update #temp
Set [Server_Name]=linkedserver1
while what you want is
Update #temp
Set [Server_Name]='linkedserver1'
right?
You just have to put quotes...
June 23, 2009 at 5:21 am
ningaraju.n (5/27/2009)
I need find the exact string pattern in an String
For Eg:
my Main String is like this
Declare @STR='I am going to have Asset table
and in...
May 28, 2009 at 4:28 am
syed muhammad naveed (5/27/2009)
if data is still there that match with...
May 27, 2009 at 5:47 am
Sorry to write again about this topic... 🙁
It seems to work but it doesn't work correctly: your solution outputs the list of the aliases but they are not correctly associated...
May 25, 2009 at 10:12 am
Wow! The last part I was missing was using [font="Courier New"]master.dbo.spt_values[/font] ! 🙂
I tested with other views in my DBs and it seems to work fine!
Thank you for your precious...
May 25, 2009 at 9:57 am
Charles Hearn (5/22/2009)
May 25, 2009 at 4:25 am
arun.sas (5/20/2009)
select *,(select name from syscolumns
where id in (select id from sysobjects
where name = View_name)) ALIAS_NAME
from information_schema.view_column_usage
where view_name = 'test_view'
Unfortunately this does not work if the view has more...
May 21, 2009 at 4:16 am
If you have a named instance of SQL server, then the name you have to use is different from the name of the PC. Try BLACKDELL\SQLEXPRESS or BLACKDELL\SQL2005.
Otherwise, you can...
May 11, 2009 at 3:52 am
IF @OptionId -1
BEGIN
INSERT INTO ContestCorrectOption
(ContestId, ContestOptionId)
VALUES ...
May 6, 2009 at 4:43 am
Viewing 13 posts - 1 through 13 (of 13 total)