sql - Creating SP specific to a database? -

-

every time create stored procedure defaulting "master" database. how make sp specific database "uploads"?

create procedure testinsert2 insert [uploads].dbo.[aspnet_uploads] (userid, filename, username) values  ('test1', 'test2', 'test3')

you need in context of database.

use uploads; go create procedure dbo.testinsert2 begin     set nocount on;      insert dbo.[aspnet_uploads](userid, filename, username)       values('test1', 'test2', 'test3'); end go

Comments

Post a Comment

Popular posts from this blog

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -

-
import pyodbc,nltk,array cnxn = pyodbc.connect('driver={mysql odbc 5.1 driver};server=127.0.0.1;port=3306;database=information_schema;user=root; password=1234;option=3;') cursor = cnxn.cursor() cursor.execute("use collegedatabase ;") cursor.execute("select * sampledata ; ") cnxn.commit() s=[] j=[] x=[] words = [] w = [] sfq = [] pos=[] entry in cursor: s.append(entry.injury_type),j.append(entry.injury_desc) nltk.tokenize import punktwordtokenizer nltk.corpus import stopwords tokenizer = punktwordtokenizer() english_stops = set(stopwords.words('english')) in range(0,26): # filter stop words tokenizer.tokenize(j[i]) w.append([word word in tokenizer.tokenize(j[i]) if word not in english_stops]) in range(0 , 26):#converting tokenzied text ito string sfq.append(" ".join(w[a])) replacers import regexpreplacer replacer = regexpreplacer() in range (0,26):#pos tagging replacer.repl...
Read more

How do I get the nth item in a queue in java? -

-
i have number of queues , priority queues in application. access nth items in these queues, don't see easy way using api. guess create iterator , iterate nth or use toarray()[index]--but seems there should easier way. am missing something? am missing something? yes - fact accessing elements index not part of concept of queue. if need access elements index, want list, not qeue.
Read more

c# - error executing child request for server.transfer with Handler -

-
i have created handler process .html pages in asp.net c# web application. use url rewriting concepts. handler works fine when html requrest come server/website. coding details follows: web.config handler code: <add verb="*" path="*.html," validate="false" type="myproject.contenthandler,myproject" /> contenthandler.cs code: public void processrequest(httpcontext context) { string strmappage = string.empty; if (context.request.url.tostring().contains("category")) { strmappage = "/links.aspx?id=" + producid; } else { strmappage = context.request.url.tostring(); } context.server.transfer(strmappage); } this method works fine .html request page http://localhost:9111/user-category-1.html when try open page '/js/tinymce/imagemanager/index.html' throws error "error execut...
Read more