Topics
Started by
Posts
Last post
I have the following batch: declare @tracetable sysname declare @traceid integer declare @dbid inte…
1 replies
hi all, i am using this query now .. select accountid from ca where csid IN (' + @GMCsids + ') but …
4 replies
What is the best way of getting the first and last record of a group? I will use Northwind as an ex…
5 replies
What is the best was to prevent relations similar to the following from happening. Part,Comp 1,2 1,…
10 replies
Do you mean I should use DATALENGTH instead of LEN?
2 replies
set ansi_nulls off go create table t1( f1 varchar(10) null, f2 varchar(10) null) go insert into t1 …
2 replies
Hi, I need to convert the display representation of a varbinary value as varchar. e.g., the result…
2 replies
I am looking for a way to simplify the following query- Clients table has an integer column named C…
15 replies
I am trying to create an extract of contact information from a system where the output is placed in…
3 replies
Hi We are doing UPDATEs inside a cursor. We wanted Declare this cursor as INSENSIVE CURSOR to impro…
2 replies
Hi! I use fn_get_sql() to figure out what sql command caused a table lock. Sometimes the output o…
10 replies
Hi Guys, Can any one suggest that whether i should use NOLOCK optimizer hint in Reporting stored pr…
6 replies
Is there any way to convert MSAccess Security file (MDW) to SQL login with password. I have lots of…
2 replies
I have this rule: ------------------ CREATE RULE org_name AS @value LIKE '[1-10]' -----------------…
7 replies
Can I call another stored procedure from my trigger?
1 replies
Viewing 15 topics - 14,551 through 14,565 (of 17,082 total)
You must be logged in to create new topics.