Topics
Started by
Posts
Last post
Running the following script why i get dbid 32767 for all generated rows SELECT top 10 bucketid, o…
3 replies
I have a situation where the following data is in a table ID Start Date 1 Dec 30 2008 2:47PM 2 …
1 replies
Hi all, I hope there's a simple solution to this, because the complex one is exponentially more in…
11 replies
I have a varchar column using the Latin1_General_BIN collation so that it sorts in ASCII order. Wh…
3 replies
Hello all I have a Text file and i want to restore my database with this file i am using sql 2005 w…
3 replies
I have a table and it has a column called Memo. Some rows in this table have text in memo column, s…
3 replies
I have two variables @sar delared as bigint and @deep declared as int I want to convert bigint to i…
6 replies
I wrote a blog post (for my own reference) about the different types of joins that you can have in…
24 replies
Merry Christmas to All, I need to generate 6 digit random numbers( exectly 6 digit) through sql que…
17 replies
has anyone come up with a way to do error trapping with try catch, where it is a distrubuted transa…
1 replies
I have been searching for the syntax to change the collation on a table that I am inserting into an…
4 replies
create table temp (id int identity(1,1),Name varchar(50)) insert into temp (name) select 'IP 20867 …
5 replies
Hi, I want to do the same i do with DB2: -- Is a example. Need for multiple Joins... with ( values(…
18 replies
SELECT FIELD1 + ' : ' + FIELD2 as CONCATSTRING FROM MYFILE returnes the floowing eror Conversion fa…
1 replies
I read a forum article about writing to a file, but it was within the context of while I was in Que…
5 replies
Viewing 15 topics - 7,921 through 7,935 (of 12,234 total)
You must be logged in to create new topics.