Viewing 15 posts - 3,001 through 3,015 (of 3,738 total)
thbaig1 (5/19/2011)
@col_name= column name coming rom cursor
@ColValue= will store column value
select @ColValue=@col_name
from dbo.tblBlo
WHERE Customer_no = @CustomerNumber
...
May 19, 2011 at 1:40 pm
You may want to try these to help you get better acquainted with the SQLCMD Utility.
http://databases.about.com/b/2008/10/28/using-sqlcmd-microsoft-sql-servers-command-line-utility.htm
May 19, 2011 at 1:32 pm
prashantcomp90 (5/9/2011)
I am working on sql2005 and I want to create view for one table.
Table details :
table name : groups
fields:
groupnm
debit
credit
and etc.
I want to create view with these three columns....
May 19, 2011 at 1:23 pm
prashantcomp90 (5/19/2011)
which base tables. do mean database tables. but from that how can i get this output. I use parameterized query for that but it wont work properly
You need to...
May 19, 2011 at 1:04 pm
If you don't go into Single User Mode can you exec sqlcmd.exe?
May 19, 2011 at 12:54 pm
prashantcomp90 (5/19/2011)
I am sorry but I relay don’t know about sql views. and this work can not be done without view.
No worries and no need to create a view, just...
May 19, 2011 at 12:49 pm
n.heyen (5/19/2011)
Is it possible to find the pending ALTER TABLE commands issued? For the options that require a reboot like changing file names and locations.
I'm not sure what you mean...
May 19, 2011 at 12:45 pm
Some additional options that you can set to speed up the load:
http://www.sqllion.com/2009/04/faster-extraction-loading-by-ssis
May 19, 2011 at 12:29 pm
patla4u (5/19/2011)
Can i know what is exact differece between (Tables and view)
and (Table and views- fast load).
which is one better in specific area??
(I am note sure so I am asking...
May 19, 2011 at 12:16 pm
Apparently others on this forum ra into this issue:
http://www.sqlservercentral.com/Forums/Topic542765-145-1.aspx
May 19, 2011 at 10:31 am
Sounds like a permissions issue.
What Database roles is your account a member of for the Database Objects that you attempting to access?
May 19, 2011 at 10:24 am
The article list below mentions of number of steps that you can take to speed up execution time:
http://henkvandervalk.com/speeding-up-ssis-bulk-inserts-into-sql-server
May 19, 2011 at 10:16 am
rocky.singh12345 (5/19/2011)
I need to make scripts of all the constraints not to see them.
You are going to have to modify the SELECT Statement provided to you and add strings to...
May 19, 2011 at 9:49 am
It sounds like you do not have all of the permissions needed that you package is trying to reference.
What is in the Job History, Package Log, etc?
Can you run Profiler...
May 19, 2011 at 9:16 am
You are correct SQL Server does not yet have 'DROP UNUSED COLUMNS'.
May 19, 2011 at 9:09 am
Viewing 15 posts - 3,001 through 3,015 (of 3,738 total)