I have a SSIS package which will execute a set of sql commands and some sps. there is one main sp in the pac开发者_开发知识库kage which will execute some sps in loop. But when i scheduled it as job in
I have a database table with HTML sn开发者_如何学Goippets (not whole documents) in a column and I need to do some basic HTML validation of the contents. My initial need is to just be able to run a one
I have implemented the sample forms authenticationfor sql server2008 r2.. I am able to create the users and when i logging with the database user which in the table it i am getting this error..
Here is the scenario I am facing. I have installed Windows 7 Professional on a VMWare. Installed SQL Server 2008 R2.
I have a table that contains three columns. column1column2column3 mytestdatatest myotherdatatest I want to insert \'somestring\' into column3 if column1 contains the value in column2
should be easy: I ha开发者_如何学Cve two tables: table 1 IDNAMENEWID 1DOG 2CAT 3HORSE table 2 NAMEID DOG100
I have 2 tables - 1 with parent records, 1 with child records.For each parent record, I\'m trying to return a single child record with the MAX(SalesPriceEach).
Q: How would I go about using / applying the row number of each 开发者_Go百科row in a query to a certain column in the entire query?
I\'ve just finished my c# application with sql database built in 2008 r2 version I wanted to share this database over LAN and my connection string is :
I have the following SQL sp and I would like to add a column \'NetSales\' which is simply \'GrossSales\' - \'Credits\'.Is there a way to do this in the same SELECT statement?
加载中,请稍侯......