Topics
Started by
Posts
Last post
Hello, How can I pass or define a variable type table to a store procedure in SQL server? thanks
1 replies
A long time ago, I read that so long as your code/application doesn't mind, you can use the WITH(NO…
1 replies
I was wondering if any one could help me out. I'm trying to spool the results from a tsql script t…
10 replies
I have a table which holds information for each of our salespeople (called 'assoc'). Sales people …
1 replies
I have instead of delete trigger on my primary key table(master). when user delete record from mas…
3 replies
"myName" is a char(5). So the following generates an error under QA. insert mytable (myName) value…
1 replies
Hi everyone,i have another question currently in my database there are 2 tables which basically loo…
1 replies
i have to port a sql statement from mysql to mssql which goes like : select fieldname=1 from table…
2 replies
Hello, I made a store procedure and one view with ENCRYPTION , how can I their text using T-SQL? Th…
3 replies
I have the following SQL statement which uses a regular database view (ACC_BCA_Balance_Calc_Vw) and…
1 replies
HI, is there a way to start sqlagent automatically on a pc with msde which have been installed on w…
1 replies
I have two tables: tblData and tblChangeLog. Data is stored in tblData and changes to that data is …
2 replies
Hey all- been asked to do something, and am having problems. First, my sql takes forever to execut…
1 replies
Please help, I want to build the DECLARE CURSOR statement dynamically. Can anyone tell me how to do…
2 replies
I'm trying to write an osql script using xp_cmdshell. The test script that i'm trying out is: e…
4 replies
Viewing 15 topics - 16,651 through 16,665 (of 17,082 total)
You must be logged in to create new topics.