Topics
Started by
Posts
Last post
I recieve a strange error from sql server , Msg 0, Level 11, State 0, Line 0 A severe error occurre…
2 replies
I think this is a crosstab query, but I'm not sure. I have a table: Transactions: TranId TranDat…
9 replies
I got this as a interview question, Can you please tell me if we can write a working SELECT statem…
13 replies
Hi, I want to change the Identity increment value of a column, I Tried with the following command,i…
13 replies
Hello friends i dont why its happening.Below is my table Create table workorder ( WoID nvarch…
3 replies
If you had a single table like this: CREATE TABLE PERSON ( [PersonId] [int] IDENTITY(1,1) NOT N…
9 replies
Hi folks, I wonder if it is possible to script a maintenance plan as well as its schedule into scri…
2 replies
Hello I'm trying to figure out the magic SQL to produce a tricky aggregation. Here's what the sour…
12 replies
Through the search function here, I found how to filter for all occurances of an apostrophe in a co…
1 replies
Hello all, I wonder if following is somehow possible: I'd like to add an extra column to my existin…
14 replies
Hi, Following query has not any errors: DECLARE @phrase VARCHAR(200); SET @phrase = 'book,paper,co…
8 replies
We have daily batch processing system that loads about 7 mln records into a table with 130 columns.…
7 replies
Hello, I have an odd problem that is causing me some frustration. When I execute a CREATE PROC or A…
2 replies
I have 4 database with same structure. we have to integrate it into single database.All 4 database …
1 replies
I have two variables @StartDate and @EndDate I want to write a SELECT Query which can give me rows …
3 replies
Viewing 15 topics - 3,661 through 3,675 (of 12,230 total)
You must be logged in to create new topics.