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
...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
http://msdn.microsoft.com/en-us/library/ms170207.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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....
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 1:04 pm
If you don't go into Single User Mode can you exec sqlcmd.exe?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 9:16 am
You are correct SQL Server does not yet have 'DROP UNUSED COLUMNS'.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 9:09 am
Viewing 15 posts - 3,001 through 3,015 (of 3,738 total)