Viewing 15 posts - 2,971 through 2,985 (of 3,221 total)
Do not allow users direct access to tables by creating views.
Create groups, assign group permissions, assign users to a group.
Use only stored procedures, and when expecting user input use Stored...
July 25, 2008 at 5:25 pm
For a good series of freebie tutorials
SSQL Tutorials
http://msdn.microsoft.com/en-us/library/ms169620.aspx
A specific subject matter tutorial (SQL Server Management Studio)
Try this amongst many others
SSMS
http://msdn.microsoft.com/en-us/library/ms166547.aspx
If your company is willing to pay try this...
July 25, 2008 at 5:03 pm
Sorry I am not even a novice with reporting services, and this is a manual solution but could provide what you want.
In the second sheet of the Excel workbook if...
July 25, 2008 at 2:04 pm
Try something like this:
DECLARE @new AS INT
DECLARE @NewScode AS VARCHAR(150)
DECLARE @Len AS INT -- number of characters to be used
SET @Len = 5 -- assumed to be 5...
July 24, 2008 at 9:27 am
First of all this input data
INSERT INTO [dbo].[propbut_pr] ([HCODE],[SCODE],[STITLE],[SEMPLOYEE],[DHOURLYRATE],
...
July 23, 2008 at 8:51 pm
If you do not want to spend many $$$ for SQL 2005 ... try using the DEVELOPER version.... available from Amazon for 45 to 50 USD depending on what...
July 23, 2008 at 1:58 pm
To have someone guide you to the proper answer, it would help if you posted your question in a meaningful format Please follow the link in my signature and...
July 21, 2008 at 2:10 pm
Jacob Pressures
Here is my code to use a stored procedure to return a Record set.
Public Cnn As ADODB.Connection
Public Cnn_String As String
Public cmd_Param as ADODB.Parameter
Public Rs as ADODB.Recordset
Set Ado_Cmd = New...
July 21, 2008 at 1:48 pm
Jacob what are you using .. VB6 w/ADO, VB dot Net w/ADO dot Net or C# , or C++, VB2005 or?
July 20, 2008 at 8:06 pm
Using dynamic SQL as:
DECLARE @cmd VARCHAR(4000)
DECLARE @currentdate VARCHAR(10)
select @currentdate = convert(varchar(8),getdate(),112)
SET @cmd = 'INSERT INTO OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',
...
July 20, 2008 at 7:08 pm
Read GSquared's reply carefully it says
post the code in the proc
and
insert statements for some sample data.
. What is meant is 10 to 20 rows as a representative sample....
July 20, 2008 at 5:51 pm
Start your reading here:
Data Transformation Services (SQL Server 2000)
DTS Import/Export Wizard
URL: http://msdn.microsoft.com/en-us/library/aa176528(SQL.80).aspx
July 20, 2008 at 12:00 pm
From BOL
The arguments of OPENROWSET and OPENDATASOURCE do not support variables. The arguments must be specified as string-literals. If variables must be passed in as arguments, a query string...
July 20, 2008 at 11:17 am
If your log file was created without a growth factor (either percentage or maximum size )-- a most unusual configuration. That said unless your database has undergone a significant...
July 19, 2008 at 6:30 pm
Would suggest you
First download SQL Server 2005 Express - a free version of SQL 2005 with enough capability to get you started and keep you learning for a substantial period...
July 19, 2008 at 5:01 pm
Viewing 15 posts - 2,971 through 2,985 (of 3,221 total)