SQL Server Tables

Dumping a table in a SQL Server database

How can you dump a table in a SQL Server database and convert the script into text?

Transposing a table using SQL Server Reporting Services in VB.NET

How can I transpose a table using SQL Server Reporting Services in VB.NET?

Error uploading records into a SQL Server table

We have 700 hundred records, and we wish to upload them into a SQL Server table. After 600 have been uploaded, SQL Server failed to upload the last 100. Why might this have happened?

An alternative to using triggers on a SQL Server

I am using triggers to update two similar tables on a SQL Server. Is there any other method to do this?

Recovering a truncated table on a SQL Server

How can I recover a truncated table on a SQL Server?

Adding an index on fields in a SQL Server table

I have a massive customer table. The ID is the primary key and thus SQL Server makes a clustered index on that. There is no other index on the table. Can I add an index on fields like age, country and gender to make the results faster?

Hiding the system views table from Microsoft Access

How can you hide the system views table from applications like Microsoft Access? For example, whenever I link to tables in our SQL Server database, INFORMATION_SCHEMA and sys system views are included in the list of tables. This prevents us from finding our tables immediately. How can this be done?

Decreasing the unused space of a SQL Server table

How can I decrease the unused space of a SQL Server table which is indexed?

Creating tables on a SQL Server

I am creating a directory of local businesses. I have found that my city is divided in to 4,816 business categories, which means I need that many tables in my database. Is there any way that I can create these table with a stored procedure, a SQL function, or a SQL script file? I want to use a...

Is there a query to retrieve datatypes from SQL stored procedures?

I have used the following simple query to retrieve datatypes from SQL Server 2000 tables: select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = '<tablename>' and column_name =...

Importing SQL Server 2005 tables from one server to another

My developers want to make a copy of a SQL Server 2005 database from one server to another, but due to company policy, I cannot give them the restore permission. So, as of right now, they are importing each table, one by one, from one server to other. Is there a way to import all of them at once?

Stored procedures to script table data in SQL Server 2005

Are there any stored procedures or command line utilities that I can use to script out the data from a particular table in SQL Server 2005?

System tables in SQL Server 2005

What is the role of system tables in SQL Server 2005 and how do you update them?

Writing a hidden trigger against a SQL table

How do I write a hidden trigger against a SQL table?

Writing a report drawing information from a SQL Server 2005 table

I am writing a simple report that displays records from our customer table, a table that has no corresponding records in our contacts table. My code entered in SQL Server 2005 is as follows: select contractor.name,acctstatus, statusDetail, sales_person, loggedInBy,loginDate, lastUpdateBy,...

Unreported error in an order entry application designed in SQL

I have developed an order entry application in SQL Server for a client. One of its functions is to insert invoices into the relevant tables. The procedure only does the job 997 times out of 1000 on average. In a single day, that means that hundreds of invoices are incomplete. No errors are...

Reading the content of a URL into a table in SQL Server 2005 Express

I need to insert the contents of httplog (which is basically http://xx.xx.xx.xx/httplog) into a table in SQL Server 2005 Express. How can I do this? Can I read the contents of httplog directly into the table (with a varchar 1000), or I need to use third party software?

Setting a range constraint without a stored procedure in a SQL Server table

I have a table in SQL Server named CustInfo that is as follows: table CustInfo ( startdate datetime enddate datetime CustomerCode int address nvarchar(200) ) I want to define a range constraint to insure that only one address is allowed for a specific customer in a specific range of dates. For...

Adding columns and updating a SQL table in a reporting database-

My SQL table contains about 80 columns; it is a reporting database, so I update this table data daily from an application database. I need to add 20 more columns, but when I add for the present job, it is not completing. The present job logic is using a permanent table to get all the records at a...

Writing a query to store an image file in a SQL Server 2005 table

How would I write a query to store an image file in a SQL Server 2005 table?