Topics
Started by
Posts
Last post
Without using 'sp_who' and 'sp_who2' stored procedures, Can I find the process id of blocking …
4 replies
I am new to SQL script and am trying to do a very simple query. I have three tables in a database a…
11 replies
Hello to all. I wonder if I any of you can help me with a simple question. I created a view to read…
2 replies
I have a table containing student course history records, so there are numerous records with the sa…
10 replies
Is there a way to set two variables with ONE select statement? Example: DECLARE @PartDescription va…
2 replies
I have a dynamically genarated query string stored in a temporary table in a column of datatype NTE…
4 replies
Hi all, I have a update statement which will do the update 3 columns from test table to store_table…
4 replies
I have a table with rows where the value in the Period column is 1 - these always exist – DDL/DML b…
16 replies
How can I supress messages being output in Query Analyzer? I found this but I don't see the option …
2 replies
Hello!! Any has a clue on how to Select the two table names involved in a FK constraint? I can only…
3 replies
The following table is a result set I need to filter: POS_NO PC MC MS MV 00011412…
2 replies
I have the following Table CustomerID, SomeString 1, 'SomeText A' 1, 'SomeText B' 1, 'SomeTex…
8 replies
if top 100 returns the first 100 records in a table, how do I get the last 100 records in a table? …
2 replies
SELECT @CLASS_ID = CLASS_ID FROM CLASS_MODULE WHERE YEAR = @YEAR AND SEMESTER = @SEMESTER AND (D…
2 replies
Hello In Access i can build a query that use an alias or more to return calculations values in a fi…
2 replies
Viewing 15 topics - 8,086 through 8,100 (of 17,082 total)
You must be logged in to create new topics.