Topics
Started by
Posts
Last post
hi guys I need to do a count on a column in my table but i have to check for a condition first. Her…
6 replies
Good day all, I need to join 2 tables from different servers to compare a column. The column is cal…
4 replies
Hi All: I must be overlooking something stupid on this one. I'm trying to create a Foreign Key Con…
7 replies
I have a union query that has two aliases vDay based upon : SELECT convert(varchar, datepart(d…
7 replies
Hello All I am having difficulty when using a primary key in a temp table. Your help would be…
1 replies
Hi experts, I have a stored procedure as following, so how to select top 10 store_num from this sp?…
6 replies
Does anyone know if there is a command used with Alter Table to add a new column in the middle of a…
3 replies
I have the monthname as fieldnames in a table. And the datatype is numeric.It will have values 1 or…
10 replies
Compare both declare @test-2 varchar(10) declare @field varchar(10) SET @field = 'CustomerID' Sel…
1 replies
So what is the difference with the following 2 statements given the fact the SQL Server insternally…
2 replies
When i pass parameters to the where condition of a select qry it takes more time to run, than the s…
14 replies
Hello to All, I recently migrated a mimer database to SQL server. There has been a problem in the m…
2 replies
Hi I was wondering if anyone can help me out. I want to insert/update a time into a datetime field.…
11 replies
declare @table table(ad_num varchar(7), ad_str1 varchar(50)) insert @table (ad_num, ad_str1) value…
2 replies
Why does: Select count(*) from linked.server.table Give me what I'd expect, but: Select count(*) fr…
4 replies
Viewing 15 topics - 6,031 through 6,045 (of 17,082 total)
You must be logged in to create new topics.