table (15,571)


Check for changes to an SQL Server table?

Check for changes to an SQL Server table?

How can I monitor an SQL Server database for changes to a table without using triggers or modifying the structure of the database in any way? My preferred programming environment is.NET and C#. I'd li…


Decoding T-SQL CAST in C#/VB.NET

Recently our site has been deluged with the resurgence of the Asprox botnet SQL injection attack. Without going into details, the attack attempts to execute SQL code by encoding the T-SQL commands in…


.net - XSD DataSets and ignoring foreign keys

I have a pretty standard table set-up in a current application using the.NET XSD DataSet and TableAdapter features. My contracts table consists of some standard contract information, with a column f…


performance - Most efficient code for the first 10000 prime numbers?

I want to print the first 10000 prime numbers. Can anyone give me the most efficient code for this? Clarifications: It does not matter if your code is inefficient for n>10000. The size of the code doe…


sql - How do I index a database column

Hopefully, I can get answers for each database server. For an outline of how indexing works check out: How does database indexing work?…


php - Mechanisms for tracking DB schema changes

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, argument…


sql server - Can I logically reorder columns in a table?

If I'm adding a column to a table in Microsoft SQL Server, can I control where the column is displayed logically in queries? I don't want to mess with the physical layout of columns on disk, but I wou…


Have you ever encountered a query that SQL Server could not execute because it referenced too many tables?

Have you ever seen any of there error messages?-- SQL Server 2000 Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query(256) was exceeded.-…


actionscript 3 - Using multiple SQLite databases at once

I have 2 SQLite databases, one downloaded from a server(server.db), and one used as storage on the client(client.db). I need to perform various sync queries on the client database, using data from…



What's the best way to determine if a temporary table exists in SQL Server?

When writing a T-SQL script that I plan on re-running, often times I use temporary tables to store temporary data. Since the temp table is created on the fly, I'd like to be able to drop that table…




how sql from column example with data mysql create server