tailieunhanh - beginning microsofl sql server 2008 programming phần 2

Cuối cùng, vm_offset bù đắp vào khu vực, và vm_file được sử dụng trong tương quan với lập bản đồ bộ nhớ của Điều này sẽ trở lại chỉ là tập hợp kết quả: Khái niệm về mặc định so với các hạn chế DEFAULT là cực kỳ khó khăn cho rất nhiều người dân để nắm bắt. Sau khi tất cả, họ đã gần như cùng tên. | Chapter 2 Tools of the Trade Figure 2-12 Results to Grid This option divides the columns and rows into a grid arrangement. Following is a list of specific things that this option gives you that the Results to Text doesn t You can resize the column by hovering your mouse pointer on the right border of the column header then clicking and dragging the column border to its new size. Double-clicking the right border results in the autofit for the column. If you select several cells then cut and paste them into another grid say Microsoft Excel they will be treated as individual cells. Under the Results to Text option the cut data is pasted all into one cell. You can select just one or two columns of multiple rows. Under Results to Text if you select several rows all the inner rows have every column selected you can select only in the middle of the row for the first and last row selected. I use this option for almost everything because I find that I usually want one of the benefits I just listed. Results to File Think of this one as largely the same as Results to Text but instead of to screen it routes the output directly to a file. I use this one to generate files I intend to parse using some utility or that I want to easily e-mail. sqlcmd Mode We will discuss sqlcmd a bit more shortly. For now suffice it to say that it is a tool that helps us run queries from a Windows command line. It has some special scripting abilities that are meant specifically for 36 Chapter 2 Tools of the Trade command-line scripting. By default these special script commands are not available in the Query window. Turning sqlcmd mode on activates the special sqlcmd scripting options even in the Query window. Be aware that the Query window always utilizes the SQLNativeClient connection method even when operating in sqlcmd mode whereas the actual sqlcmd utility will use an OLE DB connection. The result is that you may see slight differences in behavior between running a script using sqlcmd versus .

crossorigin="anonymous">
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.