Topics
Started by
Posts
Last post
Hi, I'm new in using tsql and I'm puzzled. I'm building a database for a school asignment, but it i…
6 replies
drop table dbo.tab1; create table dbo.tab1 (col1 char(20) NOT NULL default 'E', col2 varchar(20), c…
4 replies
Q1. Is it possible to use any other table apart from Inserted in the Output clause in an insert int…
5 replies
How can I add a column to an existing table that tracks the last time the row was updated, and this…
14 replies
I set up a linked server on my Localhost instance of SQL Server to import an Excel workbook on the …
3 replies
Picture this: DECLARE @test-2 TABLE(Item int, val int) INSERT @test-2 SELECT 1, 90 INSERT @test-…
5 replies
After applying CU5 the following line causes my query to fail when issued against a sql 2000 linked…
6 replies
I have an account number field that has an 10 digit account number in it. What I need to do is add…
7 replies
looking to create function that returns the greatest single number in a fixed series of numbers. S…
3 replies
Hi, I'm trying to generate a table for a binomial law based graphic. Here is a version of one of my…
3 replies
Hi all, Can anyone explore me these two SQL statements - First BEGIN -- 1. DO SOME UPDATE HERE --…
5 replies
hi guys How do I calculate the week number given a date for current year?
18 replies
I have two tables with Table1(Id int) Table2(Name varchar(20)) No of Rows are same. Lets say 10 re…
6 replies
Hi Guys, I have been tasked with de-duplicating data in the company by using a number of different…
6 replies
I have a function in my dll which calls xml from a url passed to it and is supposed to send this ba…
12 replies
Viewing 15 topics - 9,661 through 9,675 (of 10,647 total)
You must be logged in to create new topics.