Topics
Started by
Posts
Last post
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
im altering a table in SSMS to remove a foreign key constraing, and re-add it with update cascade e…
3 replies
i all, I have a requirement and unable to solve this problem. I want ur urgent help. The problem is…
3 replies
Hi All, I want to write a script which can work on both SQL 2000 and SQL 2005, the SQL 2000 Script …
3 replies
Hi, I want to compare column names of the Two table that reside in the Different database. Means I …
4 replies
Viewing 15 topics - 7,921 through 7,935 (of 12,230 total)
You must be logged in to create new topics.