Have just installed SQL Server Express onto a clean machine. I am used to SQL Server 2000 enterprise edition, which I use at work. I opened up SQL Server Express, but all I get to see is configurat...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2253...
Hi,
I am knew to SQL, and I am trying to create the funciton that appeares in the code snippet. However, I am getting errors. The error reads:
Msg 156, Level 15, State 1, Procedure ProductDet...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2304...
Hi,
I am using SQL SERVER EXPRESS
I have a table that contains 5 columns. I need to return all the different (distinct) entries in each column. Can some one show me how to do this?
I know ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23061340.html
Hi,
I am using sql express
Would it be possible to pass the name of a table to a store procedure and base on the name of the pass paramenter, to return all the fields and rows that the table ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23061723.html
hi,
Question 1
I have a table with 4 columns. None of the the columns accept null and the first column is a primary key. how can I alter the table so that the 3rd. column accept null? I need th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23068568.html
how can I get the data type [size] [null or not null], schema from a table columns?
Please, if this is posible, show me an example.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2306...
Hi experts,
I have a multithreaded application which writes from one thread to a SQL Server Express database. The application is stable (collects data 24h/day without interruption, however, after ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22451778.html
Using sql server express
Lets assume that I have a table with a trigger for insert, and I want to insert 50 records into table X one by one. Would the trigger fire every time that a record is in...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2299...
Hi,
what query syntax would i use to query all the user triggers in a database and/or table?
I am using sql server express
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_22997818.html
Hi,
I have a stored procedure that suppost to return tables by a loop, for searching inside sql table by multiple keywords. How I make all these returned tables return as one table with all of t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2309...