SQL Server database programming

Hello guys, I have a question. Is it possible to pass the table name and column name as variables like this : DECLARE @table sysname DECLARE @tableID int DECLARE @COLNAME  varchar (200) SET @tableID = 196532963 SET @table = dbo.UDF_TABLE_NAME (@tableID) ...

Hi ppl, Regarding the subject, would appreciate your input/feedback.  Thanks. Senario: Database contains tables to keep info on Purchasing, Sales, Customers, etc (normal stuff) Am hoping to use a Transaction Log as a huge reference table where I can ...

Hello.  Would anyone know how to automatically create a new table (not having to define each column and datatype) from a result set of a stored procedure that comes from another sql server that's being linked? Thanks in advance. ...

Hi, I have an .xls file (which is of size 40+ MB). I want to import it into SQL Server 2005 using SSIS packages. I am totally new to that .. can any one help me with that pls? My mgr doesn't want to do it via import/export wizard. ...

but does SELECT TOP 1 or MAX give me back the value/number in the field? I am using a batch and query from the command line with OSQL... so what I will get back is just a number? ...

Hi guys, I have a column that use identity column, and the table includes this column is heavily used for insert and delete. The value of this column gradually increase very big and I am fraid it will be overflowed in the future. I know ...