Viewing 15 posts - 46 through 60 (of 272 total)
It is still not clear what error message you are seeing - Can you post the EXACT error message you are getting please?
Plus the entire create table statement for...
August 2, 2012 at 2:54 am
SQL is very unlike c. It is fundamentally a set based language, so very rare that you need loops and so on.
I think you need a merge statement to...
July 31, 2012 at 5:30 am
In your original question you did say the records had to be INSERTED in to the new table, which is what my statement did.
Can you post full DDL of both...
July 31, 2012 at 1:41 am
Assuming none of the rows you want to insert into emp2 are already in that table then:
insert into emp2(empid)
select empid
...
July 31, 2012 at 12:51 am
Not totally sure what you are asking here, but the actual SQL statements are not written to the log file.
What is written to the log file is copies of the...
July 30, 2012 at 3:28 am
Can you confirm if you mean Microsoft SQL Server or MySQL? This group is about Microsoft SQL server, but you refer to mysql in the question.
If it is SQl Server...
July 24, 2012 at 7:38 am
I suspect the non-functional db was in use at some point during the P2V and is marked as unavailable. Error messages from the sql server log file should give you...
July 18, 2012 at 11:34 pm
Excel can connect direct to SSAS, and many people just use that.
Mike
June 28, 2012 at 1:42 pm
Once committed it is committed.
Unless of course you restore the database from a backup.
Can you descibe more what your concern is?
Mike
June 27, 2012 at 1:30 am
The only time an after trigger may cause trouble with picking up identity values is if inside the after trigger you are inserting into another table (lets call it B)...
June 27, 2012 at 12:09 am
Way too many unknowns for a proper answer I am afraid, but I expect it will be constraiined almost entirely by the slowest link in the chain - which I...
June 21, 2012 at 1:23 am
If am interpreting your question correctly you want to be able to leave parameters to the stored proc null, and have the procedure update the correct row(s) leaving the columns...
June 19, 2012 at 11:34 pm
When you restore the backup all columns it will have the collation as they were in the databse at the time the backuop was created. The fact you have recreated...
June 13, 2012 at 10:01 am
How about ensuring the destination table is on a different filegroup in the database to the source, and that filegroup is mapped to files on different physical discs to the...
June 13, 2012 at 9:54 am
I expect the problem is temp tables, SSRS hits the same problem as SSIS in that it calls the sp initially with options set to just return the column definitions....
June 7, 2012 at 5:05 am
Viewing 15 posts - 46 through 60 (of 272 total)