Topics
Started by
Posts
Last post
hello, I have a login on sql server with puplic access and I want it to create users in other datab…
4 replies
I have the statement below, and I am trying to change the date to use November 1st (11/01/2012). Ca…
3 replies
CREATE TABLE product ( ID INT IDENTITY(1,1) ,VAL VARCHAR(MAX) NOT NULL ); INSERTproduct ( VAL )…
1 replies
I have a table with the following structure and need to retrieve only record from the table: Table:…
14 replies
DECLARE @sqlCommand varchar(1000) DECLARE @columnList varchar(75) DECLARE @city varchar(75) SET @co…
7 replies
I recently found when I use query window in SSMS, when I close the tab, it didn't ask me if I want …
3 replies
Hi, I just installed VS 2010 copy I got from college, I know that it comes with SQL Server Express…
1 replies
Hi Forum, As we are on the way to cleaning Production server, we need to find out the last usage da…
5 replies
Hello, I have the records set as follow: COL1COL2COL3 1 120 1130 1141 1151 And …
3 replies
I have a rollup issue where I want to add in a varchar status field. This is coming from a View wh…
4 replies
I have 2 queries that run against the same table. Table is a heap with a GUID PK and has 392780 ro…
1 replies
We have a unique key on 4 columns of a table. I also see there is also a non clustered index create…
2 replies
Hi, I need help in building following logic: Existing dataset: Col1 Col2 Col3 Col4 Col5 Col6 A…
1 replies
Hello All,Thank you all for such a nice platform to discuss issue pertaining to SQL.I have a situat…
1 replies
I need to do a query or join from two tables, but rather than a straight equal, I need SQL to "se…
1 replies
Viewing 15 topics - 5,056 through 5,070 (of 10,640 total)
You must be logged in to create new topics.