Click here to Skip to main content
14,458,109 members
   

Database

 
AnswerRe: writing complex queries in Sql Pin
Eddy Vluggen9-Apr-18 3:16
professionalEddy Vluggen9-Apr-18 3:16 
QuestionConfiguring multiple properties or values in SSIS Package using Package Configuration file Pin
indian1432-Apr-18 15:18
Memberindian1432-Apr-18 15:18 
QuestionTrying to insert values into Table Variable in Dynamic Sql Pin
indian1432-Apr-18 14:17
Memberindian1432-Apr-18 14:17 
AnswerRe: Trying to insert values into Table Variable in Dynamic Sql Pin
Mycroft Holmes2-Apr-18 15:22
MemberMycroft Holmes2-Apr-18 15:22 
GeneralRe: Trying to insert values into Table Variable in Dynamic Sql Pin
indian1433-Apr-18 8:49
Memberindian1433-Apr-18 8:49 
AnswerRe: Trying to insert values into Table Variable in Dynamic Sql Pin
Richard Deeming3-Apr-18 9:44
communityengineerRichard Deeming3-Apr-18 9:44 
GeneralRe: Trying to insert values into Table Variable in Dynamic Sql Pin
indian1434-Apr-18 13:35
Memberindian1434-Apr-18 13:35 
GeneralRe: Trying to insert values into Table Variable in Dynamic Sql Pin
Richard Deeming5-Apr-18 9:06
communityengineerRichard Deeming5-Apr-18 9:06 
If you pass a table valued parameter around, you can't modify the contents. You can only modify it in the procedure where it's declared.

A temp table is definitely the way to go, and there's no danger in dropping it. Each active connection gets its own set of temp tables, so there's no chance of the code executing on one connection affecting a temp table from another connection.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


QuestionMysql database problem Pin
Member 1375522730-Mar-18 19:12
MemberMember 1375522730-Mar-18 19:12 
AnswerRe: Mysql database problem Pin
A_Griffin30-Mar-18 22:41
MemberA_Griffin30-Mar-18 22:41 
GeneralRe: Mysql database problem Pin
Member 1375522730-Mar-18 22:55
MemberMember 1375522730-Mar-18 22:55 
GeneralRe: Mysql database problem Pin
A_Griffin30-Mar-18 23:12
MemberA_Griffin30-Mar-18 23:12 
GeneralRe: Mysql database problem Pin
Victor Nijegorodov30-Mar-18 23:45
MemberVictor Nijegorodov30-Mar-18 23:45 
GeneralRe: Mysql database problem Pin
jschell31-Mar-18 8:29
Memberjschell31-Mar-18 8:29 
GeneralRe: Mysql database problem Pin
Victor Nijegorodov31-Mar-18 21:56
MemberVictor Nijegorodov31-Mar-18 21:56 
AnswerRe: Mysql database problem Pin
jschell31-Mar-18 8:34
Memberjschell31-Mar-18 8:34 
QuestionSSIS package and package in a SQL server agent Job Pin
VK1927-Mar-18 9:27
MemberVK1927-Mar-18 9:27 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
CHill6027-Mar-18 23:09
mveCHill6027-Mar-18 23:09 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
VK1928-Mar-18 3:06
MemberVK1928-Mar-18 3:06 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
CHill6029-Mar-18 13:27
mveCHill6029-Mar-18 13:27 
AnswerRe: SSIS package and package in a SQL server agent Job Pin
#realJSOP29-Mar-18 9:54
mva#realJSOP29-Mar-18 9:54 
QuestionApplication stopped working after backup and restoring the Database with another name Pin
indian14326-Mar-18 9:55
Memberindian14326-Mar-18 9:55 
AnswerRe: Application stopped working after backup and restoring the Database with another name Pin
Richard Deeming26-Mar-18 11:00
communityengineerRichard Deeming26-Mar-18 11:00 
GeneralRe: Application stopped working after backup and restoring the Database with another name Pin
indian14327-Mar-18 7:10
Memberindian14327-Mar-18 7:10 
QuestionSQL server job execution time Pin
VK1922-Mar-18 8:47
MemberVK1922-Mar-18 8:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.