Creating a summary table in SQL Server
I need to create a summary table for the combination of some fields in a SQL Server table. I have the combination field value and the source table name in one SQL table as a row value. I need to pick this value and then fire a query on a source table with extracted values [...]

Answer Question   |  February 19, 2009  6:34 PM
Dynamic SQL, SQL Server tables

Data updation issues in a SQL Server table
I have accidentally updated all data in a SQL Server table according to one data source, and now all my data is a copy of that data. How can I make a command to allow all data in that table to search for other data and update, according to another reference table?

Answer Question   |  February 2, 2009  6:08 PM
SQL Server Data Validation, SQL Server databases, 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?

Answer Question   |  February 5, 2009  5:54 PM
SQL Server databases, SQL Server tables

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?

Answer Question   |  January 21, 2009  6:18 PM
SQL Server Reporting Services, SQL Server tables, SSRS, SSRS Table Transposing, 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?

Answer Question   |  January 22, 2009  6:07 PM
SQL Server errors, SQL Server tables

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?

Answer Question   |  January 22, 2009  5:59 PM
SQL Server tables, SQL Server triggers

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

Answer Question   |  June 25, 2012  5:47 PM
SQL Server backup and restore, SQL Server recovery, SQL Server tables, SQL Server Truncated Table

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?

Answer Question   |  January 15, 2009  5:18 PM
Primary keys, SQL Server index strategy, SQL Server tables

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?

Answer Question   |  December 9, 2009  5:05 PM
Microsoft Access, SQL Server database, SQL Server tables

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

Answer Question   |  January 15, 2009  4:57 PM
SQL Server index strategy, SQL Server tables

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 [...]

Answer Question   |  January 15, 2009  3:29 PM
SQL Server, SQL Server Scripts, SQL Server stored procedures, SQL Server tables

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 = ‘<columnname>’ Along these lines, is there a way to retrieve datatypes from SQL Server stored procedures?

Answer Question   |  January 7, 2009  4:41 PM
SQL Server 2000, SQL Server stored procedures, SQL Server tables

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 [...]

Answer Question   |  January 7, 2009  4:44 PM
SQL Server 2005, SQL Server databases, SQL Server Table Migration, SQL Server tables

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?

Answer Question   |  April 3, 2011  4:54 PM
SQL Server 2005, SQL Server stored procedures, SQL Server tables

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

Answer Question   |  December 13, 2008  4:20 PM
SQL Server 2005, SQL Server System Tables, SQL Server tables, SYSTEM TABLESPACE

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

Answer Question   |  December 13, 2008  7:48 PM
SQL Server tables, Triggers

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, LastUpdateOn from contractor where contractor.name NOT IN (Select company_name from leads_contacts) I keep getting an [...]

Answer Question   |  December 8, 2008  7:25 PM
SQL Server 2005, SQL Server tables

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 reported, no [...]

Answer Question   |  January 9, 2009  6:43 PM
SQL Server stored procedures, SQL Server tables

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?

Answer Question   |  December 2, 2008  4:57 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server Express, SQL Server tables

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 example: 2008-01-01,2008-10-27,11,’13 Lexington st’ [...]

Answer Question   |  December 2, 2008  4:44 PM
SQL Server tables, Stored Procedure Constraints, Stored Procedures