Using MS SQL Server

evaluating statement within a parameter for stored procedure
Is is possible to do something like this? (I don't know what the proper terminology is... evaluating statement inline??) exec pr_foo @param = 'a' + 'b' exec pr_foo @param = getdate() I wasn't able to get this to work. I know I can use a local variable do all the manipulation, then pass the local variable, but ... 3 Apr 2008 19:10

Unable to insert database name in sql string
I'm trying to create a procedure that will insert items from multiple (identically structured) databases into a master database table. The first field "Project" in the select string causes an error when the procedure is executed (the procedure itself can be created withouth error). If I hard code a value for "Pr... 3 Apr 2008 18:01

An optimum query..?
Hello friends, I have one simple question. I have two tables. 1 ( Table A ) has about 2.5 million rows and second one ( Table B ) has about 1 million. There are common ID fields in both tables. I want join them on ID field and get all rows of Table A which are not in there Table B. When I ran following two queri... 3 Apr 2008 19:10

boot camp
as far as boot camps in usa are concerned for sqlserver certification, does anyone have a suggestion/recommendation? ... 2 Apr 2008 16:45

tempdb size question
SQL Server 2005 SP2 I know that, for OLTP, the rule of thumb for LOGS is around 25% of database size. What is the rule of thumb for TEMP size? I know that its a good idea (for TEMP) to have .25 to 1 data files per CPU, but how big should TEMP be in total? Whats the rule of thumb there? I would assume its ... 17 Apr 2008 18:08

getting tables that link to a table
Hi, How can I run a query to figure out what tables and corresponding columns link to any column in my table T? Thanks, - Dave ... 2 Apr 2008 16:11

[IAT ELEZIONI] Presentazione candidati
Visto chi ha risposto al thread "Credo che sia ora..." di venerd� scorso ho deciso che i candidIATi per le elezioni di IAT saranno: - Vilco - Abraham Simpson - Yoghurt - FabMind - RedRoby - snowdog Ora potete cominciare a fare le ammucchiate tra voi, fra un po' di giorni aprir� ufficialmente le votazioni... 2 Apr 2008 10:37

Simple Concatenation Question
Here's what I have: SELECT (Term + CRN) AS Comb FROM dbo.SAS Both Term and CRN are Int fields. When it concatenates it is adding the values together. For example: Term CRN Comb 5 18 23 6 11 17 What I want is: Term CRN Comb 5 18 518 6... 2 Apr 2008 10:37

XML vs. Relational Data
I know this question has been asked before but I'm still not clear about the right way to go. Here is the scenario: *SQL Server 2005 *We need to store descriptive information about files that are uploaded for customers. *One or more files can be uploaded for a given customer. Each file is tagged with an infor... 2 Apr 2008 21:22

List Columns in a Table in SQL 2005
Hi, I know sys.tables and sys.columns gives me a list of tables and columns in a SQL 2005 database. How can I list Columns in a specific Table please? Thanks in advance, Ronny ... 2 Apr 2008 15:04