Topics
Started by
Posts
Last post
Hello, Using AdventureWorks I have to present the customers having the option to select all in a gi…
3 replies
Hi, I am getting error while creating procedure.. I have created ddl trigger on database for proced…
1 replies
if 1,2,3,4 i provide as input, how to generate all the combinations of this number like 1,2,3,4 ; 1…
3 replies
CREATE TABLE demo(ref char(1),seq INT) INSERT INTO demo VALUES ('A',1) INSERT INTO demo VALUES ('A'…
1 replies
Hi friends, Is there any query or table where we can check size of the tables in a DB. I want to ch…
3 replies
Hello, I have sorting problem in SQL for text data. I have data in table like below: ==============…
2 replies
I have a data in the following format: COURSECODE TYPE TIME A …
1 replies
I have created an Update trigger that records data changes to an audit table. This works perfectly…
2 replies
Hi there I am attempting to import a UNIX generated file using SQL Server Bulk Insert command and a…
10 replies
I would like to create a dynamic sql with sp_executesql as followed, but with errors. Please help D…
6 replies
Hi all--Given this query, I need to make this query into a pivot table: select Personnel_id, First …
4 replies
I've created the following table variable and populated it from a CTE named CPERecovered: DECLARE …
12 replies
Hello Everyone Is there a way to assign values to multiple variables with one query? for eaxmple, c…
3 replies
I was trying to find the best way to contenate strings when I came across this solution. Declare @m…
4 replies
HI,I have an issue in Sql Server 2005.I want to create a common search like type any word in the bo…
12 replies
Viewing 15 topics - 3,061 through 3,075 (of 12,234 total)
You must be logged in to create new topics.